370: -- C_DUMMY CONSTANT VARCHAR2(30) := ' ';
371:
372: BEGIN
373:
374: l_user_id := xla_environment_pkg.g_usr_id;
375: l_login_id := xla_environment_pkg.g_login_id;
376: l_date := SYSDATE;
377: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
378: l_prog_id := xla_environment_pkg.g_prog_id;
371:
372: BEGIN
373:
374: l_user_id := xla_environment_pkg.g_usr_id;
375: l_login_id := xla_environment_pkg.g_login_id;
376: l_date := SYSDATE;
377: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
378: l_prog_id := xla_environment_pkg.g_prog_id;
379: l_req_id := xla_environment_pkg.g_req_id;
373:
374: l_user_id := xla_environment_pkg.g_usr_id;
375: l_login_id := xla_environment_pkg.g_login_id;
376: l_date := SYSDATE;
377: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
378: l_prog_id := xla_environment_pkg.g_prog_id;
379: l_req_id := xla_environment_pkg.g_req_id;
380:
381: IF g_log_enabled THEN
374: l_user_id := xla_environment_pkg.g_usr_id;
375: l_login_id := xla_environment_pkg.g_login_id;
376: l_date := SYSDATE;
377: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
378: l_prog_id := xla_environment_pkg.g_prog_id;
379: l_req_id := xla_environment_pkg.g_req_id;
380:
381: IF g_log_enabled THEN
382: l_log_module := C_DEFAULT_MODULE||'.move_balances_forward_COMMIT';
375: l_login_id := xla_environment_pkg.g_login_id;
376: l_date := SYSDATE;
377: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
378: l_prog_id := xla_environment_pkg.g_prog_id;
379: l_req_id := xla_environment_pkg.g_req_id;
380:
381: IF g_log_enabled THEN
382: l_log_module := C_DEFAULT_MODULE||'.move_balances_forward_COMMIT';
383: END IF;
1088: l_log_module VARCHAR2 (2000);
1089:
1090: BEGIN
1091:
1092: l_user_id := xla_environment_pkg.g_usr_id;
1093: l_login_id := xla_environment_pkg.g_login_id;
1094: l_date := SYSDATE;
1095: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1096: l_prog_id := xla_environment_pkg.g_prog_id;
1089:
1090: BEGIN
1091:
1092: l_user_id := xla_environment_pkg.g_usr_id;
1093: l_login_id := xla_environment_pkg.g_login_id;
1094: l_date := SYSDATE;
1095: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1096: l_prog_id := xla_environment_pkg.g_prog_id;
1097: l_req_id := xla_environment_pkg.g_req_id;
1091:
1092: l_user_id := xla_environment_pkg.g_usr_id;
1093: l_login_id := xla_environment_pkg.g_login_id;
1094: l_date := SYSDATE;
1095: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1096: l_prog_id := xla_environment_pkg.g_prog_id;
1097: l_req_id := xla_environment_pkg.g_req_id;
1098:
1099: IF g_log_enabled THEN
1092: l_user_id := xla_environment_pkg.g_usr_id;
1093: l_login_id := xla_environment_pkg.g_login_id;
1094: l_date := SYSDATE;
1095: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1096: l_prog_id := xla_environment_pkg.g_prog_id;
1097: l_req_id := xla_environment_pkg.g_req_id;
1098:
1099: IF g_log_enabled THEN
1100: l_log_module := C_DEFAULT_MODULE||'.check_create_period_balances';
1093: l_login_id := xla_environment_pkg.g_login_id;
1094: l_date := SYSDATE;
1095: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1096: l_prog_id := xla_environment_pkg.g_prog_id;
1097: l_req_id := xla_environment_pkg.g_req_id;
1098:
1099: IF g_log_enabled THEN
1100: l_log_module := C_DEFAULT_MODULE||'.check_create_period_balances';
1101: END IF;
1356: l_log_module VARCHAR2 (2000);
1357:
1358: BEGIN
1359:
1360: l_user_id := xla_environment_pkg.g_usr_id;
1361: l_login_id := xla_environment_pkg.g_login_id;
1362: l_date := SYSDATE;
1363: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1364: l_prog_id := xla_environment_pkg.g_prog_id;
1357:
1358: BEGIN
1359:
1360: l_user_id := xla_environment_pkg.g_usr_id;
1361: l_login_id := xla_environment_pkg.g_login_id;
1362: l_date := SYSDATE;
1363: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1364: l_prog_id := xla_environment_pkg.g_prog_id;
1365: l_req_id := xla_environment_pkg.g_req_id;
1359:
1360: l_user_id := xla_environment_pkg.g_usr_id;
1361: l_login_id := xla_environment_pkg.g_login_id;
1362: l_date := SYSDATE;
1363: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1364: l_prog_id := xla_environment_pkg.g_prog_id;
1365: l_req_id := xla_environment_pkg.g_req_id;
1366:
1367: l_id_flex_code := 'GL#';
1360: l_user_id := xla_environment_pkg.g_usr_id;
1361: l_login_id := xla_environment_pkg.g_login_id;
1362: l_date := SYSDATE;
1363: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1364: l_prog_id := xla_environment_pkg.g_prog_id;
1365: l_req_id := xla_environment_pkg.g_req_id;
1366:
1367: l_id_flex_code := 'GL#';
1368:
1361: l_login_id := xla_environment_pkg.g_login_id;
1362: l_date := SYSDATE;
1363: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1364: l_prog_id := xla_environment_pkg.g_prog_id;
1365: l_req_id := xla_environment_pkg.g_req_id;
1366:
1367: l_id_flex_code := 'GL#';
1368:
1369: IF g_log_enabled THEN
3219: l_log_module VARCHAR2 (2000);
3220:
3221: BEGIN
3222:
3223: l_user_id := xla_environment_pkg.g_usr_id;
3224: l_login_id := xla_environment_pkg.g_login_id;
3225: l_date := SYSDATE;
3226: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3227: l_prog_id := xla_environment_pkg.g_prog_id;
3220:
3221: BEGIN
3222:
3223: l_user_id := xla_environment_pkg.g_usr_id;
3224: l_login_id := xla_environment_pkg.g_login_id;
3225: l_date := SYSDATE;
3226: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3227: l_prog_id := xla_environment_pkg.g_prog_id;
3228: l_req_id := xla_environment_pkg.g_req_id;
3222:
3223: l_user_id := xla_environment_pkg.g_usr_id;
3224: l_login_id := xla_environment_pkg.g_login_id;
3225: l_date := SYSDATE;
3226: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3227: l_prog_id := xla_environment_pkg.g_prog_id;
3228: l_req_id := xla_environment_pkg.g_req_id;
3229:
3230: IF g_log_enabled THEN
3223: l_user_id := xla_environment_pkg.g_usr_id;
3224: l_login_id := xla_environment_pkg.g_login_id;
3225: l_date := SYSDATE;
3226: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3227: l_prog_id := xla_environment_pkg.g_prog_id;
3228: l_req_id := xla_environment_pkg.g_req_id;
3229:
3230: IF g_log_enabled THEN
3231: l_log_module := C_DEFAULT_MODULE||'.move_identified_bals_forward';
3224: l_login_id := xla_environment_pkg.g_login_id;
3225: l_date := SYSDATE;
3226: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3227: l_prog_id := xla_environment_pkg.g_prog_id;
3228: l_req_id := xla_environment_pkg.g_req_id;
3229:
3230: IF g_log_enabled THEN
3231: l_log_module := C_DEFAULT_MODULE||'.move_identified_bals_forward';
3232: END IF;
8039: l_log_module VARCHAR2 (2000);
8040:
8041: BEGIN
8042:
8043: l_user_id := xla_environment_pkg.g_usr_id;
8044: l_login_id := xla_environment_pkg.g_login_id;
8045: l_date := SYSDATE;
8046: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8047: l_prog_id := xla_environment_pkg.g_prog_id;
8040:
8041: BEGIN
8042:
8043: l_user_id := xla_environment_pkg.g_usr_id;
8044: l_login_id := xla_environment_pkg.g_login_id;
8045: l_date := SYSDATE;
8046: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8047: l_prog_id := xla_environment_pkg.g_prog_id;
8048: l_req_id := xla_environment_pkg.g_req_id;
8042:
8043: l_user_id := xla_environment_pkg.g_usr_id;
8044: l_login_id := xla_environment_pkg.g_login_id;
8045: l_date := SYSDATE;
8046: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8047: l_prog_id := xla_environment_pkg.g_prog_id;
8048: l_req_id := xla_environment_pkg.g_req_id;
8049: IF g_log_enabled THEN
8050: l_log_module := C_DEFAULT_MODULE||'.recreation_common';
8043: l_user_id := xla_environment_pkg.g_usr_id;
8044: l_login_id := xla_environment_pkg.g_login_id;
8045: l_date := SYSDATE;
8046: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8047: l_prog_id := xla_environment_pkg.g_prog_id;
8048: l_req_id := xla_environment_pkg.g_req_id;
8049: IF g_log_enabled THEN
8050: l_log_module := C_DEFAULT_MODULE||'.recreation_common';
8051: END IF;
8044: l_login_id := xla_environment_pkg.g_login_id;
8045: l_date := SYSDATE;
8046: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8047: l_prog_id := xla_environment_pkg.g_prog_id;
8048: l_req_id := xla_environment_pkg.g_req_id;
8049: IF g_log_enabled THEN
8050: l_log_module := C_DEFAULT_MODULE||'.recreation_common';
8051: END IF;
8052: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
8654: l_log_module VARCHAR2 (2000);
8655:
8656: BEGIN
8657:
8658: l_user_id := xla_environment_pkg.g_usr_id;
8659: l_login_id := xla_environment_pkg.g_login_id;
8660: l_date := SYSDATE;
8661: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8662: l_prog_id := xla_environment_pkg.g_prog_id;
8655:
8656: BEGIN
8657:
8658: l_user_id := xla_environment_pkg.g_usr_id;
8659: l_login_id := xla_environment_pkg.g_login_id;
8660: l_date := SYSDATE;
8661: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8662: l_prog_id := xla_environment_pkg.g_prog_id;
8663: l_req_id := xla_environment_pkg.g_req_id;
8657:
8658: l_user_id := xla_environment_pkg.g_usr_id;
8659: l_login_id := xla_environment_pkg.g_login_id;
8660: l_date := SYSDATE;
8661: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8662: l_prog_id := xla_environment_pkg.g_prog_id;
8663: l_req_id := xla_environment_pkg.g_req_id;
8664:
8665: IF g_log_enabled THEN
8658: l_user_id := xla_environment_pkg.g_usr_id;
8659: l_login_id := xla_environment_pkg.g_login_id;
8660: l_date := SYSDATE;
8661: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8662: l_prog_id := xla_environment_pkg.g_prog_id;
8663: l_req_id := xla_environment_pkg.g_req_id;
8664:
8665: IF g_log_enabled THEN
8666: l_log_module := C_DEFAULT_MODULE||'.recreation_detailed';
8659: l_login_id := xla_environment_pkg.g_login_id;
8660: l_date := SYSDATE;
8661: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8662: l_prog_id := xla_environment_pkg.g_prog_id;
8663: l_req_id := xla_environment_pkg.g_req_id;
8664:
8665: IF g_log_enabled THEN
8666: l_log_module := C_DEFAULT_MODULE||'.recreation_detailed';
8667: END IF;
8989: l_log_module VARCHAR2 (2000);
8990:
8991: BEGIN
8992:
8993: l_user_id := xla_environment_pkg.g_usr_id;
8994: l_login_id := xla_environment_pkg.g_login_id;
8995: l_date := SYSDATE;
8996: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8997: l_prog_id := xla_environment_pkg.g_prog_id;
8990:
8991: BEGIN
8992:
8993: l_user_id := xla_environment_pkg.g_usr_id;
8994: l_login_id := xla_environment_pkg.g_login_id;
8995: l_date := SYSDATE;
8996: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8997: l_prog_id := xla_environment_pkg.g_prog_id;
8998: l_req_id := xla_environment_pkg.g_req_id;
8992:
8993: l_user_id := xla_environment_pkg.g_usr_id;
8994: l_login_id := xla_environment_pkg.g_login_id;
8995: l_date := SYSDATE;
8996: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8997: l_prog_id := xla_environment_pkg.g_prog_id;
8998: l_req_id := xla_environment_pkg.g_req_id;
8999:
9000: IF g_log_enabled THEN
8993: l_user_id := xla_environment_pkg.g_usr_id;
8994: l_login_id := xla_environment_pkg.g_login_id;
8995: l_date := SYSDATE;
8996: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8997: l_prog_id := xla_environment_pkg.g_prog_id;
8998: l_req_id := xla_environment_pkg.g_req_id;
8999:
9000: IF g_log_enabled THEN
9001: l_log_module := C_DEFAULT_MODULE||'.recreation_massive';
8994: l_login_id := xla_environment_pkg.g_login_id;
8995: l_date := SYSDATE;
8996: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8997: l_prog_id := xla_environment_pkg.g_prog_id;
8998: l_req_id := xla_environment_pkg.g_req_id;
8999:
9000: IF g_log_enabled THEN
9001: l_log_module := C_DEFAULT_MODULE||'.recreation_massive';
9002: END IF;
9438: l_log_module VARCHAR2 (2000);
9439:
9440: BEGIN
9441:
9442: l_user_id := xla_environment_pkg.g_usr_id;
9443: l_login_id := xla_environment_pkg.g_login_id;
9444: l_date := SYSDATE;
9445: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9446: l_prog_id := xla_environment_pkg.g_prog_id;
9439:
9440: BEGIN
9441:
9442: l_user_id := xla_environment_pkg.g_usr_id;
9443: l_login_id := xla_environment_pkg.g_login_id;
9444: l_date := SYSDATE;
9445: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9446: l_prog_id := xla_environment_pkg.g_prog_id;
9447: l_req_id := xla_environment_pkg.g_req_id;
9441:
9442: l_user_id := xla_environment_pkg.g_usr_id;
9443: l_login_id := xla_environment_pkg.g_login_id;
9444: l_date := SYSDATE;
9445: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9446: l_prog_id := xla_environment_pkg.g_prog_id;
9447: l_req_id := xla_environment_pkg.g_req_id;
9448:
9449: l_id_flex_code := 'GL#';
9442: l_user_id := xla_environment_pkg.g_usr_id;
9443: l_login_id := xla_environment_pkg.g_login_id;
9444: l_date := SYSDATE;
9445: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9446: l_prog_id := xla_environment_pkg.g_prog_id;
9447: l_req_id := xla_environment_pkg.g_req_id;
9448:
9449: l_id_flex_code := 'GL#';
9450:
9443: l_login_id := xla_environment_pkg.g_login_id;
9444: l_date := SYSDATE;
9445: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9446: l_prog_id := xla_environment_pkg.g_prog_id;
9447: l_req_id := xla_environment_pkg.g_req_id;
9448:
9449: l_id_flex_code := 'GL#';
9450:
9451: IF g_log_enabled THEN
10166: l_log_module VARCHAR2 (2000);
10167:
10168: BEGIN
10169:
10170: l_user_id := xla_environment_pkg.g_usr_id;
10171: l_login_id := xla_environment_pkg.g_login_id;
10172: l_date := SYSDATE;
10173: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10174: l_prog_id := xla_environment_pkg.g_prog_id;
10167:
10168: BEGIN
10169:
10170: l_user_id := xla_environment_pkg.g_usr_id;
10171: l_login_id := xla_environment_pkg.g_login_id;
10172: l_date := SYSDATE;
10173: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10174: l_prog_id := xla_environment_pkg.g_prog_id;
10175: l_req_id := xla_environment_pkg.g_req_id;
10169:
10170: l_user_id := xla_environment_pkg.g_usr_id;
10171: l_login_id := xla_environment_pkg.g_login_id;
10172: l_date := SYSDATE;
10173: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10174: l_prog_id := xla_environment_pkg.g_prog_id;
10175: l_req_id := xla_environment_pkg.g_req_id;
10176:
10177: IF g_log_enabled THEN
10170: l_user_id := xla_environment_pkg.g_usr_id;
10171: l_login_id := xla_environment_pkg.g_login_id;
10172: l_date := SYSDATE;
10173: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10174: l_prog_id := xla_environment_pkg.g_prog_id;
10175: l_req_id := xla_environment_pkg.g_req_id;
10176:
10177: IF g_log_enabled THEN
10178: l_log_module := C_DEFAULT_MODULE||'.handle_fake_journal_entry';
10171: l_login_id := xla_environment_pkg.g_login_id;
10172: l_date := SYSDATE;
10173: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10174: l_prog_id := xla_environment_pkg.g_prog_id;
10175: l_req_id := xla_environment_pkg.g_req_id;
10176:
10177: IF g_log_enabled THEN
10178: l_log_module := C_DEFAULT_MODULE||'.handle_fake_journal_entry';
10179: END IF;
10354: l_log_module VARCHAR2 (2000);
10355:
10356: BEGIN
10357:
10358: l_user_id := xla_environment_pkg.g_usr_id;
10359: l_login_id := xla_environment_pkg.g_login_id;
10360: l_date := SYSDATE;
10361: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10362: l_prog_id := xla_environment_pkg.g_prog_id;
10355:
10356: BEGIN
10357:
10358: l_user_id := xla_environment_pkg.g_usr_id;
10359: l_login_id := xla_environment_pkg.g_login_id;
10360: l_date := SYSDATE;
10361: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10362: l_prog_id := xla_environment_pkg.g_prog_id;
10363: l_req_id := xla_environment_pkg.g_req_id;
10357:
10358: l_user_id := xla_environment_pkg.g_usr_id;
10359: l_login_id := xla_environment_pkg.g_login_id;
10360: l_date := SYSDATE;
10361: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10362: l_prog_id := xla_environment_pkg.g_prog_id;
10363: l_req_id := xla_environment_pkg.g_req_id;
10364:
10365: IF g_log_enabled THEN
10358: l_user_id := xla_environment_pkg.g_usr_id;
10359: l_login_id := xla_environment_pkg.g_login_id;
10360: l_date := SYSDATE;
10361: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10362: l_prog_id := xla_environment_pkg.g_prog_id;
10363: l_req_id := xla_environment_pkg.g_req_id;
10364:
10365: IF g_log_enabled THEN
10366: l_log_module := C_DEFAULT_MODULE||'.initialize';
10359: l_login_id := xla_environment_pkg.g_login_id;
10360: l_date := SYSDATE;
10361: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10362: l_prog_id := xla_environment_pkg.g_prog_id;
10363: l_req_id := xla_environment_pkg.g_req_id;
10364:
10365: IF g_log_enabled THEN
10366: l_log_module := C_DEFAULT_MODULE||'.initialize';
10367: END IF;
10775: IF NOT g_log_enabled THEN
10776: g_log_level := C_LEVEL_LOG_DISABLED;
10777: END IF;
10778:
10779: g_user_id := xla_environment_pkg.g_usr_id;
10780: g_login_id := xla_environment_pkg.g_login_id;
10781: g_date := SYSDATE;
10782: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10783: g_prog_id := xla_environment_pkg.g_prog_id;
10776: g_log_level := C_LEVEL_LOG_DISABLED;
10777: END IF;
10778:
10779: g_user_id := xla_environment_pkg.g_usr_id;
10780: g_login_id := xla_environment_pkg.g_login_id;
10781: g_date := SYSDATE;
10782: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10783: g_prog_id := xla_environment_pkg.g_prog_id;
10784: g_req_id := NVL(xla_environment_pkg.g_req_id, -1);
10778:
10779: g_user_id := xla_environment_pkg.g_usr_id;
10780: g_login_id := xla_environment_pkg.g_login_id;
10781: g_date := SYSDATE;
10782: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10783: g_prog_id := xla_environment_pkg.g_prog_id;
10784: g_req_id := NVL(xla_environment_pkg.g_req_id, -1);
10785:
10786: g_cached_single_period := FALSE;
10779: g_user_id := xla_environment_pkg.g_usr_id;
10780: g_login_id := xla_environment_pkg.g_login_id;
10781: g_date := SYSDATE;
10782: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10783: g_prog_id := xla_environment_pkg.g_prog_id;
10784: g_req_id := NVL(xla_environment_pkg.g_req_id, -1);
10785:
10786: g_cached_single_period := FALSE;
10787: END xla_balances_pkg;
10780: g_login_id := xla_environment_pkg.g_login_id;
10781: g_date := SYSDATE;
10782: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10783: g_prog_id := xla_environment_pkg.g_prog_id;
10784: g_req_id := NVL(xla_environment_pkg.g_req_id, -1);
10785:
10786: g_cached_single_period := FALSE;
10787: END xla_balances_pkg;