eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_XLA_INTERFACE_PKG dependencies on PA_DEBUG

Line 225: g_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

221: p_data_set_id number ) IS
222:
223: BEGIN
224: g_debug_module := 'pa.plsql.PA_XLA_INTERFACE_PKG';
225: g_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
226:
227: IF g_debug_mode = 'Y' THEN
228: pa_debug.set_curr_function(p_function => 'create_events',
229: p_debug_mode => g_debug_mode );

Line 228: pa_debug.set_curr_function(p_function => 'create_events',

224: g_debug_module := 'pa.plsql.PA_XLA_INTERFACE_PKG';
225: g_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
226:
227: IF g_debug_mode = 'Y' THEN
228: pa_debug.set_curr_function(p_function => 'create_events',
229: p_debug_mode => g_debug_mode );
230: END IF;
231:
232: IF g_debug_mode = 'Y' THEN

Line 233: pa_debug.g_err_stage:= 'Create Events API Start';

229: p_debug_mode => g_debug_mode );
230: END IF;
231:
232: IF g_debug_mode = 'Y' THEN
233: pa_debug.g_err_stage:= 'Create Events API Start';
234: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
235: END IF;
236:
237: select org_id, set_of_books_id, def_supplier_cost_cr_ccid

Line 234: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);

230: END IF;
231:
232: IF g_debug_mode = 'Y' THEN
233: pa_debug.g_err_stage:= 'Create Events API Start';
234: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
235: END IF;
236:
237: select org_id, set_of_books_id, def_supplier_cost_cr_ccid
238: into g_org_id, g_ledger_id, g_imp_cr_ccid

Line 251: pa_debug.g_err_stage:= 'Parameter List: Calling Module: ' || g_calling_module || ', Dataset ID: ' ||

247: g_calling_module := p_calling_module;
248: g_data_set_id := p_data_set_id;
249:
250: IF g_debug_mode = 'Y' THEN
251: pa_debug.g_err_stage:= 'Parameter List: Calling Module: ' || g_calling_module || ', Dataset ID: ' ||
252: g_data_set_id;
253: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
254: END IF;
255:

Line 253: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);

249:
250: IF g_debug_mode = 'Y' THEN
251: pa_debug.g_err_stage:= 'Parameter List: Calling Module: ' || g_calling_module || ', Dataset ID: ' ||
252: g_data_set_id;
253: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
254: END IF;
255:
256: IF g_calling_module in ('USG', 'PJ', 'INV', 'WIP', 'LAB', 'SUPP', 'BTC', 'TBC', 'CC', 'BL', 'PC', 'Cost') THEN
257: g_entity_code := 'EXPENDITURES';

Line 323: pa_debug.g_err_stage:= 'Create Events: Start';

319:
320: BEGIN
321:
322: IF g_debug_mode = 'Y' THEN
323: pa_debug.g_err_stage:= 'Create Events: Start';
324: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
325: END IF;
326:
327: -- initialize global variables. check debug mode, get org_id

Line 324: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);

320: BEGIN
321:
322: IF g_debug_mode = 'Y' THEN
323: pa_debug.g_err_stage:= 'Create Events: Start';
324: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
325: END IF;
326:
327: -- initialize global variables. check debug mode, get org_id
328: -- and ledger_id. build pl/sql table of event type info.

Line 344: pa_debug.g_err_stage:= 'Create Events: Calling procedure Populate_enc_event_array';

340:
341: -- -------------------------------------------------------------+
342: -- E1. Select data for processing
343: IF g_debug_mode = 'Y' THEN
344: pa_debug.g_err_stage:= 'Create Events: Calling procedure Populate_enc_event_array';
345: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
346: END IF;
347: -- -------------------------------------------------------------+
348:

Line 345: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);

341: -- -------------------------------------------------------------+
342: -- E1. Select data for processing
343: IF g_debug_mode = 'Y' THEN
344: pa_debug.g_err_stage:= 'Create Events: Calling procedure Populate_enc_event_array';
345: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
346: END IF;
347: -- -------------------------------------------------------------+
348:
349: POPULATE_ENC_EVENT_ARRAY;

Line 354: pa_debug.g_err_stage:= 'Create Events: Check if events exist for processing ..';

350:
351: -- -------------------------------------------------------------+
352: -- E2. Check if there are events to be RAISED ..
353: IF g_debug_mode = 'Y' THEN
354: pa_debug.g_err_stage:= 'Create Events: Check if events exist for processing ..';
355: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
356: END IF;
357: -- -------------------------------------------------------------+
358: If NOT t_event_date.EXISTS(1) then

Line 355: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

351: -- -------------------------------------------------------------+
352: -- E2. Check if there are events to be RAISED ..
353: IF g_debug_mode = 'Y' THEN
354: pa_debug.g_err_stage:= 'Create Events: Check if events exist for processing ..';
355: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
356: END IF;
357: -- -------------------------------------------------------------+
358: If NOT t_event_date.EXISTS(1) then
359:

Line 361: pa_debug.g_err_stage:= 'Create Events: No event exist for processing ..';

357: -- -------------------------------------------------------------+
358: If NOT t_event_date.EXISTS(1) then
359:
360: IF g_debug_mode = 'Y' THEN
361: pa_debug.g_err_stage:= 'Create Events: No event exist for processing ..';
362: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
363: END IF;
364:
365: goto noprocessing;

Line 362: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

358: If NOT t_event_date.EXISTS(1) then
359:
360: IF g_debug_mode = 'Y' THEN
361: pa_debug.g_err_stage:= 'Create Events: No event exist for processing ..';
362: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
363: END IF;
364:
365: goto noprocessing;
366:

Line 372: pa_debug.g_err_stage:= 'Create Events: Event(s) exist for processing ..';

368:
369: -- -------------------------------------------------------------+
370: -- E3. Event Creation ..
371: IF g_debug_mode = 'Y' THEN
372: pa_debug.g_err_stage:= 'Create Events: Event(s) exist for processing ..';
373: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
374:
375: pa_debug.g_err_stage:= 'Create Events: FC: Calling xla_events_pkg.create_event';
376: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

Line 373: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

369: -- -------------------------------------------------------------+
370: -- E3. Event Creation ..
371: IF g_debug_mode = 'Y' THEN
372: pa_debug.g_err_stage:= 'Create Events: Event(s) exist for processing ..';
373: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
374:
375: pa_debug.g_err_stage:= 'Create Events: FC: Calling xla_events_pkg.create_event';
376: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
377: END IF;

Line 375: pa_debug.g_err_stage:= 'Create Events: FC: Calling xla_events_pkg.create_event';

371: IF g_debug_mode = 'Y' THEN
372: pa_debug.g_err_stage:= 'Create Events: Event(s) exist for processing ..';
373: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
374:
375: pa_debug.g_err_stage:= 'Create Events: FC: Calling xla_events_pkg.create_event';
376: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
377: END IF;
378: -- -------------------------------------------------------------+
379:

Line 376: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

372: pa_debug.g_err_stage:= 'Create Events: Event(s) exist for processing ..';
373: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
374:
375: pa_debug.g_err_stage:= 'Create Events: FC: Calling xla_events_pkg.create_event';
376: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
377: END IF;
378: -- -------------------------------------------------------------+
379:
380: FOR i in t_event_date.FIRST..t_event_date.LAST LOOP

Line 399: pa_debug.g_err_stage:= 'Create Events: Tieback Processing';

395: -- -------------------------------------------------------------+
396: -- E4. Stamp event_id on source table (pa_budget_lines for
397: -- Budgets, pa_bc_packets for FC)
398: IF g_debug_mode = 'Y' THEN
399: pa_debug.g_err_stage:= 'Create Events: Tieback Processing';
400: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
401: END IF;
402: -- -------------------------------------------------------------+
403: IF g_entity_code = 'BUDGETS' then

Line 400: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

396: -- E4. Stamp event_id on source table (pa_budget_lines for
397: -- Budgets, pa_bc_packets for FC)
398: IF g_debug_mode = 'Y' THEN
399: pa_debug.g_err_stage:= 'Create Events: Tieback Processing';
400: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
401: END IF;
402: -- -------------------------------------------------------------+
403: IF g_entity_code = 'BUDGETS' then
404:

Line 416: pa_debug.g_err_stage:= 'Create Events: FC: Populate psa_bc_xla_events_gt';

412:
413: -- -------------------------------------------------------------+
414: -- E5. Populate psa_bc_xla_events_gt with the new event_id's ...
415: IF g_debug_mode = 'Y' THEN
416: pa_debug.g_err_stage:= 'Create Events: FC: Populate psa_bc_xla_events_gt';
417: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
418:
419: -- Events that are being populated into psa_bc_xla_events_gt
420: for x in t_event_id.FIRST..t_event_id.LAST loop

Line 417: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

413: -- -------------------------------------------------------------+
414: -- E5. Populate psa_bc_xla_events_gt with the new event_id's ...
415: IF g_debug_mode = 'Y' THEN
416: pa_debug.g_err_stage:= 'Create Events: FC: Populate psa_bc_xla_events_gt';
417: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
418:
419: -- Events that are being populated into psa_bc_xla_events_gt
420: for x in t_event_id.FIRST..t_event_id.LAST loop
421: pa_debug.write('create_events ' || g_debug_module,'Event id is:'||t_event_id(x), g_debug_level5);

Line 421: pa_debug.write('create_events ' || g_debug_module,'Event id is:'||t_event_id(x), g_debug_level5);

417: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
418:
419: -- Events that are being populated into psa_bc_xla_events_gt
420: for x in t_event_id.FIRST..t_event_id.LAST loop
421: pa_debug.write('create_events ' || g_debug_module,'Event id is:'||t_event_id(x), g_debug_level5);
422: end loop;
423:
424: END IF;
425: -- -------------------------------------------------------------+

Line 433: pa_debug.g_err_stage:= 'Create Events: Delete PL/sql table';

429:
430: -- -------------------------------------------------------------+
431: -- E6. Delete pl/sql table ..
432: IF g_debug_mode = 'Y' THEN
433: pa_debug.g_err_stage:= 'Create Events: Delete PL/sql table';
434: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
435: END IF;
436: -- -------------------------------------------------------------+
437: tt_source_info.DELETE;

Line 434: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

430: -- -------------------------------------------------------------+
431: -- E6. Delete pl/sql table ..
432: IF g_debug_mode = 'Y' THEN
433: pa_debug.g_err_stage:= 'Create Events: Delete PL/sql table';
434: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
435: END IF;
436: -- -------------------------------------------------------------+
437: tt_source_info.DELETE;
438: t_event_type_code.DELETE;

Line 453: pa_debug.g_err_stage:= 'Calling procedure populate_cost_event_array';

449:
450:
451:
452: IF g_debug_mode = 'Y' THEN
453: pa_debug.g_err_stage:= 'Calling procedure populate_cost_event_array';
454: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
455: END IF;
456:
457: -- derive the entity and event type details.

Line 454: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);

450:
451:
452: IF g_debug_mode = 'Y' THEN
453: pa_debug.g_err_stage:= 'Calling procedure populate_cost_event_array';
454: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
455: END IF;
456:
457: -- derive the entity and event type details.
458: -- populate SLA's array structure with required parameters

Line 472: pa_debug.g_err_stage:= 'Calling xla_events_pub_pkg to raise events';

468: goto noprocessing;
469: END IF;
470:
471: IF g_debug_mode = 'Y' THEN
472: pa_debug.g_err_stage:= 'Calling xla_events_pub_pkg to raise events';
473: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
474: END IF;
475:
476: FOR i in t_entity_id.first..t_entity_id.last LOOP

Line 473: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);

469: END IF;
470:
471: IF g_debug_mode = 'Y' THEN
472: pa_debug.g_err_stage:= 'Calling xla_events_pub_pkg to raise events';
473: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
474: END IF;
475:
476: FOR i in t_entity_id.first..t_entity_id.last LOOP
477: IF t_raise_event(i) = 'Y' THEN

Line 504: pa_debug.g_err_stage:= 'Create Events API..End';

500: g_tab_module.delete;
501: g_tab_event_type_code.delete;
502:
503: IF g_debug_mode = 'Y' THEN
504: pa_debug.g_err_stage:= 'Create Events API..End';
505: pa_debug.write('create_events ' || g_debug_module,
506: pa_debug.g_err_stage, g_debug_level5);
507: END IF;
508:

Line 505: pa_debug.write('create_events ' || g_debug_module,

501: g_tab_event_type_code.delete;
502:
503: IF g_debug_mode = 'Y' THEN
504: pa_debug.g_err_stage:= 'Create Events API..End';
505: pa_debug.write('create_events ' || g_debug_module,
506: pa_debug.g_err_stage, g_debug_level5);
507: END IF;
508:
509: End If; -- ENCUMBRANCE V/S ACTUAL ACCOUNTING Check

Line 506: pa_debug.g_err_stage, g_debug_level5);

502:
503: IF g_debug_mode = 'Y' THEN
504: pa_debug.g_err_stage:= 'Create Events API..End';
505: pa_debug.write('create_events ' || g_debug_module,
506: pa_debug.g_err_stage, g_debug_level5);
507: END IF;
508:
509: End If; -- ENCUMBRANCE V/S ACTUAL ACCOUNTING Check
510:

Line 1324: pa_debug.g_err_stage:= 'Get_bvid_to_reverse';

1320: l_project_id pa_budget_versions.project_id%TYPE;
1321: Begin
1322:
1323: IF g_debug_mode = 'Y' THEN
1324: pa_debug.g_err_stage:= 'Get_bvid_to_reverse';
1325: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1326: END IF;
1327:
1328: Select budget_type_code,budget_status_code,project_id

Line 1325: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1321: Begin
1322:
1323: IF g_debug_mode = 'Y' THEN
1324: pa_debug.g_err_stage:= 'Get_bvid_to_reverse';
1325: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1326: END IF;
1327:
1328: Select budget_type_code,budget_status_code,project_id
1329: into l_budget_type_code,p_curr_budget_status_code,l_project_id

Line 1371: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':l_budget_type_code:'||l_budget_type_code||

1367: End If;
1368:
1369:
1370: IF g_debug_mode = 'Y' THEN
1371: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':l_budget_type_code:'||l_budget_type_code||
1372: ':p_curr_budget_status_code:'||p_curr_budget_status_code;
1373: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1374:
1375: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':Last baselined version:'||p_old_budget_version_id;

Line 1373: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1369:
1370: IF g_debug_mode = 'Y' THEN
1371: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':l_budget_type_code:'||l_budget_type_code||
1372: ':p_curr_budget_status_code:'||p_curr_budget_status_code;
1373: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1374:
1375: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':Last baselined version:'||p_old_budget_version_id;
1376: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1377: END IF;

Line 1375: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':Last baselined version:'||p_old_budget_version_id;

1371: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':l_budget_type_code:'||l_budget_type_code||
1372: ':p_curr_budget_status_code:'||p_curr_budget_status_code;
1373: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1374:
1375: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':Last baselined version:'||p_old_budget_version_id;
1376: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1377: END IF;
1378:
1379: End Get_bvid_to_reverse;

Line 1376: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1372: ':p_curr_budget_status_code:'||p_curr_budget_status_code;
1373: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1374:
1375: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':Last baselined version:'||p_old_budget_version_id;
1376: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1377: END IF;
1378:
1379: End Get_bvid_to_reverse;
1380:

Line 1400: pa_debug.g_err_stage:= 'Delete_xla_event_data'||'Module:['||p_calling_module

1396: Is
1397: Begin
1398:
1399: IF g_debug_mode = 'Y' THEN
1400: pa_debug.g_err_stage:= 'Delete_xla_event_data'||'Module:['||p_calling_module
1401: ||']packet_id or last baselined version['||p_data_set_id1
1402: ||']draft budget version['||p_data_set_id2||']';
1403: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1404:

Line 1403: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1399: IF g_debug_mode = 'Y' THEN
1400: pa_debug.g_err_stage:= 'Delete_xla_event_data'||'Module:['||p_calling_module
1401: ||']packet_id or last baselined version['||p_data_set_id1
1402: ||']draft budget version['||p_data_set_id2||']';
1403: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1404:
1405: pa_debug.g_err_stage:= 'Delete_xla_event_data'||':Collect data for deleting reversing events';
1406: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1407: END IF;

Line 1405: pa_debug.g_err_stage:= 'Delete_xla_event_data'||':Collect data for deleting reversing events';

1401: ||']packet_id or last baselined version['||p_data_set_id1
1402: ||']draft budget version['||p_data_set_id2||']';
1403: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1404:
1405: pa_debug.g_err_stage:= 'Delete_xla_event_data'||':Collect data for deleting reversing events';
1406: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1407: END IF;
1408:
1409: If p_calling_module = 'BUDGETS' then

Line 1406: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1402: ||']draft budget version['||p_data_set_id2||']';
1403: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1404:
1405: pa_debug.g_err_stage:= 'Delete_xla_event_data'||':Collect data for deleting reversing events';
1406: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1407: END IF;
1408:
1409: If p_calling_module = 'BUDGETS' then
1410:

Line 1528: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||t_source_event_id.COUNT||' event(s) to be deleted';

1524: -- B. Initalize out variable ..
1525: p_events_to_delete := 'Y';
1526:
1527: IF g_debug_mode = 'Y' THEN
1528: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||t_source_event_id.COUNT||' event(s) to be deleted';
1529: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1530: END IF;
1531:
1532: -- C. Assign the values to pl/sql array

Line 1529: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1525: p_events_to_delete := 'Y';
1526:
1527: IF g_debug_mode = 'Y' THEN
1528: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||t_source_event_id.COUNT||' event(s) to be deleted';
1529: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1530: END IF;
1531:
1532: -- C. Assign the values to pl/sql array
1533:

Line 1557: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'Call xla_events_pub_pkg.delete_event';

1553:
1554: -- D. Call XLA delete API
1555:
1556: IF g_debug_mode = 'Y' THEN
1557: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'Call xla_events_pub_pkg.delete_event';
1558: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1559: END IF;
1560:
1561: for i in t_source_event_id.FIRST..t_source_event_id.LAST loop

Line 1558: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1554: -- D. Call XLA delete API
1555:
1556: IF g_debug_mode = 'Y' THEN
1557: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'Call xla_events_pub_pkg.delete_event';
1558: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1559: END IF;
1560:
1561: for i in t_source_event_id.FIRST..t_source_event_id.LAST loop
1562: XLA_EVENTS_PUB_PKG.DELETE_EVENT(p_event_source_info => tt_source_info(i)

Line 1570: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'initalize pl/sql table';

1566: end loop;
1567:
1568: -- E. Initalize pl/sql table
1569: IF g_debug_mode = 'Y' THEN
1570: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'initalize pl/sql table';
1571: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1572: END IF;
1573:
1574: t_source_application_id.DELETE;

Line 1571: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1567:
1568: -- E. Initalize pl/sql table
1569: IF g_debug_mode = 'Y' THEN
1570: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'initalize pl/sql table';
1571: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1572: END IF;
1573:
1574: t_source_application_id.DELETE;
1575: t_application_id.DELETE;

Line 1594: pa_debug.g_err_stage:= 'Delete_xla_event_data: No event to delete';

1590:
1591: Else
1592:
1593: IF g_debug_mode = 'Y' THEN
1594: pa_debug.g_err_stage:= 'Delete_xla_event_data: No event to delete';
1595: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1596: END IF;
1597:
1598: End If;

Line 1595: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1591: Else
1592:
1593: IF g_debug_mode = 'Y' THEN
1594: pa_debug.g_err_stage:= 'Delete_xla_event_data: No event to delete';
1595: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1596: END IF;
1597:
1598: End If;
1599:

Line 1617: pa_debug.g_err_stage:= 'Reset_event_id'||':Current Budget Status:'||p_curr_budget_status_code||

1613: Begin
1614:
1615: -- ----------------------------------------------------------------------------------------- +
1616: IF g_debug_mode = 'Y' THEN
1617: pa_debug.g_err_stage:= 'Reset_event_id'||':Current Budget Status:'||p_curr_budget_status_code||
1618: ':Last baselined version:'||p_old_budget_version_id||
1619: ':Current budget version:'||p_budget_version_id;
1620: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1621:

Line 1620: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1616: IF g_debug_mode = 'Y' THEN
1617: pa_debug.g_err_stage:= 'Reset_event_id'||':Current Budget Status:'||p_curr_budget_status_code||
1618: ':Last baselined version:'||p_old_budget_version_id||
1619: ':Current budget version:'||p_budget_version_id;
1620: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1621:
1622: pa_debug.g_err_stage:= 'Reset_event_id'||':Calling DELETE_XLA_EVENT_DATA';
1623: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1624: END IF;

Line 1622: pa_debug.g_err_stage:= 'Reset_event_id'||':Calling DELETE_XLA_EVENT_DATA';

1618: ':Last baselined version:'||p_old_budget_version_id||
1619: ':Current budget version:'||p_budget_version_id;
1620: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1621:
1622: pa_debug.g_err_stage:= 'Reset_event_id'||':Calling DELETE_XLA_EVENT_DATA';
1623: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1624: END IF;
1625: -- ----------------------------------------------------------------------------------------- +
1626: l_events_to_delete := 'N';

Line 1623: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1619: ':Current budget version:'||p_budget_version_id;
1620: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1621:
1622: pa_debug.g_err_stage:= 'Reset_event_id'||':Calling DELETE_XLA_EVENT_DATA';
1623: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1624: END IF;
1625: -- ----------------------------------------------------------------------------------------- +
1626: l_events_to_delete := 'N';
1627:

Line 1654: pa_debug.g_err_stage:= 'Reset_event_id'||': Reset bc_event_id for p_budget_version_id:'||p_budget_version_id;

1650: If p_curr_budget_status_code in ('S','W') then
1651: -- ----------------------------------------------------------------------------------------- +
1652: -- Update draft budget's event_id to null
1653: IF g_debug_mode = 'Y' THEN
1654: pa_debug.g_err_stage:= 'Reset_event_id'||': Reset bc_event_id for p_budget_version_id:'||p_budget_version_id;
1655: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1656: END IF;
1657: -- ----------------------------------------------------------------------------------------- +
1658:

Line 1655: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1651: -- ----------------------------------------------------------------------------------------- +
1652: -- Update draft budget's event_id to null
1653: IF g_debug_mode = 'Y' THEN
1654: pa_debug.g_err_stage:= 'Reset_event_id'||': Reset bc_event_id for p_budget_version_id:'||p_budget_version_id;
1655: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1656: END IF;
1657: -- ----------------------------------------------------------------------------------------- +
1658:
1659: Update pa_budget_lines

Line 1668: pa_debug.g_err_stage:= 'Reset_event_id'||':Reset bc_rev_event_id for p_old_budget_version_id:'||p_old_budget_version_id;

1664:
1665: If p_old_budget_version_id is not null then
1666: -- ----------------------------------------------------------------------------------------- +
1667: IF g_debug_mode = 'Y' THEN
1668: pa_debug.g_err_stage:= 'Reset_event_id'||':Reset bc_rev_event_id for p_old_budget_version_id:'||p_old_budget_version_id;
1669: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1670: END IF;
1671: -- ----------------------------------------------------------------------------------------- +
1672:

Line 1669: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1665: If p_old_budget_version_id is not null then
1666: -- ----------------------------------------------------------------------------------------- +
1667: IF g_debug_mode = 'Y' THEN
1668: pa_debug.g_err_stage:= 'Reset_event_id'||':Reset bc_rev_event_id for p_old_budget_version_id:'||p_old_budget_version_id;
1669: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1670: END IF;
1671: -- ----------------------------------------------------------------------------------------- +
1672:
1673: Update pa_budget_lines

Line 1699: pa_debug.g_err_stage:= 'Populate_enc_events_gt'||':Calling Module:'||p_calling_module||

1695:
1696: Begin
1697:
1698: IF g_debug_mode = 'Y' THEN
1699: pa_debug.g_err_stage:= 'Populate_enc_events_gt'||':Calling Module:'||p_calling_module||
1700: ' :Event count being inserted'||p_Source_Id_Int1.COUNT;
1701: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1702: END IF;
1703:

Line 1701: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1697:
1698: IF g_debug_mode = 'Y' THEN
1699: pa_debug.g_err_stage:= 'Populate_enc_events_gt'||':Calling Module:'||p_calling_module||
1700: ' :Event count being inserted'||p_Source_Id_Int1.COUNT;
1701: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1702: END IF;
1703:
1704: -- 1. Set variables
1705: l_application_id := 275;

Line 1834: pa_debug.g_err_stage:= 'Populate_enc_event_array';

1830:
1831: Begin
1832:
1833: IF g_debug_mode = 'Y' THEN
1834: pa_debug.g_err_stage:= 'Populate_enc_event_array';
1835: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1836: END IF;
1837:
1838: -- -----------------------------------------------------------------------------------+

Line 1835: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1831: Begin
1832:
1833: IF g_debug_mode = 'Y' THEN
1834: pa_debug.g_err_stage:= 'Populate_enc_event_array';
1835: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1836: END IF;
1837:
1838: -- -----------------------------------------------------------------------------------+
1839: -- 1. Set variables

Line 1861: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Get_bvid_to_reverse';

1857: If g_entity_code = 'BUDGETS' then
1858:
1859: -- 3A. Get current budget status code and also the budget version to reverse
1860: IF g_debug_mode = 'Y' THEN
1861: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Get_bvid_to_reverse';
1862: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1863: END IF;
1864:
1865: Get_bvid_to_reverse(p_budget_version_id => g_data_set_id,

Line 1862: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1858:
1859: -- 3A. Get current budget status code and also the budget version to reverse
1860: IF g_debug_mode = 'Y' THEN
1861: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Get_bvid_to_reverse';
1862: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1863: END IF;
1864:
1865: Get_bvid_to_reverse(p_budget_version_id => g_data_set_id,
1866: p_curr_budget_status_code => l_curr_budget_status_code,

Line 1871: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Reset_event_id';

1867: p_old_budget_version_id => l_bvid_to_reverse);
1868:
1869: -- 3B. Re-set event id (check funds/re-baseline failure)
1870: IF g_debug_mode = 'Y' THEN
1871: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Reset_event_id';
1872: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1873: END IF;
1874:
1875: Reset_event_id (p_budget_version_id => g_data_set_id,

Line 1872: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1868:
1869: -- 3B. Re-set event id (check funds/re-baseline failure)
1870: IF g_debug_mode = 'Y' THEN
1871: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Reset_event_id';
1872: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1873: END IF;
1874:
1875: Reset_event_id (p_budget_version_id => g_data_set_id,
1876: p_curr_budget_status_code => l_curr_budget_status_code,

Line 1881: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Get org_id';

1877: p_old_budget_version_id => l_bvid_to_reverse);
1878:
1879: -- 3C. Get org_id for the project
1880: IF g_debug_mode = 'Y' THEN
1881: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Get org_id';
1882: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1883: END IF;
1884:
1885: select pp.org_id,pp.segment1,

Line 1882: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1878:
1879: -- 3C. Get org_id for the project
1880: IF g_debug_mode = 'Y' THEN
1881: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Get org_id';
1882: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1883: END IF;
1884:
1885: select pp.org_id,pp.segment1,
1886: pbv.version_number,pbt.budget_type

Line 1905: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Processing events::g_data_set_id,l_bvid_to_reverse::'||

1901: End If;
1902:
1903: -- 3D. Process budgets
1904: IF g_debug_mode = 'Y' THEN
1905: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Processing events::g_data_set_id,l_bvid_to_reverse::'||
1906: g_data_set_id||':'||l_bvid_to_reverse;
1907: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1908: END IF;
1909:

Line 1907: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1903: -- 3D. Process budgets
1904: IF g_debug_mode = 'Y' THEN
1905: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Processing events::g_data_set_id,l_bvid_to_reverse::'||
1906: g_data_set_id||':'||l_bvid_to_reverse;
1907: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1908: END IF;
1909:
1910: -- Note: g_data_set_id is for current version and l_bvid_to_reverse for reversing prev. baselined
1911:

Line 1919: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Distinct budget record count is:'||t_source_id_int_1.COUNT;

1915: where budget_version_id in (g_data_set_id,l_bvid_to_reverse);
1916:
1917: If g_debug_mode = 'Y' THEN
1918:
1919: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Distinct budget record count is:'||t_source_id_int_1.COUNT;
1920: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1921:
1922: End If;
1923:

Line 1920: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1916:
1917: If g_debug_mode = 'Y' THEN
1918:
1919: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Distinct budget record count is:'||t_source_id_int_1.COUNT;
1920: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1921:
1922: End If;
1923:
1924: for x in 1..t_source_id_int_1.COUNT loop

Line 1966: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Calling DELETE_XLA_EVENT_DATA';

1962: -- 4A: Clean up draft events created for the same document 'cause
1963: -- of Check funds action on the doc ..
1964: -- ----------------------------------------------------------------------------------------- +
1965: IF g_debug_mode = 'Y' THEN
1966: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Calling DELETE_XLA_EVENT_DATA';
1967: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1968: END IF;
1969: -- ----------------------------------------------------------------------------------------- +
1970:

Line 1967: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1963: -- of Check funds action on the doc ..
1964: -- ----------------------------------------------------------------------------------------- +
1965: IF g_debug_mode = 'Y' THEN
1966: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Calling DELETE_XLA_EVENT_DATA';
1967: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1968: END IF;
1969: -- ----------------------------------------------------------------------------------------- +
1970:
1971: l_events_to_delete := 'N';

Line 1980: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Derive required data';

1976: p_events_to_delete => l_events_to_delete);
1977:
1978: -- 4B. Get event related data ..
1979: IF g_debug_mode = 'Y' THEN
1980: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Derive required data';
1981: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1982: END IF;
1983:
1984: select txn.source_application_id,

Line 1981: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

1977:
1978: -- 4B. Get event related data ..
1979: IF g_debug_mode = 'Y' THEN
1980: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Derive required data';
1981: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1982: END IF;
1983:
1984: select txn.source_application_id,
1985: txn.application_id,

Line 2087: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Populate source pl/sql table';

2083: -- -----------------------------------------------------------------------------------+
2084:
2085: -- A. Populate Source pl/sql table ..
2086: IF g_debug_mode = 'Y' THEN
2087: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Populate source pl/sql table';
2088: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2089: END IF;
2090:
2091: If t_event_type_code.exists(1) then

Line 2088: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

2084:
2085: -- A. Populate Source pl/sql table ..
2086: IF g_debug_mode = 'Y' THEN
2087: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Populate source pl/sql table';
2088: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2089: END IF;
2090:
2091: If t_event_type_code.exists(1) then
2092:

Line 2122: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Delete temp. pl/sql table';

2118:
2119:
2120: -- B. Delete temp pl/sql table ..
2121: IF g_debug_mode = 'Y' THEN
2122: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Delete temp. pl/sql table';
2123: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2124: END IF;
2125:
2126: t_source_application_id.DELETE;

Line 2123: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

2119:
2120: -- B. Delete temp pl/sql table ..
2121: IF g_debug_mode = 'Y' THEN
2122: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Delete temp. pl/sql table';
2123: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2124: END IF;
2125:
2126: t_source_application_id.DELETE;
2127: t_application_id.DELETE;

Line 2159: pa_debug.g_err_stage:= 'Tieback_budget_event: Process Start';

2155: Is
2156: Begin
2157: If t_event_id.EXISTS(1) then
2158: IF g_debug_mode = 'Y' THEN
2159: pa_debug.g_err_stage:= 'Tieback_budget_event: Process Start';
2160: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2161: END IF;
2162:
2163: forall i in t_source_id_int_1.FIRST..t_source_id_int_1.LAST

Line 2160: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

2156: Begin
2157: If t_event_id.EXISTS(1) then
2158: IF g_debug_mode = 'Y' THEN
2159: pa_debug.g_err_stage:= 'Tieback_budget_event: Process Start';
2160: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2161: END IF;
2162:
2163: forall i in t_source_id_int_1.FIRST..t_source_id_int_1.LAST
2164: Update pa_budget_lines

Line 2196: pa_debug.g_err_stage:= 'Tieback_enc_event: Process FC';

2192: Begin
2193:
2194: If t_event_id.EXISTS(1) then
2195: IF g_debug_mode = 'Y' THEN
2196: pa_debug.g_err_stage:= 'Tieback_enc_event: Process FC';
2197: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2198: END IF;
2199:
2200:

Line 2197: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

2193:
2194: If t_event_id.EXISTS(1) then
2195: IF g_debug_mode = 'Y' THEN
2196: pa_debug.g_err_stage:= 'Tieback_enc_event: Process FC';
2197: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2198: END IF;
2199:
2200:
2201: forall i in t_event_id.FIRST..t_event_id.LAST