369: C_DUMMY CONSTANT VARCHAR2(30) := '#$&';
370:
371: BEGIN
372:
373: l_user_id := xla_environment_pkg.g_usr_id;
374: l_login_id := xla_environment_pkg.g_login_id;
375: l_date := SYSDATE;
376: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
377: l_prog_id := xla_environment_pkg.g_prog_id;
370:
371: BEGIN
372:
373: l_user_id := xla_environment_pkg.g_usr_id;
374: l_login_id := xla_environment_pkg.g_login_id;
375: l_date := SYSDATE;
376: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
377: l_prog_id := xla_environment_pkg.g_prog_id;
378: l_req_id := xla_environment_pkg.g_req_id;
372:
373: l_user_id := xla_environment_pkg.g_usr_id;
374: l_login_id := xla_environment_pkg.g_login_id;
375: l_date := SYSDATE;
376: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
377: l_prog_id := xla_environment_pkg.g_prog_id;
378: l_req_id := xla_environment_pkg.g_req_id;
379:
380: IF g_log_enabled THEN
373: l_user_id := xla_environment_pkg.g_usr_id;
374: l_login_id := xla_environment_pkg.g_login_id;
375: l_date := SYSDATE;
376: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
377: l_prog_id := xla_environment_pkg.g_prog_id;
378: l_req_id := xla_environment_pkg.g_req_id;
379:
380: IF g_log_enabled THEN
381: l_log_module := C_DEFAULT_MODULE||'.move_balances_forward_COMMIT';
374: l_login_id := xla_environment_pkg.g_login_id;
375: l_date := SYSDATE;
376: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
377: l_prog_id := xla_environment_pkg.g_prog_id;
378: l_req_id := xla_environment_pkg.g_req_id;
379:
380: IF g_log_enabled THEN
381: l_log_module := C_DEFAULT_MODULE||'.move_balances_forward_COMMIT';
382: END IF;
1099: l_log_module VARCHAR2 (2000);
1100:
1101: BEGIN
1102:
1103: l_user_id := xla_environment_pkg.g_usr_id;
1104: l_login_id := xla_environment_pkg.g_login_id;
1105: l_date := SYSDATE;
1106: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1107: l_prog_id := xla_environment_pkg.g_prog_id;
1100:
1101: BEGIN
1102:
1103: l_user_id := xla_environment_pkg.g_usr_id;
1104: l_login_id := xla_environment_pkg.g_login_id;
1105: l_date := SYSDATE;
1106: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1107: l_prog_id := xla_environment_pkg.g_prog_id;
1108: l_req_id := xla_environment_pkg.g_req_id;
1102:
1103: l_user_id := xla_environment_pkg.g_usr_id;
1104: l_login_id := xla_environment_pkg.g_login_id;
1105: l_date := SYSDATE;
1106: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1107: l_prog_id := xla_environment_pkg.g_prog_id;
1108: l_req_id := xla_environment_pkg.g_req_id;
1109:
1110: IF g_log_enabled THEN
1103: l_user_id := xla_environment_pkg.g_usr_id;
1104: l_login_id := xla_environment_pkg.g_login_id;
1105: l_date := SYSDATE;
1106: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1107: l_prog_id := xla_environment_pkg.g_prog_id;
1108: l_req_id := xla_environment_pkg.g_req_id;
1109:
1110: IF g_log_enabled THEN
1111: l_log_module := C_DEFAULT_MODULE||'.check_create_period_balances';
1104: l_login_id := xla_environment_pkg.g_login_id;
1105: l_date := SYSDATE;
1106: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1107: l_prog_id := xla_environment_pkg.g_prog_id;
1108: l_req_id := xla_environment_pkg.g_req_id;
1109:
1110: IF g_log_enabled THEN
1111: l_log_module := C_DEFAULT_MODULE||'.check_create_period_balances';
1112: END IF;
1367: l_log_module VARCHAR2 (2000);
1368:
1369: BEGIN
1370:
1371: l_user_id := xla_environment_pkg.g_usr_id;
1372: l_login_id := xla_environment_pkg.g_login_id;
1373: l_date := SYSDATE;
1374: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1375: l_prog_id := xla_environment_pkg.g_prog_id;
1368:
1369: BEGIN
1370:
1371: l_user_id := xla_environment_pkg.g_usr_id;
1372: l_login_id := xla_environment_pkg.g_login_id;
1373: l_date := SYSDATE;
1374: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1375: l_prog_id := xla_environment_pkg.g_prog_id;
1376: l_req_id := xla_environment_pkg.g_req_id;
1370:
1371: l_user_id := xla_environment_pkg.g_usr_id;
1372: l_login_id := xla_environment_pkg.g_login_id;
1373: l_date := SYSDATE;
1374: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1375: l_prog_id := xla_environment_pkg.g_prog_id;
1376: l_req_id := xla_environment_pkg.g_req_id;
1377:
1378: l_id_flex_code := 'GL#';
1371: l_user_id := xla_environment_pkg.g_usr_id;
1372: l_login_id := xla_environment_pkg.g_login_id;
1373: l_date := SYSDATE;
1374: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1375: l_prog_id := xla_environment_pkg.g_prog_id;
1376: l_req_id := xla_environment_pkg.g_req_id;
1377:
1378: l_id_flex_code := 'GL#';
1379:
1372: l_login_id := xla_environment_pkg.g_login_id;
1373: l_date := SYSDATE;
1374: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
1375: l_prog_id := xla_environment_pkg.g_prog_id;
1376: l_req_id := xla_environment_pkg.g_req_id;
1377:
1378: l_id_flex_code := 'GL#';
1379:
1380: IF g_log_enabled THEN
3217: l_log_module VARCHAR2 (2000);
3218:
3219: BEGIN
3220:
3221: l_user_id := xla_environment_pkg.g_usr_id;
3222: l_login_id := xla_environment_pkg.g_login_id;
3223: l_date := SYSDATE;
3224: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3225: l_prog_id := xla_environment_pkg.g_prog_id;
3218:
3219: BEGIN
3220:
3221: l_user_id := xla_environment_pkg.g_usr_id;
3222: l_login_id := xla_environment_pkg.g_login_id;
3223: l_date := SYSDATE;
3224: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3225: l_prog_id := xla_environment_pkg.g_prog_id;
3226: l_req_id := xla_environment_pkg.g_req_id;
3220:
3221: l_user_id := xla_environment_pkg.g_usr_id;
3222: l_login_id := xla_environment_pkg.g_login_id;
3223: l_date := SYSDATE;
3224: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3225: l_prog_id := xla_environment_pkg.g_prog_id;
3226: l_req_id := xla_environment_pkg.g_req_id;
3227:
3228: IF g_log_enabled THEN
3221: l_user_id := xla_environment_pkg.g_usr_id;
3222: l_login_id := xla_environment_pkg.g_login_id;
3223: l_date := SYSDATE;
3224: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3225: l_prog_id := xla_environment_pkg.g_prog_id;
3226: l_req_id := xla_environment_pkg.g_req_id;
3227:
3228: IF g_log_enabled THEN
3229: l_log_module := C_DEFAULT_MODULE||'.move_identified_bals_forward';
3222: l_login_id := xla_environment_pkg.g_login_id;
3223: l_date := SYSDATE;
3224: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3225: l_prog_id := xla_environment_pkg.g_prog_id;
3226: l_req_id := xla_environment_pkg.g_req_id;
3227:
3228: IF g_log_enabled THEN
3229: l_log_module := C_DEFAULT_MODULE||'.move_identified_bals_forward';
3230: END IF;
7861: l_log_module VARCHAR2 (2000);
7862:
7863: BEGIN
7864:
7865: l_user_id := xla_environment_pkg.g_usr_id;
7866: l_login_id := xla_environment_pkg.g_login_id;
7867: l_date := SYSDATE;
7868: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
7869: l_prog_id := xla_environment_pkg.g_prog_id;
7862:
7863: BEGIN
7864:
7865: l_user_id := xla_environment_pkg.g_usr_id;
7866: l_login_id := xla_environment_pkg.g_login_id;
7867: l_date := SYSDATE;
7868: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
7869: l_prog_id := xla_environment_pkg.g_prog_id;
7870: l_req_id := xla_environment_pkg.g_req_id;
7864:
7865: l_user_id := xla_environment_pkg.g_usr_id;
7866: l_login_id := xla_environment_pkg.g_login_id;
7867: l_date := SYSDATE;
7868: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
7869: l_prog_id := xla_environment_pkg.g_prog_id;
7870: l_req_id := xla_environment_pkg.g_req_id;
7871: IF g_log_enabled THEN
7872: l_log_module := C_DEFAULT_MODULE||'.recreation_common';
7865: l_user_id := xla_environment_pkg.g_usr_id;
7866: l_login_id := xla_environment_pkg.g_login_id;
7867: l_date := SYSDATE;
7868: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
7869: l_prog_id := xla_environment_pkg.g_prog_id;
7870: l_req_id := xla_environment_pkg.g_req_id;
7871: IF g_log_enabled THEN
7872: l_log_module := C_DEFAULT_MODULE||'.recreation_common';
7873: END IF;
7866: l_login_id := xla_environment_pkg.g_login_id;
7867: l_date := SYSDATE;
7868: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
7869: l_prog_id := xla_environment_pkg.g_prog_id;
7870: l_req_id := xla_environment_pkg.g_req_id;
7871: IF g_log_enabled THEN
7872: l_log_module := C_DEFAULT_MODULE||'.recreation_common';
7873: END IF;
7874: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
8475: l_log_module VARCHAR2 (2000);
8476:
8477: BEGIN
8478:
8479: l_user_id := xla_environment_pkg.g_usr_id;
8480: l_login_id := xla_environment_pkg.g_login_id;
8481: l_date := SYSDATE;
8482: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8483: l_prog_id := xla_environment_pkg.g_prog_id;
8476:
8477: BEGIN
8478:
8479: l_user_id := xla_environment_pkg.g_usr_id;
8480: l_login_id := xla_environment_pkg.g_login_id;
8481: l_date := SYSDATE;
8482: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8483: l_prog_id := xla_environment_pkg.g_prog_id;
8484: l_req_id := xla_environment_pkg.g_req_id;
8478:
8479: l_user_id := xla_environment_pkg.g_usr_id;
8480: l_login_id := xla_environment_pkg.g_login_id;
8481: l_date := SYSDATE;
8482: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8483: l_prog_id := xla_environment_pkg.g_prog_id;
8484: l_req_id := xla_environment_pkg.g_req_id;
8485:
8486: IF g_log_enabled THEN
8479: l_user_id := xla_environment_pkg.g_usr_id;
8480: l_login_id := xla_environment_pkg.g_login_id;
8481: l_date := SYSDATE;
8482: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8483: l_prog_id := xla_environment_pkg.g_prog_id;
8484: l_req_id := xla_environment_pkg.g_req_id;
8485:
8486: IF g_log_enabled THEN
8487: l_log_module := C_DEFAULT_MODULE||'.recreation_detailed';
8480: l_login_id := xla_environment_pkg.g_login_id;
8481: l_date := SYSDATE;
8482: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8483: l_prog_id := xla_environment_pkg.g_prog_id;
8484: l_req_id := xla_environment_pkg.g_req_id;
8485:
8486: IF g_log_enabled THEN
8487: l_log_module := C_DEFAULT_MODULE||'.recreation_detailed';
8488: END IF;
8810: l_log_module VARCHAR2 (2000);
8811:
8812: BEGIN
8813:
8814: l_user_id := xla_environment_pkg.g_usr_id;
8815: l_login_id := xla_environment_pkg.g_login_id;
8816: l_date := SYSDATE;
8817: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8818: l_prog_id := xla_environment_pkg.g_prog_id;
8811:
8812: BEGIN
8813:
8814: l_user_id := xla_environment_pkg.g_usr_id;
8815: l_login_id := xla_environment_pkg.g_login_id;
8816: l_date := SYSDATE;
8817: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8818: l_prog_id := xla_environment_pkg.g_prog_id;
8819: l_req_id := xla_environment_pkg.g_req_id;
8813:
8814: l_user_id := xla_environment_pkg.g_usr_id;
8815: l_login_id := xla_environment_pkg.g_login_id;
8816: l_date := SYSDATE;
8817: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8818: l_prog_id := xla_environment_pkg.g_prog_id;
8819: l_req_id := xla_environment_pkg.g_req_id;
8820:
8821: IF g_log_enabled THEN
8814: l_user_id := xla_environment_pkg.g_usr_id;
8815: l_login_id := xla_environment_pkg.g_login_id;
8816: l_date := SYSDATE;
8817: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8818: l_prog_id := xla_environment_pkg.g_prog_id;
8819: l_req_id := xla_environment_pkg.g_req_id;
8820:
8821: IF g_log_enabled THEN
8822: l_log_module := C_DEFAULT_MODULE||'.recreation_massive';
8815: l_login_id := xla_environment_pkg.g_login_id;
8816: l_date := SYSDATE;
8817: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
8818: l_prog_id := xla_environment_pkg.g_prog_id;
8819: l_req_id := xla_environment_pkg.g_req_id;
8820:
8821: IF g_log_enabled THEN
8822: l_log_module := C_DEFAULT_MODULE||'.recreation_massive';
8823: END IF;
9259: l_log_module VARCHAR2 (2000);
9260:
9261: BEGIN
9262:
9263: l_user_id := xla_environment_pkg.g_usr_id;
9264: l_login_id := xla_environment_pkg.g_login_id;
9265: l_date := SYSDATE;
9266: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9267: l_prog_id := xla_environment_pkg.g_prog_id;
9260:
9261: BEGIN
9262:
9263: l_user_id := xla_environment_pkg.g_usr_id;
9264: l_login_id := xla_environment_pkg.g_login_id;
9265: l_date := SYSDATE;
9266: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9267: l_prog_id := xla_environment_pkg.g_prog_id;
9268: l_req_id := xla_environment_pkg.g_req_id;
9262:
9263: l_user_id := xla_environment_pkg.g_usr_id;
9264: l_login_id := xla_environment_pkg.g_login_id;
9265: l_date := SYSDATE;
9266: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9267: l_prog_id := xla_environment_pkg.g_prog_id;
9268: l_req_id := xla_environment_pkg.g_req_id;
9269:
9270: l_id_flex_code := 'GL#';
9263: l_user_id := xla_environment_pkg.g_usr_id;
9264: l_login_id := xla_environment_pkg.g_login_id;
9265: l_date := SYSDATE;
9266: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9267: l_prog_id := xla_environment_pkg.g_prog_id;
9268: l_req_id := xla_environment_pkg.g_req_id;
9269:
9270: l_id_flex_code := 'GL#';
9271:
9264: l_login_id := xla_environment_pkg.g_login_id;
9265: l_date := SYSDATE;
9266: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9267: l_prog_id := xla_environment_pkg.g_prog_id;
9268: l_req_id := xla_environment_pkg.g_req_id;
9269:
9270: l_id_flex_code := 'GL#';
9271:
9272: IF g_log_enabled THEN
9977: l_log_module VARCHAR2 (2000);
9978:
9979: BEGIN
9980:
9981: l_user_id := xla_environment_pkg.g_usr_id;
9982: l_login_id := xla_environment_pkg.g_login_id;
9983: l_date := SYSDATE;
9984: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9985: l_prog_id := xla_environment_pkg.g_prog_id;
9978:
9979: BEGIN
9980:
9981: l_user_id := xla_environment_pkg.g_usr_id;
9982: l_login_id := xla_environment_pkg.g_login_id;
9983: l_date := SYSDATE;
9984: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9985: l_prog_id := xla_environment_pkg.g_prog_id;
9986: l_req_id := xla_environment_pkg.g_req_id;
9980:
9981: l_user_id := xla_environment_pkg.g_usr_id;
9982: l_login_id := xla_environment_pkg.g_login_id;
9983: l_date := SYSDATE;
9984: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9985: l_prog_id := xla_environment_pkg.g_prog_id;
9986: l_req_id := xla_environment_pkg.g_req_id;
9987:
9988: IF g_log_enabled THEN
9981: l_user_id := xla_environment_pkg.g_usr_id;
9982: l_login_id := xla_environment_pkg.g_login_id;
9983: l_date := SYSDATE;
9984: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9985: l_prog_id := xla_environment_pkg.g_prog_id;
9986: l_req_id := xla_environment_pkg.g_req_id;
9987:
9988: IF g_log_enabled THEN
9989: l_log_module := C_DEFAULT_MODULE||'.handle_fake_journal_entry';
9982: l_login_id := xla_environment_pkg.g_login_id;
9983: l_date := SYSDATE;
9984: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
9985: l_prog_id := xla_environment_pkg.g_prog_id;
9986: l_req_id := xla_environment_pkg.g_req_id;
9987:
9988: IF g_log_enabled THEN
9989: l_log_module := C_DEFAULT_MODULE||'.handle_fake_journal_entry';
9990: END IF;
10165: l_log_module VARCHAR2 (2000);
10166:
10167: BEGIN
10168:
10169: l_user_id := xla_environment_pkg.g_usr_id;
10170: l_login_id := xla_environment_pkg.g_login_id;
10171: l_date := SYSDATE;
10172: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10173: l_prog_id := xla_environment_pkg.g_prog_id;
10166:
10167: BEGIN
10168:
10169: l_user_id := xla_environment_pkg.g_usr_id;
10170: l_login_id := xla_environment_pkg.g_login_id;
10171: l_date := SYSDATE;
10172: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10173: l_prog_id := xla_environment_pkg.g_prog_id;
10174: l_req_id := xla_environment_pkg.g_req_id;
10168:
10169: l_user_id := xla_environment_pkg.g_usr_id;
10170: l_login_id := xla_environment_pkg.g_login_id;
10171: l_date := SYSDATE;
10172: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10173: l_prog_id := xla_environment_pkg.g_prog_id;
10174: l_req_id := xla_environment_pkg.g_req_id;
10175:
10176: IF g_log_enabled THEN
10169: l_user_id := xla_environment_pkg.g_usr_id;
10170: l_login_id := xla_environment_pkg.g_login_id;
10171: l_date := SYSDATE;
10172: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10173: l_prog_id := xla_environment_pkg.g_prog_id;
10174: l_req_id := xla_environment_pkg.g_req_id;
10175:
10176: IF g_log_enabled THEN
10177: l_log_module := C_DEFAULT_MODULE||'.initialize';
10170: l_login_id := xla_environment_pkg.g_login_id;
10171: l_date := SYSDATE;
10172: l_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10173: l_prog_id := xla_environment_pkg.g_prog_id;
10174: l_req_id := xla_environment_pkg.g_req_id;
10175:
10176: IF g_log_enabled THEN
10177: l_log_module := C_DEFAULT_MODULE||'.initialize';
10178: END IF;
10586: IF NOT g_log_enabled THEN
10587: g_log_level := C_LEVEL_LOG_DISABLED;
10588: END IF;
10589:
10590: g_user_id := xla_environment_pkg.g_usr_id;
10591: g_login_id := xla_environment_pkg.g_login_id;
10592: g_date := SYSDATE;
10593: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10594: g_prog_id := xla_environment_pkg.g_prog_id;
10587: g_log_level := C_LEVEL_LOG_DISABLED;
10588: END IF;
10589:
10590: g_user_id := xla_environment_pkg.g_usr_id;
10591: g_login_id := xla_environment_pkg.g_login_id;
10592: g_date := SYSDATE;
10593: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10594: g_prog_id := xla_environment_pkg.g_prog_id;
10595: g_req_id := NVL(xla_environment_pkg.g_req_id, -1);
10589:
10590: g_user_id := xla_environment_pkg.g_usr_id;
10591: g_login_id := xla_environment_pkg.g_login_id;
10592: g_date := SYSDATE;
10593: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10594: g_prog_id := xla_environment_pkg.g_prog_id;
10595: g_req_id := NVL(xla_environment_pkg.g_req_id, -1);
10596:
10597: g_cached_single_period := FALSE;
10590: g_user_id := xla_environment_pkg.g_usr_id;
10591: g_login_id := xla_environment_pkg.g_login_id;
10592: g_date := SYSDATE;
10593: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10594: g_prog_id := xla_environment_pkg.g_prog_id;
10595: g_req_id := NVL(xla_environment_pkg.g_req_id, -1);
10596:
10597: g_cached_single_period := FALSE;
10598: END xla_balances_pkg;
10591: g_login_id := xla_environment_pkg.g_login_id;
10592: g_date := SYSDATE;
10593: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
10594: g_prog_id := xla_environment_pkg.g_prog_id;
10595: g_req_id := NVL(xla_environment_pkg.g_req_id, -1);
10596:
10597: g_cached_single_period := FALSE;
10598: END xla_balances_pkg;