DBA Data[Home] [Help]

APPS.MSC_X_HZ_UPDATE dependencies on MSC_X_HZ_UPDATE

Line 1: PACKAGE BODY MSC_X_HZ_UPDATE AS

1: PACKAGE BODY MSC_X_HZ_UPDATE AS
2: /* $Header: MSCXHZUB.pls 120.2 2005/07/28 03:38:28 pragarwa noship $ */
3:
4:
5: /**

Line 17: module CONSTANT VARCHAR2(27) := 'msc.plsql.MSC_X_HZ_UPDATE.' ;

13: * order by quantity and createion date.
14: * - update the delta appropriately
15: */
16:
17: module CONSTANT VARCHAR2(27) := 'msc.plsql.MSC_X_HZ_UPDATE.' ;
18: DECPLACES CONSTANT NUMBER := 6;
19:
20:
21: Procedure update_supdem_entries( arg_err_msg OUT NOCOPY VARCHAR2,

Line 349: arg_err_msg := 'MSC_X_HZ_UPDATE@set_for_update ' || SQLERRM;

345: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
346: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_for_update', SQLERRM);
347: end if;
348:
349: arg_err_msg := 'MSC_X_HZ_UPDATE@set_for_update ' || SQLERRM;
350: END set_for_update;
351:
352:
353: /**

Line 753: arg_err_msg := 'MSC_X_HZ_UPDATE@set_for_insert ' || SQLERRM;

749: proceed := 1;
750: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
751: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_for_insert', SQLERRM);
752: end if;
753: arg_err_msg := 'MSC_X_HZ_UPDATE@set_for_insert ' || SQLERRM;
754: --dbms_output.put_line('pkaligot : 50 : arg_err_msg :' || arg_err_msg );
755:
756: END set_for_insert;
757:

Line 1313: arg_err_msg := 'MSC_X_HZ_UPDATE@update ' || SQLERRM;

1309: proceed := 1;
1310: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1311: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'update_supdem_entries', 'update ' || SQLERRM);
1312: end if;
1313: arg_err_msg := 'MSC_X_HZ_UPDATE@update ' || SQLERRM;
1314: END;
1315: end if;
1316:
1317: -- insert into msc_sup_dem_entries.

Line 1370: arg_err_msg := 'MSC_X_HZ_UPDATE@insert ' || SQLERRM;

1366: proceed := 1;
1367: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1368: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'update_supdem_entries', 'insert ' || SQLERRM);
1369: end if;
1370: arg_err_msg := 'MSC_X_HZ_UPDATE@insert ' || SQLERRM;
1371: --dbms_output.put_line(' pkaligot : 203 : ' || arg_err_msg );
1372:
1373: END;
1374: end if;

Line 1396: END MSC_X_HZ_UPDATE;

1392: arg_err_msg := SQLERRM;
1393:
1394: END;
1395:
1396: END MSC_X_HZ_UPDATE;