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 220: g_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

216: p_data_set_id number ) IS
217:
218: BEGIN
219: g_debug_module := 'pa.plsql.PA_XLA_INTERFACE_PKG';
220: g_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
221:
222: IF g_debug_mode = 'Y' THEN
223: pa_debug.set_curr_function(p_function => 'create_events',
224: p_debug_mode => g_debug_mode );

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

219: g_debug_module := 'pa.plsql.PA_XLA_INTERFACE_PKG';
220: g_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
221:
222: IF g_debug_mode = 'Y' THEN
223: pa_debug.set_curr_function(p_function => 'create_events',
224: p_debug_mode => g_debug_mode );
225: END IF;
226:
227: IF g_debug_mode = 'Y' THEN

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

224: p_debug_mode => g_debug_mode );
225: END IF;
226:
227: IF g_debug_mode = 'Y' THEN
228: pa_debug.g_err_stage:= 'Create Events API Start';
229: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
230: END IF;
231:
232: select org_id, set_of_books_id, def_supplier_cost_cr_ccid

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

225: END IF;
226:
227: IF g_debug_mode = 'Y' THEN
228: pa_debug.g_err_stage:= 'Create Events API Start';
229: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
230: END IF;
231:
232: select org_id, set_of_books_id, def_supplier_cost_cr_ccid
233: into g_org_id, g_ledger_id, g_imp_cr_ccid

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

242: g_calling_module := p_calling_module;
243: g_data_set_id := p_data_set_id;
244:
245: IF g_debug_mode = 'Y' THEN
246: pa_debug.g_err_stage:= 'Parameter List: Calling Module: ' || g_calling_module || ', Dataset ID: ' ||
247: g_data_set_id;
248: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
249: END IF;
250:

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

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

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

314:
315: BEGIN
316:
317: IF g_debug_mode = 'Y' THEN
318: pa_debug.g_err_stage:= 'Create Events: Start';
319: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
320: END IF;
321:
322: -- initialize global variables. check debug mode, get org_id

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

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

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

335:
336: -- -------------------------------------------------------------+
337: -- E1. Select data for processing
338: IF g_debug_mode = 'Y' THEN
339: pa_debug.g_err_stage:= 'Create Events: Calling procedure Populate_enc_event_array';
340: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
341: END IF;
342: -- -------------------------------------------------------------+
343:

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

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

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

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

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

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

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

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

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

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

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

363:
364: -- -------------------------------------------------------------+
365: -- E3. Event Creation ..
366: IF g_debug_mode = 'Y' THEN
367: pa_debug.g_err_stage:= 'Create Events: Event(s) exist for processing ..';
368: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
369:
370: pa_debug.g_err_stage:= 'Create Events: FC: Calling xla_events_pkg.create_event';
371: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

424:
425: -- -------------------------------------------------------------+
426: -- E6. Delete pl/sql table ..
427: IF g_debug_mode = 'Y' THEN
428: pa_debug.g_err_stage:= 'Create Events: Delete PL/sql table';
429: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
430: END IF;
431: -- -------------------------------------------------------------+
432: tt_source_info.DELETE;

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

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

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

444:
445:
446:
447: IF g_debug_mode = 'Y' THEN
448: pa_debug.g_err_stage:= 'Calling procedure populate_cost_event_array';
449: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
450: END IF;
451:
452: -- derive the entity and event type details.

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

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

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

463: goto noprocessing;
464: END IF;
465:
466: IF g_debug_mode = 'Y' THEN
467: pa_debug.g_err_stage:= 'Calling xla_events_pub_pkg to raise events';
468: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
469: END IF;
470:
471: FOR i in t_entity_id.first..t_entity_id.last LOOP

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

464: END IF;
465:
466: IF g_debug_mode = 'Y' THEN
467: pa_debug.g_err_stage:= 'Calling xla_events_pub_pkg to raise events';
468: pa_debug.write('create_events ' || g_debug_module, pa_debug.g_err_stage, g_debug_level5);
469: END IF;
470:
471: FOR i in t_entity_id.first..t_entity_id.last LOOP
472: IF t_raise_event(i) = 'Y' THEN

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

495: g_tab_module.delete;
496: g_tab_event_type_code.delete;
497:
498: IF g_debug_mode = 'Y' THEN
499: pa_debug.g_err_stage:= 'Create Events API..End';
500: pa_debug.write('create_events ' || g_debug_module,
501: pa_debug.g_err_stage, g_debug_level5);
502: END IF;
503:

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

496: g_tab_event_type_code.delete;
497:
498: IF g_debug_mode = 'Y' THEN
499: pa_debug.g_err_stage:= 'Create Events API..End';
500: pa_debug.write('create_events ' || g_debug_module,
501: pa_debug.g_err_stage, g_debug_level5);
502: END IF;
503:
504: End If; -- ENCUMBRANCE V/S ACTUAL ACCOUNTING Check

Line 501: pa_debug.g_err_stage, g_debug_level5);

497:
498: IF g_debug_mode = 'Y' THEN
499: pa_debug.g_err_stage:= 'Create Events API..End';
500: pa_debug.write('create_events ' || g_debug_module,
501: pa_debug.g_err_stage, g_debug_level5);
502: END IF;
503:
504: End If; -- ENCUMBRANCE V/S ACTUAL ACCOUNTING Check
505:

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

1310: l_project_id pa_budget_versions.project_id%TYPE;
1311: Begin
1312:
1313: IF g_debug_mode = 'Y' THEN
1314: pa_debug.g_err_stage:= 'Get_bvid_to_reverse';
1315: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1316: END IF;
1317:
1318: Select budget_type_code,budget_status_code,project_id

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

1311: Begin
1312:
1313: IF g_debug_mode = 'Y' THEN
1314: pa_debug.g_err_stage:= 'Get_bvid_to_reverse';
1315: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1316: END IF;
1317:
1318: Select budget_type_code,budget_status_code,project_id
1319: into l_budget_type_code,p_curr_budget_status_code,l_project_id

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

1357: End If;
1358:
1359:
1360: IF g_debug_mode = 'Y' THEN
1361: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':l_budget_type_code:'||l_budget_type_code||
1362: ':p_curr_budget_status_code:'||p_curr_budget_status_code;
1363: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1364:
1365: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':Last baselined version:'||p_old_budget_version_id;

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

1359:
1360: IF g_debug_mode = 'Y' THEN
1361: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':l_budget_type_code:'||l_budget_type_code||
1362: ':p_curr_budget_status_code:'||p_curr_budget_status_code;
1363: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1364:
1365: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':Last baselined version:'||p_old_budget_version_id;
1366: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1367: END IF;

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

1361: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':l_budget_type_code:'||l_budget_type_code||
1362: ':p_curr_budget_status_code:'||p_curr_budget_status_code;
1363: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1364:
1365: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':Last baselined version:'||p_old_budget_version_id;
1366: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1367: END IF;
1368:
1369: End Get_bvid_to_reverse;

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

1362: ':p_curr_budget_status_code:'||p_curr_budget_status_code;
1363: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1364:
1365: pa_debug.g_err_stage:= 'Get_bvid_to_reverse'||':Last baselined version:'||p_old_budget_version_id;
1366: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1367: END IF;
1368:
1369: End Get_bvid_to_reverse;
1370:

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

1386: Is
1387: Begin
1388:
1389: IF g_debug_mode = 'Y' THEN
1390: pa_debug.g_err_stage:= 'Delete_xla_event_data'||'Module:['||p_calling_module
1391: ||']packet_id or last baselined version['||p_data_set_id1
1392: ||']draft budget version['||p_data_set_id2||']';
1393: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1394:

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

1389: IF g_debug_mode = 'Y' THEN
1390: pa_debug.g_err_stage:= 'Delete_xla_event_data'||'Module:['||p_calling_module
1391: ||']packet_id or last baselined version['||p_data_set_id1
1392: ||']draft budget version['||p_data_set_id2||']';
1393: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1394:
1395: pa_debug.g_err_stage:= 'Delete_xla_event_data'||':Collect data for deleting reversing events';
1396: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1397: END IF;

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

1391: ||']packet_id or last baselined version['||p_data_set_id1
1392: ||']draft budget version['||p_data_set_id2||']';
1393: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1394:
1395: pa_debug.g_err_stage:= 'Delete_xla_event_data'||':Collect data for deleting reversing events';
1396: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1397: END IF;
1398:
1399: If p_calling_module = 'BUDGETS' then

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

1392: ||']draft budget version['||p_data_set_id2||']';
1393: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1394:
1395: pa_debug.g_err_stage:= 'Delete_xla_event_data'||':Collect data for deleting reversing events';
1396: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1397: END IF;
1398:
1399: If p_calling_module = 'BUDGETS' then
1400:

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

1514: -- B. Initalize out variable ..
1515: p_events_to_delete := 'Y';
1516:
1517: IF g_debug_mode = 'Y' THEN
1518: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||t_source_event_id.COUNT||' event(s) to be deleted';
1519: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1520: END IF;
1521:
1522: -- C. Assign the values to pl/sql array

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

1515: p_events_to_delete := 'Y';
1516:
1517: IF g_debug_mode = 'Y' THEN
1518: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||t_source_event_id.COUNT||' event(s) to be deleted';
1519: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1520: END IF;
1521:
1522: -- C. Assign the values to pl/sql array
1523:

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

1543:
1544: -- D. Call XLA delete API
1545:
1546: IF g_debug_mode = 'Y' THEN
1547: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'Call xla_events_pub_pkg.delete_event';
1548: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1549: END IF;
1550:
1551: for i in t_source_event_id.FIRST..t_source_event_id.LAST loop

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

1544: -- D. Call XLA delete API
1545:
1546: IF g_debug_mode = 'Y' THEN
1547: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'Call xla_events_pub_pkg.delete_event';
1548: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1549: END IF;
1550:
1551: for i in t_source_event_id.FIRST..t_source_event_id.LAST loop
1552: XLA_EVENTS_PUB_PKG.DELETE_EVENT(p_event_source_info => tt_source_info(i)

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

1556: end loop;
1557:
1558: -- E. Initalize pl/sql table
1559: IF g_debug_mode = 'Y' THEN
1560: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'initalize pl/sql table';
1561: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1562: END IF;
1563:
1564: t_source_application_id.DELETE;

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

1557:
1558: -- E. Initalize pl/sql table
1559: IF g_debug_mode = 'Y' THEN
1560: pa_debug.g_err_stage:= 'Delete_xla_event_data:'||'initalize pl/sql table';
1561: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1562: END IF;
1563:
1564: t_source_application_id.DELETE;
1565: t_application_id.DELETE;

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

1580:
1581: Else
1582:
1583: IF g_debug_mode = 'Y' THEN
1584: pa_debug.g_err_stage:= 'Delete_xla_event_data: No event to delete';
1585: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1586: END IF;
1587:
1588: End If;

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

1581: Else
1582:
1583: IF g_debug_mode = 'Y' THEN
1584: pa_debug.g_err_stage:= 'Delete_xla_event_data: No event to delete';
1585: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1586: END IF;
1587:
1588: End If;
1589:

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

1603: Begin
1604:
1605: -- ----------------------------------------------------------------------------------------- +
1606: IF g_debug_mode = 'Y' THEN
1607: pa_debug.g_err_stage:= 'Reset_event_id'||':Current Budget Status:'||p_curr_budget_status_code||
1608: ':Last baselined version:'||p_old_budget_version_id||
1609: ':Current budget version:'||p_budget_version_id;
1610: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1611:

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

1606: IF g_debug_mode = 'Y' THEN
1607: pa_debug.g_err_stage:= 'Reset_event_id'||':Current Budget Status:'||p_curr_budget_status_code||
1608: ':Last baselined version:'||p_old_budget_version_id||
1609: ':Current budget version:'||p_budget_version_id;
1610: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1611:
1612: pa_debug.g_err_stage:= 'Reset_event_id'||':Calling DELETE_XLA_EVENT_DATA';
1613: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1614: END IF;

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

1608: ':Last baselined version:'||p_old_budget_version_id||
1609: ':Current budget version:'||p_budget_version_id;
1610: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1611:
1612: pa_debug.g_err_stage:= 'Reset_event_id'||':Calling DELETE_XLA_EVENT_DATA';
1613: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1614: END IF;
1615: -- ----------------------------------------------------------------------------------------- +
1616: l_events_to_delete := 'N';

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

1609: ':Current budget version:'||p_budget_version_id;
1610: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1611:
1612: pa_debug.g_err_stage:= 'Reset_event_id'||':Calling DELETE_XLA_EVENT_DATA';
1613: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1614: END IF;
1615: -- ----------------------------------------------------------------------------------------- +
1616: l_events_to_delete := 'N';
1617:

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

1640: If p_curr_budget_status_code in ('S','W') then
1641: -- ----------------------------------------------------------------------------------------- +
1642: -- Update draft budget's event_id to null
1643: IF g_debug_mode = 'Y' THEN
1644: pa_debug.g_err_stage:= 'Reset_event_id'||': Reset bc_event_id for p_budget_version_id:'||p_budget_version_id;
1645: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1646: END IF;
1647: -- ----------------------------------------------------------------------------------------- +
1648:

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

1641: -- ----------------------------------------------------------------------------------------- +
1642: -- Update draft budget's event_id to null
1643: IF g_debug_mode = 'Y' THEN
1644: pa_debug.g_err_stage:= 'Reset_event_id'||': Reset bc_event_id for p_budget_version_id:'||p_budget_version_id;
1645: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1646: END IF;
1647: -- ----------------------------------------------------------------------------------------- +
1648:
1649: Update pa_budget_lines

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

1654:
1655: If p_old_budget_version_id is not null then
1656: -- ----------------------------------------------------------------------------------------- +
1657: IF g_debug_mode = 'Y' THEN
1658: pa_debug.g_err_stage:= 'Reset_event_id'||':Reset bc_rev_event_id for p_old_budget_version_id:'||p_old_budget_version_id;
1659: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1660: END IF;
1661: -- ----------------------------------------------------------------------------------------- +
1662:

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

1655: If p_old_budget_version_id is not null then
1656: -- ----------------------------------------------------------------------------------------- +
1657: IF g_debug_mode = 'Y' THEN
1658: pa_debug.g_err_stage:= 'Reset_event_id'||':Reset bc_rev_event_id for p_old_budget_version_id:'||p_old_budget_version_id;
1659: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1660: END IF;
1661: -- ----------------------------------------------------------------------------------------- +
1662:
1663: Update pa_budget_lines

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

1685:
1686: Begin
1687:
1688: IF g_debug_mode = 'Y' THEN
1689: pa_debug.g_err_stage:= 'Populate_enc_events_gt'||':Calling Module:'||p_calling_module||
1690: ' :Event count being inserted'||p_Source_Id_Int1.COUNT;
1691: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1692: END IF;
1693:

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

1687:
1688: IF g_debug_mode = 'Y' THEN
1689: pa_debug.g_err_stage:= 'Populate_enc_events_gt'||':Calling Module:'||p_calling_module||
1690: ' :Event count being inserted'||p_Source_Id_Int1.COUNT;
1691: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1692: END IF;
1693:
1694: -- 1. Set variables
1695: l_application_id := 275;

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

1820:
1821: Begin
1822:
1823: IF g_debug_mode = 'Y' THEN
1824: pa_debug.g_err_stage:= 'Populate_enc_event_array';
1825: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1826: END IF;
1827:
1828: -- -----------------------------------------------------------------------------------+

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

1821: Begin
1822:
1823: IF g_debug_mode = 'Y' THEN
1824: pa_debug.g_err_stage:= 'Populate_enc_event_array';
1825: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1826: END IF;
1827:
1828: -- -----------------------------------------------------------------------------------+
1829: -- 1. Set variables

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

1847: If g_entity_code = 'BUDGETS' then
1848:
1849: -- 3A. Get current budget status code and also the budget version to reverse
1850: IF g_debug_mode = 'Y' THEN
1851: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Get_bvid_to_reverse';
1852: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1853: END IF;
1854:
1855: Get_bvid_to_reverse(p_budget_version_id => g_data_set_id,

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

1848:
1849: -- 3A. Get current budget status code and also the budget version to reverse
1850: IF g_debug_mode = 'Y' THEN
1851: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Get_bvid_to_reverse';
1852: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1853: END IF;
1854:
1855: Get_bvid_to_reverse(p_budget_version_id => g_data_set_id,
1856: p_curr_budget_status_code => l_curr_budget_status_code,

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

1857: p_old_budget_version_id => l_bvid_to_reverse);
1858:
1859: -- 3B. Re-set event id (check funds/re-baseline failure)
1860: IF g_debug_mode = 'Y' THEN
1861: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Reset_event_id';
1862: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1863: END IF;
1864:
1865: Reset_event_id (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: -- 3B. Re-set event id (check funds/re-baseline failure)
1860: IF g_debug_mode = 'Y' THEN
1861: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Reset_event_id';
1862: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1863: END IF;
1864:
1865: Reset_event_id (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 - Get org_id';

1867: p_old_budget_version_id => l_bvid_to_reverse);
1868:
1869: -- 3C. Get org_id for the project
1870: IF g_debug_mode = 'Y' THEN
1871: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Get org_id';
1872: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1873: END IF;
1874:
1875: select pp.org_id,pp.segment1,

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

1868:
1869: -- 3C. Get org_id for the project
1870: IF g_debug_mode = 'Y' THEN
1871: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Get org_id';
1872: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1873: END IF;
1874:
1875: select pp.org_id,pp.segment1,
1876: pbv.version_number,pbt.budget_type

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

1891: End If;
1892:
1893: -- 3D. Process budgets
1894: IF g_debug_mode = 'Y' THEN
1895: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Processing events::g_data_set_id,l_bvid_to_reverse::'||
1896: g_data_set_id||':'||l_bvid_to_reverse;
1897: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1898: END IF;
1899:

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

1893: -- 3D. Process budgets
1894: IF g_debug_mode = 'Y' THEN
1895: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Budget - Processing events::g_data_set_id,l_bvid_to_reverse::'||
1896: g_data_set_id||':'||l_bvid_to_reverse;
1897: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1898: END IF;
1899:
1900: -- Note: g_data_set_id is for current version and l_bvid_to_reverse for reversing prev. baselined
1901:

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

1905: where budget_version_id in (g_data_set_id,l_bvid_to_reverse);
1906:
1907: If g_debug_mode = 'Y' THEN
1908:
1909: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Distinct budget record count is:'||t_source_id_int_1.COUNT;
1910: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1911:
1912: End If;
1913:

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

1906:
1907: If g_debug_mode = 'Y' THEN
1908:
1909: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Distinct budget record count is:'||t_source_id_int_1.COUNT;
1910: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1911:
1912: End If;
1913:
1914: for x in 1..t_source_id_int_1.COUNT loop

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

1952: -- 4A: Clean up draft events created for the same document 'cause
1953: -- of Check funds action on the doc ..
1954: -- ----------------------------------------------------------------------------------------- +
1955: IF g_debug_mode = 'Y' THEN
1956: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Calling DELETE_XLA_EVENT_DATA';
1957: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1958: END IF;
1959: -- ----------------------------------------------------------------------------------------- +
1960:

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

1953: -- of Check funds action on the doc ..
1954: -- ----------------------------------------------------------------------------------------- +
1955: IF g_debug_mode = 'Y' THEN
1956: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':Calling DELETE_XLA_EVENT_DATA';
1957: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1958: END IF;
1959: -- ----------------------------------------------------------------------------------------- +
1960:
1961: l_events_to_delete := 'N';

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

1966: p_events_to_delete => l_events_to_delete);
1967:
1968: -- 4B. Get event related data ..
1969: IF g_debug_mode = 'Y' THEN
1970: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Derive required data';
1971: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1972: END IF;
1973:
1974: select txn.source_application_id,

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

1967:
1968: -- 4B. Get event related data ..
1969: IF g_debug_mode = 'Y' THEN
1970: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Derive required data';
1971: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
1972: END IF;
1973:
1974: select txn.source_application_id,
1975: txn.application_id,

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

2073: -- -----------------------------------------------------------------------------------+
2074:
2075: -- A. Populate Source pl/sql table ..
2076: IF g_debug_mode = 'Y' THEN
2077: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Populate source pl/sql table';
2078: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2079: END IF;
2080:
2081: If t_event_type_code.exists(1) then

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

2074:
2075: -- A. Populate Source pl/sql table ..
2076: IF g_debug_mode = 'Y' THEN
2077: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Populate source pl/sql table';
2078: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2079: END IF;
2080:
2081: If t_event_type_code.exists(1) then
2082:

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

2108:
2109:
2110: -- B. Delete temp pl/sql table ..
2111: IF g_debug_mode = 'Y' THEN
2112: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Delete temp. pl/sql table';
2113: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2114: END IF;
2115:
2116: t_source_application_id.DELETE;

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

2109:
2110: -- B. Delete temp pl/sql table ..
2111: IF g_debug_mode = 'Y' THEN
2112: pa_debug.g_err_stage:= 'Populate_enc_event_array'||':FC: Delete temp. pl/sql table';
2113: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2114: END IF;
2115:
2116: t_source_application_id.DELETE;
2117: t_application_id.DELETE;

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

2145: Is
2146: Begin
2147: If t_event_id.EXISTS(1) then
2148: IF g_debug_mode = 'Y' THEN
2149: pa_debug.g_err_stage:= 'Tieback_budget_event: Process Start';
2150: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2151: END IF;
2152:
2153: forall i in t_source_id_int_1.FIRST..t_source_id_int_1.LAST

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

2146: Begin
2147: If t_event_id.EXISTS(1) then
2148: IF g_debug_mode = 'Y' THEN
2149: pa_debug.g_err_stage:= 'Tieback_budget_event: Process Start';
2150: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2151: END IF;
2152:
2153: forall i in t_source_id_int_1.FIRST..t_source_id_int_1.LAST
2154: Update pa_budget_lines

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

2182: Begin
2183:
2184: If t_event_id.EXISTS(1) then
2185: IF g_debug_mode = 'Y' THEN
2186: pa_debug.g_err_stage:= 'Tieback_enc_event: Process FC';
2187: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2188: END IF;
2189:
2190:

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

2183:
2184: If t_event_id.EXISTS(1) then
2185: IF g_debug_mode = 'Y' THEN
2186: pa_debug.g_err_stage:= 'Tieback_enc_event: Process FC';
2187: pa_debug.write('create_events ' || g_debug_module,pa_debug.g_err_stage, g_debug_level5);
2188: END IF;
2189:
2190:
2191: forall i in t_event_id.FIRST..t_event_id.LAST