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.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_DEBUG

Line 9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

5:
6: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| G_PKG_NAME || '.' ;
7:
8: -- Read the profile option that enables/disables the debug log
9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
11:
12: -- Private package exceptions
13: g_GL_VALIDATE_API_EXC EXCEPTION;

Line 10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

6: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| G_PKG_NAME || '.' ;
7:
8: -- Read the profile option that enables/disables the debug log
9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
11:
12: -- Private package exceptions
13: g_GL_VALIDATE_API_EXC EXCEPTION;
14: g_GL_FUNDS_API_EXC EXCEPTION;

Line 353: PO_DEBUG.debug_begin(l_log_head);

349: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_proc_name;
350: l_progress VARCHAR2(3) := '000';
351: BEGIN
352: IF g_debug_stmt THEN
353: PO_DEBUG.debug_begin(l_log_head);
354: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);
355: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
356: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
357: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);

Line 354: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);

350: l_progress VARCHAR2(3) := '000';
351: BEGIN
352: IF g_debug_stmt THEN
353: PO_DEBUG.debug_begin(l_log_head);
354: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);
355: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
356: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
357: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);
358: END IF;

Line 355: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);

351: BEGIN
352: IF g_debug_stmt THEN
353: PO_DEBUG.debug_begin(l_log_head);
354: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);
355: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
356: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
357: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);
358: END IF;
359: l_progress := '100';

Line 356: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);

352: IF g_debug_stmt THEN
353: PO_DEBUG.debug_begin(l_log_head);
354: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);
355: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
356: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
357: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);
358: END IF;
359: l_progress := '100';
360: --bug#5523323 We have removed the autonomous transaction in the procedure

Line 357: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);

353: PO_DEBUG.debug_begin(l_log_head);
354: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);
355: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
356: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
357: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);
358: END IF;
359: l_progress := '100';
360: --bug#5523323 We have removed the autonomous transaction in the procedure
361: --insert_packet_autonomous. Hence renamed the procedure as

Line 378: PO_DEBUG.debug_var(l_log_head,l_progress,'x_packet_id',x_packet_id);

374: l_progress := '200';
375: -- Populate eventids in psa_bc_xla_events_gt for these events
376: -- to be considered by Budgetary Control API
377: IF g_debug_stmt THEN
378: PO_DEBUG.debug_var(l_log_head,l_progress,'x_packet_id',x_packet_id);
379: END IF;
380:
381: IF(x_packet_id IS NOT NULL) THEN
382:

Line 410: PO_DEBUG.debug_var(l_log_head,l_progress,'x_packet_id',x_packet_id);

406: END IF;
407:
408: l_progress := '300';
409: IF g_debug_stmt THEN
410: PO_DEBUG.debug_var(l_log_head,l_progress,'x_packet_id',x_packet_id);
411: PO_DEBUG.debug_end(l_log_head);
412: END IF;
413:
414: EXCEPTION

Line 411: PO_DEBUG.debug_end(l_log_head);

407:
408: l_progress := '300';
409: IF g_debug_stmt THEN
410: PO_DEBUG.debug_var(l_log_head,l_progress,'x_packet_id',x_packet_id);
411: PO_DEBUG.debug_end(l_log_head);
412: END IF;
413:
414: EXCEPTION
415: WHEN OTHERS THEN

Line 417: PO_DEBUG.debug_exc(l_log_head,l_progress);

413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: IF g_debug_unexp THEN
417: PO_DEBUG.debug_exc(l_log_head,l_progress);
418: END IF;
419: RAISE;
420: END insert_packet;
421:

Line 507: PO_DEBUG.debug_begin(l_log_head);

503: l_event_count NUMBER;
504:
505: BEGIN
506: IF g_debug_stmt THEN
507: PO_DEBUG.debug_begin(l_log_head);
508: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);
509: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
510: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
511: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);

Line 508: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);

504:
505: BEGIN
506: IF g_debug_stmt THEN
507: PO_DEBUG.debug_begin(l_log_head);
508: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);
509: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
510: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
511: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);
512: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);

Line 509: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);

505: BEGIN
506: IF g_debug_stmt THEN
507: PO_DEBUG.debug_begin(l_log_head);
508: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);
509: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
510: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
511: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);
512: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
513: END IF;

Line 510: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);

506: IF g_debug_stmt THEN
507: PO_DEBUG.debug_begin(l_log_head);
508: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);
509: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
510: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
511: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);
512: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
513: END IF;
514:

Line 511: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);

507: PO_DEBUG.debug_begin(l_log_head);
508: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);
509: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
510: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
511: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);
512: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
513: END IF;
514:
515: l_progress := '010';

Line 512: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);

508: PO_DEBUG.debug_var(l_log_head,l_progress,'p_status_code',p_status_code);
509: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
510: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
511: PO_DEBUG.debug_var(l_log_head,l_progress,'p_currency_code',p_currency_code);
512: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
513: END IF;
514:
515: l_progress := '010';
516:

Line 527: PO_DEBUG.debug_var(l_log_head,l_progress,'x_packet_id',x_packet_id);

523:
524: l_progress := '020';
525:
526: IF g_debug_stmt THEN
527: PO_DEBUG.debug_var(l_log_head,l_progress,'x_packet_id',x_packet_id);
528: END IF;
529:
530: --
531: l_appl_id := 201 ; -- Bug 5013999

Line 694: PO_DEBUG.debug_var(l_log_head,l_progress,'l_num_of_rows_inserted',l_num_of_rows_inserted);

690:
691: l_progress := '100';
692: l_num_of_rows_inserted :=sql%rowcount;
693: IF g_debug_stmt THEN
694: PO_DEBUG.debug_var(l_log_head,l_progress,'l_num_of_rows_inserted',l_num_of_rows_inserted);
695: END IF;
696:
697: IF l_num_of_rows_inserted = 0 THEN
698: x_packet_id :=NULL;

Line 700: PO_DEBUG.debug_stmt(l_log_head,l_progress,'GL packet not created.');

696:
697: IF l_num_of_rows_inserted = 0 THEN
698: x_packet_id :=NULL;
699: IF g_debug_stmt THEN
700: PO_DEBUG.debug_stmt(l_log_head,l_progress,'GL packet not created.');
701: END IF;
702: END IF;
703:
704: IF(x_packet_id is not null)THEN

Line 707: PO_DEBUG.debug_var(l_log_head,l_progress,'x_packet_id',x_packet_id);

703:
704: IF(x_packet_id is not null)THEN
705:
706: IF g_debug_stmt THEN
707: PO_DEBUG.debug_var(l_log_head,l_progress,'x_packet_id',x_packet_id);
708:
709: END IF;
710:
711: l_progress := '110';

Line 738: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Event type code updation is successful');

734:
735: l_id_tbl.delete;
736:
737: IF g_debug_stmt THEN
738: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Event type code updation is successful');
739: END IF;
740:
741: --
742: -- Logic added to handle a specific case : [ CANCEL ACTION WITH REQ RECREATED OPTION ]

Line 774: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Event type code updation in reqcreate demand is successful');

770: AND pbd.main_or_backing_code = 'B_REQ'
771: AND pbd.distribution_id = l_id_tbl(i) ;
772:
773: IF g_debug_stmt THEN
774: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Event type code updation in reqcreate demand is successful');
775: END IF;
776:
777: END IF;
778:

Line 808: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Bulk Insertion Successful');

804:
805: --
806: --
807: IF g_debug_stmt THEN
808: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Bulk Insertion Successful');
809: END IF;
810: --
811:
812: -- Get the current org id

Line 830: PO_DEBUG.debug_var(l_log_head,l_progress,'l_legal_entity_id ',l_legal_entity_id );

826: -- Bug 4654758 : get the legal entity id using the API
827: l_legal_entity_id := xle_utilities_grp.Get_DefaultLegalContext_OU(l_current_org_id);
828:
829: IF g_debug_stmt THEN
830: PO_DEBUG.debug_var(l_log_head,l_progress,'l_legal_entity_id ',l_legal_entity_id );
831: END IF;
832:
833: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;
834: IF g_debug_stmt THEN

Line 835: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_status_code ',l_event_status_code );

831: END IF;
832:
833: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;
834: IF g_debug_stmt THEN
835: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_status_code ',l_event_status_code );
836: END IF;
837:
838: l_event_number := NULL;
839: l_valuation_method := NULL;

Line 885: PO_DEBUG.debug_var(l_log_head,l_progress,'Number of Draft events ',l_event_count );

881:
882: END LOOP;
883:
884: IF g_debug_stmt THEN
885: PO_DEBUG.debug_var(l_log_head,l_progress,'Number of Draft events ',l_event_count );
886: END IF;
887:
888: IF l_event_count > 0 THEN
889:

Line 907: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number of rows deleted for event '

903:
904: l_num_of_rows_deleted := SQL%rowcount;
905:
906: IF g_debug_stmt THEN
907: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number of rows deleted for event '
908: ||l_events_tab(i).event_id||' are '||l_num_of_rows_deleted );
909: END IF;
910: END LOOP;
911: END IF;

Line 928: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Applied_to_header_id_1 ' || rec_po_bc_dist.applied_to_header_id_1);

924:
925:
926: IF g_debug_stmt THEN
927:
928: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Applied_to_header_id_1 ' || rec_po_bc_dist.applied_to_header_id_1);
929: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Distribution type ' || rec_po_bc_dist.distribution_type);
930: PO_DEBUG.debug_stmt(l_log_head,l_progress,'GL date ' || rec_po_bc_dist.gl_date);
931:
932: END IF;

Line 929: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Distribution type ' || rec_po_bc_dist.distribution_type);

925:
926: IF g_debug_stmt THEN
927:
928: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Applied_to_header_id_1 ' || rec_po_bc_dist.applied_to_header_id_1);
929: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Distribution type ' || rec_po_bc_dist.distribution_type);
930: PO_DEBUG.debug_stmt(l_log_head,l_progress,'GL date ' || rec_po_bc_dist.gl_date);
931:
932: END IF;
933:

Line 930: PO_DEBUG.debug_stmt(l_log_head,l_progress,'GL date ' || rec_po_bc_dist.gl_date);

926: IF g_debug_stmt THEN
927:
928: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Applied_to_header_id_1 ' || rec_po_bc_dist.applied_to_header_id_1);
929: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Distribution type ' || rec_po_bc_dist.distribution_type);
930: PO_DEBUG.debug_stmt(l_log_head,l_progress,'GL date ' || rec_po_bc_dist.gl_date);
931:
932: END IF;
933:
934: l_event_id := NULL;

Line 961: PO_DEBUG.debug_stmt(l_log_head,l_progress,'l_event_id ' || l_event_id);

957: -- Update po_bc_distributions ae_event_id with the l_event_id.
958:
959: IF g_debug_stmt THEN
960:
961: PO_DEBUG.debug_stmt(l_log_head,l_progress,'l_event_id ' || l_event_id);
962: END IF;
963:
964:
965: IF l_event_id IS NOT NULL then

Line 988: PO_DEBUG.debug_end(l_log_head);

984: END LOOP;
985: END IF;--if x_packet_id is not null
986:
987: IF g_debug_stmt THEN
988: PO_DEBUG.debug_end(l_log_head);
989: END IF;
990:
991: EXCEPTION
992: WHEN OTHERS THEN

Line 1070: PO_DEBUG.debug_begin(l_log_head);

1066: l_bc_mode VARCHAR2(1); -- Bug 4995509
1067: BEGIN
1068:
1069: IF g_debug_stmt THEN
1070: PO_DEBUG.debug_begin(l_log_head);
1071: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
1072: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
1073: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_mode',p_gl_mode);
1074: PO_DEBUG.debug_var(l_log_head,l_progress,'p_partial_resv_flag',p_partial_resv_flag);

Line 1071: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);

1067: BEGIN
1068:
1069: IF g_debug_stmt THEN
1070: PO_DEBUG.debug_begin(l_log_head);
1071: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
1072: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
1073: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_mode',p_gl_mode);
1074: PO_DEBUG.debug_var(l_log_head,l_progress,'p_partial_resv_flag',p_partial_resv_flag);
1075: PO_DEBUG.debug_var(l_log_head,l_progress,'p_override',p_override);

Line 1072: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);

1068:
1069: IF g_debug_stmt THEN
1070: PO_DEBUG.debug_begin(l_log_head);
1071: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
1072: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
1073: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_mode',p_gl_mode);
1074: PO_DEBUG.debug_var(l_log_head,l_progress,'p_partial_resv_flag',p_partial_resv_flag);
1075: PO_DEBUG.debug_var(l_log_head,l_progress,'p_override',p_override);
1076: PO_DEBUG.debug_var(l_log_head,l_progress,'p_conc_flag',p_conc_flag);

Line 1073: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_mode',p_gl_mode);

1069: IF g_debug_stmt THEN
1070: PO_DEBUG.debug_begin(l_log_head);
1071: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
1072: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
1073: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_mode',p_gl_mode);
1074: PO_DEBUG.debug_var(l_log_head,l_progress,'p_partial_resv_flag',p_partial_resv_flag);
1075: PO_DEBUG.debug_var(l_log_head,l_progress,'p_override',p_override);
1076: PO_DEBUG.debug_var(l_log_head,l_progress,'p_conc_flag',p_conc_flag);
1077: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);

Line 1074: PO_DEBUG.debug_var(l_log_head,l_progress,'p_partial_resv_flag',p_partial_resv_flag);

1070: PO_DEBUG.debug_begin(l_log_head);
1071: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
1072: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
1073: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_mode',p_gl_mode);
1074: PO_DEBUG.debug_var(l_log_head,l_progress,'p_partial_resv_flag',p_partial_resv_flag);
1075: PO_DEBUG.debug_var(l_log_head,l_progress,'p_override',p_override);
1076: PO_DEBUG.debug_var(l_log_head,l_progress,'p_conc_flag',p_conc_flag);
1077: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
1078: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_resp_id',p_user_resp_id);

Line 1075: PO_DEBUG.debug_var(l_log_head,l_progress,'p_override',p_override);

1071: PO_DEBUG.debug_var(l_log_head,l_progress,'p_set_of_books_id',p_set_of_books_id);
1072: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
1073: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_mode',p_gl_mode);
1074: PO_DEBUG.debug_var(l_log_head,l_progress,'p_partial_resv_flag',p_partial_resv_flag);
1075: PO_DEBUG.debug_var(l_log_head,l_progress,'p_override',p_override);
1076: PO_DEBUG.debug_var(l_log_head,l_progress,'p_conc_flag',p_conc_flag);
1077: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
1078: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_resp_id',p_user_resp_id);
1079: END IF;

Line 1076: PO_DEBUG.debug_var(l_log_head,l_progress,'p_conc_flag',p_conc_flag);

1072: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
1073: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_mode',p_gl_mode);
1074: PO_DEBUG.debug_var(l_log_head,l_progress,'p_partial_resv_flag',p_partial_resv_flag);
1075: PO_DEBUG.debug_var(l_log_head,l_progress,'p_override',p_override);
1076: PO_DEBUG.debug_var(l_log_head,l_progress,'p_conc_flag',p_conc_flag);
1077: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
1078: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_resp_id',p_user_resp_id);
1079: END IF;
1080:

Line 1077: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);

1073: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_mode',p_gl_mode);
1074: PO_DEBUG.debug_var(l_log_head,l_progress,'p_partial_resv_flag',p_partial_resv_flag);
1075: PO_DEBUG.debug_var(l_log_head,l_progress,'p_override',p_override);
1076: PO_DEBUG.debug_var(l_log_head,l_progress,'p_conc_flag',p_conc_flag);
1077: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
1078: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_resp_id',p_user_resp_id);
1079: END IF;
1080:
1081: l_progress := '100';

Line 1078: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_resp_id',p_user_resp_id);

1074: PO_DEBUG.debug_var(l_log_head,l_progress,'p_partial_resv_flag',p_partial_resv_flag);
1075: PO_DEBUG.debug_var(l_log_head,l_progress,'p_override',p_override);
1076: PO_DEBUG.debug_var(l_log_head,l_progress,'p_conc_flag',p_conc_flag);
1077: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id',p_user_id);
1078: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_resp_id',p_user_resp_id);
1079: END IF;
1080:
1081: l_progress := '100';
1082: -- Bug 4995509 Begin

Line 1131: PO_DEBUG.debug_var(l_log_head,l_progress,'PSA function return_code', l_status_code);

1127: l_progress := '120';
1128: --
1129:
1130: IF g_debug_stmt THEN
1131: PO_DEBUG.debug_var(l_log_head,l_progress,'PSA function return_code', l_status_code);
1132: END IF;
1133:
1134: --
1135: -- Raise exception if return status is Unexpected error('U') or

Line 1155: PO_DEBUG.debug_stmt(l_log_head,l_progress,'GL Call Executed Successfully');

1151:
1152: l_progress := '140';
1153:
1154: IF g_debug_stmt THEN
1155: PO_DEBUG.debug_stmt(l_log_head,l_progress,'GL Call Executed Successfully');
1156: END IF;
1157:
1158: -- END IF; -- p_gl_mode <> 'F' or l_validate_return_status...
1159: --

Line 1164: PO_DEBUG.debug_var(l_log_head,l_progress,'GL Call x_return_code',x_return_code);

1160:
1161: l_progress := '900';
1162:
1163: IF g_debug_stmt THEN
1164: PO_DEBUG.debug_var(l_log_head,l_progress,'GL Call x_return_code',x_return_code);
1165: PO_DEBUG.debug_end(l_log_head);
1166: END IF;
1167:
1168: EXCEPTION

Line 1165: PO_DEBUG.debug_end(l_log_head);

1161: l_progress := '900';
1162:
1163: IF g_debug_stmt THEN
1164: PO_DEBUG.debug_var(l_log_head,l_progress,'GL Call x_return_code',x_return_code);
1165: PO_DEBUG.debug_end(l_log_head);
1166: END IF;
1167:
1168: EXCEPTION
1169: WHEN g_GL_FUNDS_API_EXC THEN

Line 1178: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_code',x_return_code);

1174: FND_MESSAGE.set_token('PROC_CALLER',
1175: 'PO_ENCUMBRANCE_POSTPROCESSING.execute_gl_call');
1176: fnd_msg_pub.add;
1177: IF g_debug_unexp THEN
1178: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_code',x_return_code);
1179: END IF; */
1180: RAISE PO_ENCUMBRANCE_POSTPROCESSING.g_EXECUTE_GL_CALL_API_EXC;
1181: -----
1182:

Line 1275: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id', p_packet_id);

1271:
1272: BEGIN
1273:
1274: IF g_debug_stmt THEN
1275: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id', p_packet_id);
1276: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action', p_action);
1277: END IF;
1278:
1279: /*Gathering the event source info to delete event */

Line 1276: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action', p_action);

1272: BEGIN
1273:
1274: IF g_debug_stmt THEN
1275: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id', p_packet_id);
1276: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action', p_action);
1277: END IF;
1278:
1279: /*Gathering the event source info to delete event */
1280: l_event_source_info.legal_entity_id := xle_utilities_grp.Get_DefaultLegalContext_OU(PO_MOAC_UTILS_PVT.Get_Current_Org_Id );

Line 1294: PO_DEBUG.debug_var(l_log_head,l_progress,'legal_entity_id', l_event_source_info.legal_entity_id);

1290:
1291: l_progress := '010';
1292:
1293: IF g_debug_stmt THEN
1294: PO_DEBUG.debug_var(l_log_head,l_progress,'legal_entity_id', l_event_source_info.legal_entity_id);
1295: PO_DEBUG.debug_var(l_log_head,l_progress,'ledger_id', l_event_source_info.ledger_id);
1296: PO_DEBUG.debug_var(l_log_head,l_progress,'security_id_int_1', l_security_context.security_id_int_1);
1297: END IF;
1298:

Line 1295: PO_DEBUG.debug_var(l_log_head,l_progress,'ledger_id', l_event_source_info.ledger_id);

1291: l_progress := '010';
1292:
1293: IF g_debug_stmt THEN
1294: PO_DEBUG.debug_var(l_log_head,l_progress,'legal_entity_id', l_event_source_info.legal_entity_id);
1295: PO_DEBUG.debug_var(l_log_head,l_progress,'ledger_id', l_event_source_info.ledger_id);
1296: PO_DEBUG.debug_var(l_log_head,l_progress,'security_id_int_1', l_security_context.security_id_int_1);
1297: END IF;
1298:
1299:

Line 1296: PO_DEBUG.debug_var(l_log_head,l_progress,'security_id_int_1', l_security_context.security_id_int_1);

1292:
1293: IF g_debug_stmt THEN
1294: PO_DEBUG.debug_var(l_log_head,l_progress,'legal_entity_id', l_event_source_info.legal_entity_id);
1295: PO_DEBUG.debug_var(l_log_head,l_progress,'ledger_id', l_event_source_info.ledger_id);
1296: PO_DEBUG.debug_var(l_log_head,l_progress,'security_id_int_1', l_security_context.security_id_int_1);
1297: END IF;
1298:
1299:
1300: /*delete draft and invalid events*/

Line 1306: PO_DEBUG.debug_var(l_log_head,l_progress,'iteration for event_id', rec_to_del.ae_event_id);

1302: IF (p_action= g_action_RESERVE) THEN
1303: l_progress := '030';
1304: FOR rec_to_del IN to_delete_checkfunds loop
1305: IF g_debug_stmt THEN
1306: PO_DEBUG.debug_var(l_log_head,l_progress,'iteration for event_id', rec_to_del.ae_event_id);
1307: END IF;
1308:
1309: /*event_ids are collected now*/
1310: /*have to delete these events*/

Line 1318: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.entity_type_code', l_event_source_info.entity_type_code);

1314: l_event_source_info.source_id_int_1 := rec_to_del.applied_to_header_id_1;
1315:
1316:
1317: IF g_debug_stmt THEN
1318: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.entity_type_code', l_event_source_info.entity_type_code);
1319: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.transaction_number', l_event_source_info.transaction_number);
1320: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.source_id_int_1', l_event_source_info.source_id_int_1 );
1321: END IF;
1322:

Line 1319: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.transaction_number', l_event_source_info.transaction_number);

1315:
1316:
1317: IF g_debug_stmt THEN
1318: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.entity_type_code', l_event_source_info.entity_type_code);
1319: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.transaction_number', l_event_source_info.transaction_number);
1320: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.source_id_int_1', l_event_source_info.source_id_int_1 );
1321: END IF;
1322:
1323: xla_events_pub_pkg.DELETE_EVENT

Line 1320: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.source_id_int_1', l_event_source_info.source_id_int_1 );

1316:
1317: IF g_debug_stmt THEN
1318: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.entity_type_code', l_event_source_info.entity_type_code);
1319: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.transaction_number', l_event_source_info.transaction_number);
1320: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.source_id_int_1', l_event_source_info.source_id_int_1 );
1321: END IF;
1322:
1323: xla_events_pub_pkg.DELETE_EVENT
1324: (

Line 1344: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.entity_type_code', l_event_source_info.entity_type_code);

1340: l_event_source_info.transaction_number := rec_to_del.segment1;
1341: l_event_source_info.source_id_int_1 := rec_to_del.applied_to_header_id_1;
1342:
1343: IF g_debug_stmt THEN
1344: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.entity_type_code', l_event_source_info.entity_type_code);
1345: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.transaction_number', l_event_source_info.transaction_number);
1346: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.source_id_int_1', l_event_source_info.source_id_int_1 );
1347: END IF;
1348:

Line 1345: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.transaction_number', l_event_source_info.transaction_number);

1341: l_event_source_info.source_id_int_1 := rec_to_del.applied_to_header_id_1;
1342:
1343: IF g_debug_stmt THEN
1344: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.entity_type_code', l_event_source_info.entity_type_code);
1345: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.transaction_number', l_event_source_info.transaction_number);
1346: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.source_id_int_1', l_event_source_info.source_id_int_1 );
1347: END IF;
1348:
1349: xla_events_pub_pkg.DELETE_EVENT

Line 1346: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.source_id_int_1', l_event_source_info.source_id_int_1 );

1342:
1343: IF g_debug_stmt THEN
1344: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.entity_type_code', l_event_source_info.entity_type_code);
1345: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.transaction_number', l_event_source_info.transaction_number);
1346: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_source_info.source_id_int_1', l_event_source_info.source_id_int_1 );
1347: END IF;
1348:
1349: xla_events_pub_pkg.DELETE_EVENT
1350: (

Line 1365: PO_DEBUG.debug_var(l_log_head,l_progress, 'Exception block of Delete_unnecessary_events', SQLERRM);

1361:
1362: EXCEPTION
1363: WHEN OTHERS THEN
1364: IF g_debug_stmt THEN
1365: PO_DEBUG.debug_var(l_log_head,l_progress, 'Exception block of Delete_unnecessary_events', SQLERRM);
1366: END IF;
1367: RAISE;
1368: END;
1369:

Line 1426: PO_DEBUG.debug_begin(l_log_head);

1422: l_reference15_tbl reference15_tbl_type;--bug#5201733
1423: BEGIN
1424:
1425: IF g_debug_stmt THEN
1426: PO_DEBUG.debug_begin(l_log_head);
1427: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
1428: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);
1429: END IF;
1430: --

Line 1427: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);

1423: BEGIN
1424:
1425: IF g_debug_stmt THEN
1426: PO_DEBUG.debug_begin(l_log_head);
1427: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
1428: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);
1429: END IF;
1430: --
1431: l_progress := '010';

Line 1428: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);

1424:
1425: IF g_debug_stmt THEN
1426: PO_DEBUG.debug_begin(l_log_head);
1427: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
1428: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);
1429: END IF;
1430: --
1431: l_progress := '010';
1432:

Line 1628: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Status/Result codes returned for '

1624: -- Bug#14593047 END--
1625:
1626: IF g_debug_stmt THEN
1627: l_debug_count := SQL%ROWCOUNT;
1628: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Status/Result codes returned for '
1629: || l_debug_count || ' rows');
1630: END IF;
1631:
1632: l_progress := '020';

Line 1653: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Status/Result codes updated on '

1649: --the encumbered_amount, since no trxn was sent to GL.
1650:
1651: IF g_debug_stmt THEN
1652: l_debug_count := SQL%ROWCOUNT;
1653: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Status/Result codes updated on '
1654: || l_debug_count || ' rows');
1655: END IF;
1656:
1657: --

Line 1674: PO_DEBUG.debug_stmt(l_log_head,l_progress,

1670: AND DISTS.result_text IS NULL;
1671:
1672: IF g_debug_stmt THEN
1673: l_debug_count := SQL%ROWCOUNT;
1674: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1675: 'Number of prevent rows updated: ' || l_debug_count);
1676: END IF;
1677:
1678: l_progress := '040';

Line 1692: PO_DEBUG.debug_stmt(l_log_head,l_progress,

1688: AND DISTS.result_text IS NULL;
1689:
1690: IF g_debug_stmt THEN
1691: l_debug_count := SQL%ROWCOUNT;
1692: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1693: 'Number of result text rows updated: ' || l_debug_count);
1694: END IF;
1695:
1696: l_progress := '050';

Line 1702: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updating successful rows.');

1698: IF p_gl_return_code IN ('A', 'S', 'P') THEN
1699:
1700: l_progress := '060';
1701: IF g_debug_stmt THEN
1702: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updating successful rows.');
1703: END IF;
1704:
1705: UPDATE PO_ENCUMBRANCE_GT DISTS
1706: SET DISTS.result_type = g_result_WARNING

Line 1716: PO_DEBUG.debug_stmt(l_log_head,l_progress,

1712: l_progress := '070';
1713:
1714: IF g_debug_stmt THEN
1715: l_debug_count := SQL%ROWCOUNT;
1716: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1717: 'Number of rows set to Warning: ' || l_debug_count);
1718: END IF;
1719:
1720: UPDATE PO_ENCUMBRANCE_GT DISTS

Line 1729: PO_DEBUG.debug_stmt(l_log_head,l_progress,

1725: l_progress := '080';
1726:
1727: IF g_debug_stmt THEN
1728: l_debug_count := SQL%ROWCOUNT;
1729: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1730: 'Number of rows set to Success: ' || l_debug_count);
1731: END IF;
1732:
1733: END IF; -- gl_return_code is S, A or P

Line 1742: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updating failed rows.');

1738:
1739: l_progress := '110';
1740:
1741: IF g_debug_stmt THEN
1742: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updating failed rows.');
1743: END IF;
1744:
1745: l_not_processed_msg := FND_MESSAGE.get_string('PO', 'PO_ENC_DIST_NOT_PROCESSED');
1746:

Line 1757: PO_DEBUG.debug_stmt(l_log_head,l_progress,

1753: l_progress := '120';
1754:
1755: IF g_debug_stmt THEN
1756: l_debug_count := SQL%ROWCOUNT;
1757: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1758: 'Number of rows failed: ' || l_debug_count);
1759: END IF;
1760:
1761: UPDATE PO_ENCUMBRANCE_GT DISTS

Line 1772: PO_DEBUG.debug_stmt(l_log_head,l_progress,

1768: l_progress := '130';
1769:
1770: IF g_debug_stmt THEN
1771: l_debug_count := SQL%ROWCOUNT;
1772: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1773: 'Number of rows not processed: ' || l_debug_count);
1774: END IF;
1775:
1776: END IF; -- gl_return_code is P, F or T

Line 1781: PO_DEBUG.debug_stmt(l_log_head,l_progress,

1777:
1778: l_progress := '900';
1779:
1780: IF g_debug_stmt THEN
1781: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1782: 'PO update of text/message type successful');
1783: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',
1784: PO_DEBUG.g_all_rows,
1785: po_tbl_varchar30('result_text', 'result_type',

Line 1783: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',

1779:
1780: IF g_debug_stmt THEN
1781: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1782: 'PO update of text/message type successful');
1783: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',
1784: PO_DEBUG.g_all_rows,
1785: po_tbl_varchar30('result_text', 'result_type',
1786: 'prevent_encumbrance_flag')
1787: );

Line 1784: PO_DEBUG.g_all_rows,

1780: IF g_debug_stmt THEN
1781: PO_DEBUG.debug_stmt(l_log_head,l_progress,
1782: 'PO update of text/message type successful');
1783: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',
1784: PO_DEBUG.g_all_rows,
1785: po_tbl_varchar30('result_text', 'result_type',
1786: 'prevent_encumbrance_flag')
1787: );
1788: PO_DEBUG.debug_end(l_log_head);

Line 1788: PO_DEBUG.debug_end(l_log_head);

1784: PO_DEBUG.g_all_rows,
1785: po_tbl_varchar30('result_text', 'result_type',
1786: 'prevent_encumbrance_flag')
1787: );
1788: PO_DEBUG.debug_end(l_log_head);
1789: END IF;
1790: --
1791: EXCEPTION
1792:

Line 1856: PO_DEBUG.debug_begin(l_log_head);

1852:
1853: l_progress := '000';
1854:
1855: IF g_debug_stmt THEN
1856: PO_DEBUG.debug_begin(l_log_head);
1857: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
1858: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
1859: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
1860: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);

Line 1857: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);

1853: l_progress := '000';
1854:
1855: IF g_debug_stmt THEN
1856: PO_DEBUG.debug_begin(l_log_head);
1857: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
1858: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
1859: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
1860: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);
1861: END IF;

Line 1858: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);

1854:
1855: IF g_debug_stmt THEN
1856: PO_DEBUG.debug_begin(l_log_head);
1857: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
1858: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
1859: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
1860: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);
1861: END IF;
1862:

Line 1859: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);

1855: IF g_debug_stmt THEN
1856: PO_DEBUG.debug_begin(l_log_head);
1857: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
1858: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
1859: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
1860: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);
1861: END IF;
1862:
1863: l_progress := '010';

Line 1860: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);

1856: PO_DEBUG.debug_begin(l_log_head);
1857: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
1858: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
1859: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
1860: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);
1861: END IF;
1862:
1863: l_progress := '010';
1864:

Line 1892: PO_DEBUG.debug_end(l_log_head);

1888:
1889: l_progress := '040';
1890:
1891: IF g_debug_stmt THEN
1892: PO_DEBUG.debug_end(l_log_head);
1893: END IF;
1894:
1895: EXCEPTION
1896: WHEN OTHERS THEN

Line 1968: PO_DEBUG.debug_begin(l_log_head);

1964:
1965: l_progress := '000';
1966:
1967: IF g_debug_stmt THEN
1968: PO_DEBUG.debug_begin(l_log_head);
1969: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
1970: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
1971: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
1972: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);

Line 1969: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);

1965: l_progress := '000';
1966:
1967: IF g_debug_stmt THEN
1968: PO_DEBUG.debug_begin(l_log_head);
1969: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
1970: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
1971: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
1972: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);
1973: END IF;

Line 1970: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);

1966:
1967: IF g_debug_stmt THEN
1968: PO_DEBUG.debug_begin(l_log_head);
1969: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
1970: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
1971: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
1972: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);
1973: END IF;
1974:

Line 1971: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);

1967: IF g_debug_stmt THEN
1968: PO_DEBUG.debug_begin(l_log_head);
1969: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
1970: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
1971: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
1972: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);
1973: END IF;
1974:
1975: l_progress := '010';

Line 1972: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);

1968: PO_DEBUG.debug_begin(l_log_head);
1969: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
1970: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
1971: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
1972: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',p_gl_return_code);
1973: END IF;
1974:
1975: l_progress := '010';
1976:

Line 2017: PO_DEBUG.debug_var(l_log_head,l_progress,'l_flip_enc_flag',l_flip_enc_flag);

2013:
2014: END IF;
2015:
2016: IF g_debug_stmt THEN
2017: PO_DEBUG.debug_var(l_log_head,l_progress,'l_flip_enc_flag',l_flip_enc_flag);
2018: PO_DEBUG.debug_var(l_log_head,l_progress,'l_main_doc_enc_flag',
2019: l_main_doc_enc_flag_success);
2020: PO_DEBUG.debug_var(l_log_head,l_progress,'l_backing_req_enc_flag',
2021: l_backing_req_enc_flag_success);

Line 2018: PO_DEBUG.debug_var(l_log_head,l_progress,'l_main_doc_enc_flag',

2014: END IF;
2015:
2016: IF g_debug_stmt THEN
2017: PO_DEBUG.debug_var(l_log_head,l_progress,'l_flip_enc_flag',l_flip_enc_flag);
2018: PO_DEBUG.debug_var(l_log_head,l_progress,'l_main_doc_enc_flag',
2019: l_main_doc_enc_flag_success);
2020: PO_DEBUG.debug_var(l_log_head,l_progress,'l_backing_req_enc_flag',
2021: l_backing_req_enc_flag_success);
2022: END IF;

Line 2020: PO_DEBUG.debug_var(l_log_head,l_progress,'l_backing_req_enc_flag',

2016: IF g_debug_stmt THEN
2017: PO_DEBUG.debug_var(l_log_head,l_progress,'l_flip_enc_flag',l_flip_enc_flag);
2018: PO_DEBUG.debug_var(l_log_head,l_progress,'l_main_doc_enc_flag',
2019: l_main_doc_enc_flag_success);
2020: PO_DEBUG.debug_var(l_log_head,l_progress,'l_backing_req_enc_flag',
2021: l_backing_req_enc_flag_success);
2022: END IF;
2023:
2024: --NOTE: The Temp Table field encumbered_amount_change is used throughout these

Line 2030: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2026: -- copy_detailed_gl_results.
2027:
2028: l_progress := '020';
2029: IF g_debug_stmt THEN
2030: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2031: 'Updated encumbered_amount_change');
2032: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',
2033: PO_DEBUG.g_all_rows,
2034: po_tbl_varchar30('encumbered_flag',

Line 2032: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',

2028: l_progress := '020';
2029: IF g_debug_stmt THEN
2030: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2031: 'Updated encumbered_amount_change');
2032: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',
2033: PO_DEBUG.g_all_rows,
2034: po_tbl_varchar30('encumbered_flag',
2035: 'encumbered_amount_change')
2036: );

Line 2033: PO_DEBUG.g_all_rows,

2029: IF g_debug_stmt THEN
2030: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2031: 'Updated encumbered_amount_change');
2032: PO_DEBUG.debug_table(l_log_head, l_progress, 'PO_ENCUMBRANCE_GT',
2033: PO_DEBUG.g_all_rows,
2034: po_tbl_varchar30('encumbered_flag',
2035: 'encumbered_amount_change')
2036: );
2037: END IF;

Line 2112: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2108:
2109: l_progress := '030';
2110: IF g_debug_stmt THEN
2111: l_debug_count := SQL%ROWCOUNT;
2112: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2113: 'Updated Main Req dists: ' || l_debug_count);
2114: END IF;
2115:
2116: --bug 3537764: added following code to handle flags for Req Split

Line 2170: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2166:
2167: l_progress := '032';
2168: IF g_debug_stmt THEN
2169: l_debug_count := SQL%ROWCOUNT;
2170: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2171: 'Updated Req Split dists: ' || l_debug_count);
2172: END IF;
2173: END IF; -- if action is req split
2174:

Line 2233: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2229:
2230: l_progress := '040';
2231: IF g_debug_stmt THEN
2232: l_debug_count := SQL%ROWCOUNT;
2233: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2234: 'Updated Main PO/Rel dists: ' || l_debug_count);
2235: END IF;
2236:
2237: l_progress := '045';

Line 2297: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2293:
2294: l_progress := '050';
2295: IF g_debug_stmt THEN
2296: l_debug_count := SQL%ROWCOUNT;
2297: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2298: 'Updated Backing Req dists: ' || l_debug_count);
2299: END IF;
2300:
2301: END IF; -- backing Reqs

Line 2364: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2360:
2361: l_progress := '060';
2362: IF g_debug_stmt THEN
2363: l_debug_count := SQL%ROWCOUNT;
2364: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2365: 'Updated Backing PA/PPO dists: ' || l_debug_count);
2366: END IF;
2367:
2368: l_progress := '065';

Line 2432: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2428: l_progress := '070';
2429:
2430: IF g_debug_stmt THEN
2431: l_debug_count := SQL%ROWCOUNT;
2432: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2433: 'Updated Backing PPO dists: ' || l_debug_count);
2434: END IF;
2435:
2436: END IF; -- if main doc is a Scheduled Release

Line 2536: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2532: l_progress := '075';
2533:
2534: IF g_debug_stmt THEN
2535: l_debug_count := SQL%ROWCOUNT;
2536: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2537: 'Flipped prevent enc flag: ' || l_debug_count);
2538: END IF;
2539:
2540: END IF; -- RESERVE action and p_doc_type is PO or Release

Line 2554: PO_DEBUG.debug_stmt(l_log_head,l_progress,'CLM is Installed and Reserve Action is on a Standard PO');

2550: AND p_doc_subtype = g_doc_subtype_STANDARD) THEN
2551:
2552: l_progress := '076';
2553: IF g_debug_stmt THEN
2554: PO_DEBUG.debug_stmt(l_log_head,l_progress,'CLM is Installed and Reserve Action is on a Standard PO');
2555: END IF;
2556: -- Update the Encumbered Flag for the Main Document and Set the Change In funded Value to Zero for successful rows
2557: --Bug 15871378 commented out the update on encumbered_flag = 'N' when encumbered_amount = 0
2558: UPDATE PO_DISTRIBUTIONS_ALL POD

Line 2576: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updating the Enc Flag and UnEnc Amt for backing CLM Requisitions.');

2572: );
2573:
2574: l_progress := '077';
2575: IF g_debug_stmt THEN
2576: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Updating the Enc Flag and UnEnc Amt for backing CLM Requisitions.');
2577: END IF;
2578: -- Also set the Encumbered Flag and the unencumbered Amount for clmBacking Reqs
2579: -- Need to set Encumbered Flag to N, if Enc Amt is Zero. This is required to pick only the Backing REQs with Act.Enc for CLM POs
2580: --Bug 15871378 commented out the update on encumbered_flag = 'N' when encumbered_amount = 0

Line 2607: PO_DEBUG.debug_stmt(l_log_head,l_progress,'CLM is Installed and Reserve Action is on REQ');

2603:
2604: ELSIF p_doc_type = g_doc_type_REQUISITION THEN
2605: l_progress := '078';
2606: IF g_debug_stmt THEN
2607: PO_DEBUG.debug_stmt(l_log_head,l_progress,'CLM is Installed and Reserve Action is on REQ');
2608: END IF;
2609: --Bug 15871378 commented out the update on encumbered_flag = 'N' when encumbered_amount = 0
2610: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD
2611: SET /* PRD.ENCUMBERED_FLAG = DECODE(GREATEST(NVL(PRD.ENCUMBERED_AMOUNT,0), 0),

Line 2630: PO_DEBUG.debug_stmt(l_log_head,l_progress,'CLM is Not Installed.');

2626: END IF; --P_DOC_TYPE
2627: ELSE
2628: l_progress := '078';
2629: IF g_debug_stmt THEN
2630: PO_DEBUG.debug_stmt(l_log_head,l_progress,'CLM is Not Installed.');
2631: END IF;
2632: END IF; -- CLM INSTALLED CHECK
2633: EXCEPTION
2634: WHEN Others THEN

Line 2659: PO_DEBUG.debug_end(l_log_head);

2655:
2656: l_progress := '080';
2657:
2658: IF g_debug_stmt THEN
2659: PO_DEBUG.debug_end(l_log_head);
2660: END IF;
2661:
2662:
2663: EXCEPTION

Line 2716: PO_DEBUG.debug_begin(l_log_head);

2712:
2713: l_progress := '000';
2714:
2715: IF g_debug_stmt THEN
2716: PO_DEBUG.debug_begin(l_log_head);
2717: PO_DEBUG.debug_var(l_log_head, l_progress, 'p_doc_type', p_doc_type);
2718: PO_DEBUG.debug_var(l_log_head, l_progress, 'p_action', p_action);
2719: END IF;
2720:

Line 2717: PO_DEBUG.debug_var(l_log_head, l_progress, 'p_doc_type', p_doc_type);

2713: l_progress := '000';
2714:
2715: IF g_debug_stmt THEN
2716: PO_DEBUG.debug_begin(l_log_head);
2717: PO_DEBUG.debug_var(l_log_head, l_progress, 'p_doc_type', p_doc_type);
2718: PO_DEBUG.debug_var(l_log_head, l_progress, 'p_action', p_action);
2719: END IF;
2720:
2721: l_progress := '010';

Line 2718: PO_DEBUG.debug_var(l_log_head, l_progress, 'p_action', p_action);

2714:
2715: IF g_debug_stmt THEN
2716: PO_DEBUG.debug_begin(l_log_head);
2717: PO_DEBUG.debug_var(l_log_head, l_progress, 'p_doc_type', p_doc_type);
2718: PO_DEBUG.debug_var(l_log_head, l_progress, 'p_action', p_action);
2719: END IF;
2720:
2721: l_progress := '010';
2722:

Line 2754: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2750:
2751: l_progress := '020';
2752: IF g_debug_stmt THEN
2753: l_debug_count := SQL%ROWCOUNT;
2754: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2755: 'Updated Req dists failed funds code: ' || l_debug_count);
2756: END IF;
2757:
2758: ELSE -- p_doc_type is Not a Req

Line 2789: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2785:
2786: l_progress := '030';
2787: IF g_debug_stmt THEN
2788: l_debug_count := SQL%ROWCOUNT;
2789: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2790: 'Updated PO/Rel dists failed funds code: ' || l_debug_count);
2791: END IF;
2792:
2793: END IF; -- p_doc_type check

Line 2798: PO_DEBUG.debug_end(l_log_head);

2794:
2795: l_progress := '040';
2796:
2797: IF g_debug_stmt THEN
2798: PO_DEBUG.debug_end(l_log_head);
2799: END IF;
2800:
2801: EXCEPTION
2802: WHEN OTHERS THEN

Line 2848: PO_DEBUG.debug_begin(l_log_head);

2844:
2845: l_progress := '000';
2846:
2847: IF g_debug_stmt THEN
2848: PO_DEBUG.debug_begin(l_log_head);
2849: END IF;
2850:
2851: l_progress := '010';
2852:

Line 2896: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2892:
2893: l_progress := '020';
2894: IF g_debug_stmt THEN
2895: l_debug_count := SQL%ROWCOUNT;
2896: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2897: 'Updated Req lines: ' || l_debug_count);
2898: END IF;
2899:
2900: --SQL What: Update the encumbered_flag from the affected PO/Release

Line 2934: PO_DEBUG.debug_stmt(l_log_head,l_progress,

2930:
2931: l_progress := '030';
2932: IF g_debug_stmt THEN
2933: l_debug_count := SQL%ROWCOUNT;
2934: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2935: 'Updated PO shipments: ' || l_debug_count);
2936: PO_DEBUG.debug_end(l_log_head);
2937: END IF;
2938:

Line 2936: PO_DEBUG.debug_end(l_log_head);

2932: IF g_debug_stmt THEN
2933: l_debug_count := SQL%ROWCOUNT;
2934: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2935: 'Updated PO shipments: ' || l_debug_count);
2936: PO_DEBUG.debug_end(l_log_head);
2937: END IF;
2938:
2939: EXCEPTION
2940: WHEN OTHERS THEN

Line 3035: PO_DEBUG.debug_begin(l_log_head);

3031:
3032: BEGIN
3033:
3034: IF g_debug_stmt THEN
3035: PO_DEBUG.debug_begin(l_log_head);
3036: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
3037: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_id_tbl',p_doc_id_tbl);
3038: PO_DEBUG.debug_var(l_log_head,l_progress,'p_employee_id',p_employee_id);
3039: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);

Line 3036: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);

3032: BEGIN
3033:
3034: IF g_debug_stmt THEN
3035: PO_DEBUG.debug_begin(l_log_head);
3036: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
3037: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_id_tbl',p_doc_id_tbl);
3038: PO_DEBUG.debug_var(l_log_head,l_progress,'p_employee_id',p_employee_id);
3039: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
3040: PO_DEBUG.debug_var(l_log_head,l_progress,'p_cbc_flag',p_cbc_flag);

Line 3037: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_id_tbl',p_doc_id_tbl);

3033:
3034: IF g_debug_stmt THEN
3035: PO_DEBUG.debug_begin(l_log_head);
3036: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
3037: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_id_tbl',p_doc_id_tbl);
3038: PO_DEBUG.debug_var(l_log_head,l_progress,'p_employee_id',p_employee_id);
3039: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
3040: PO_DEBUG.debug_var(l_log_head,l_progress,'p_cbc_flag',p_cbc_flag);
3041: END IF;

Line 3038: PO_DEBUG.debug_var(l_log_head,l_progress,'p_employee_id',p_employee_id);

3034: IF g_debug_stmt THEN
3035: PO_DEBUG.debug_begin(l_log_head);
3036: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
3037: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_id_tbl',p_doc_id_tbl);
3038: PO_DEBUG.debug_var(l_log_head,l_progress,'p_employee_id',p_employee_id);
3039: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
3040: PO_DEBUG.debug_var(l_log_head,l_progress,'p_cbc_flag',p_cbc_flag);
3041: END IF;
3042:

Line 3039: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);

3035: PO_DEBUG.debug_begin(l_log_head);
3036: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
3037: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_id_tbl',p_doc_id_tbl);
3038: PO_DEBUG.debug_var(l_log_head,l_progress,'p_employee_id',p_employee_id);
3039: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
3040: PO_DEBUG.debug_var(l_log_head,l_progress,'p_cbc_flag',p_cbc_flag);
3041: END IF;
3042:
3043: l_progress := '010';

Line 3040: PO_DEBUG.debug_var(l_log_head,l_progress,'p_cbc_flag',p_cbc_flag);

3036: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
3037: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_id_tbl',p_doc_id_tbl);
3038: PO_DEBUG.debug_var(l_log_head,l_progress,'p_employee_id',p_employee_id);
3039: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
3040: PO_DEBUG.debug_var(l_log_head,l_progress,'p_cbc_flag',p_cbc_flag);
3041: END IF;
3042:
3043: l_progress := '010';
3044:

Line 3062: PO_DEBUG.debug_var(l_log_head,l_progress,'l_record_action',l_record_action);

3058: l_record_action := p_action;
3059: END IF;
3060:
3061: IF g_debug_stmt THEN
3062: PO_DEBUG.debug_var(l_log_head,l_progress,'l_record_action',l_record_action);
3063: END IF;
3064:
3065: l_progress := '050';
3066:

Line 3190: PO_DEBUG.debug_session_gt(l_log_head,l_progress,l_gt_key

3186:
3187: l_progress := '160';
3188:
3189: IF g_debug_stmt THEN
3190: PO_DEBUG.debug_session_gt(l_log_head,l_progress,l_gt_key
3191: , po_tbl_varchar30('num1','num2','char1','char2','char3')
3192: );
3193: END IF;
3194:

Line 3246: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_id',l_doc_id);

3242: l_doc_subtype := l_orig_doc_subtype_tbl(i);
3243: l_rev_num := l_orig_rev_num_tbl(i);
3244:
3245: IF g_debug_stmt THEN
3246: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_id',l_doc_id);
3247: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);
3248: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rev_num',l_rev_num);
3249: END IF;
3250:

Line 3247: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);

3243: l_rev_num := l_orig_rev_num_tbl(i);
3244:
3245: IF g_debug_stmt THEN
3246: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_id',l_doc_id);
3247: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);
3248: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rev_num',l_rev_num);
3249: END IF;
3250:
3251: -- Is there a NULL action?

Line 3248: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rev_num',l_rev_num);

3244:
3245: IF g_debug_stmt THEN
3246: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_id',l_doc_id);
3247: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);
3248: PO_DEBUG.debug_var(l_log_head,l_progress,'l_rev_num',l_rev_num);
3249: END IF;
3250:
3251: -- Is there a NULL action?
3252:

Line 3256: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'A NULL Action Histroy Exists' );

3252:
3253: IF (l_orig_null_flag_tbl(i) = 'Y') THEN
3254:
3255: IF g_debug_stmt THEN
3256: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'A NULL Action Histroy Exists' );
3257: END IF;
3258: -- There is a NULL action for this doc, so update it.
3259:
3260: l_update_doc_id_tbl.EXTEND;

Line 3277: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Creating Blank Action Histroy' );

3273: and (p_doc_type <> g_doc_type_REQUISITION)
3274: ) THEN
3275:
3276: IF g_debug_stmt THEN
3277: PO_DEBUG.debug_stmt(l_log_head,l_progress, 'Creating Blank Action Histroy' );
3278: END IF;
3279: l_insert_doc_id_tbl.EXTEND;
3280: l_insert_doc_subtype_tbl.EXTEND;
3281: l_insert_action_code_tbl.EXTEND;

Line 3379: PO_DEBUG.debug_end(l_log_head);

3375:
3376: l_progress := '900';
3377:
3378: IF g_debug_stmt THEN
3379: PO_DEBUG.debug_end(l_log_head);
3380: END IF;
3381:
3382: EXCEPTION
3383: WHEN OTHERS THEN

Line 3437: PO_DEBUG.debug_begin(l_log_head);

3433:
3434: l_progress := '000';
3435:
3436: IF g_debug_stmt THEN
3437: PO_DEBUG.debug_begin(l_log_head);
3438: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type',p_document_type);
3439: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
3440: PO_DEBUG.debug_var(l_log_head,l_progress,'p_cbc_flag',p_cbc_flag);
3441: END IF;

Line 3438: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type',p_document_type);

3434: l_progress := '000';
3435:
3436: IF g_debug_stmt THEN
3437: PO_DEBUG.debug_begin(l_log_head);
3438: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type',p_document_type);
3439: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
3440: PO_DEBUG.debug_var(l_log_head,l_progress,'p_cbc_flag',p_cbc_flag);
3441: END IF;
3442:

Line 3439: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);

3435:
3436: IF g_debug_stmt THEN
3437: PO_DEBUG.debug_begin(l_log_head);
3438: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type',p_document_type);
3439: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
3440: PO_DEBUG.debug_var(l_log_head,l_progress,'p_cbc_flag',p_cbc_flag);
3441: END IF;
3442:
3443: -- Only change doc status to Requires Reapproval when

Line 3440: PO_DEBUG.debug_var(l_log_head,l_progress,'p_cbc_flag',p_cbc_flag);

3436: IF g_debug_stmt THEN
3437: PO_DEBUG.debug_begin(l_log_head);
3438: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type',p_document_type);
3439: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
3440: PO_DEBUG.debug_var(l_log_head,l_progress,'p_cbc_flag',p_cbc_flag);
3441: END IF;
3442:
3443: -- Only change doc status to Requires Reapproval when
3444: -- 1. Normal Unreserve action succeeds

Line 3458: PO_DEBUG.debug_stmt(l_log_head,l_progress,'No status change; early return');

3454:
3455: ELSE
3456: --for all other actions, do not change the document status
3457: IF g_debug_stmt THEN
3458: PO_DEBUG.debug_stmt(l_log_head,l_progress,'No status change; early return');
3459: END IF;
3460:
3461: RETURN;
3462: END IF;

Line 3465: PO_DEBUG.debug_var(l_log_head,l_progress,

3461: RETURN;
3462: END IF;
3463:
3464: IF g_debug_stmt THEN
3465: PO_DEBUG.debug_var(l_log_head,l_progress,
3466: 'l_affected_gl_status_code',l_affected_gl_status_code);
3467: END IF;
3468:
3469:

Line 3505: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3501: );
3502:
3503: IF g_debug_stmt THEN
3504: l_debug_count := SQL%ROWCOUNT;
3505: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3506: 'PO Shipment flags updated : ' || l_debug_count);
3507: END IF;
3508:
3509: -- Now rollup the Approval flag from Shipments to Headers.

Line 3540: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3536: );
3537:
3538: IF g_debug_stmt THEN
3539: l_debug_count := SQL%ROWCOUNT;
3540: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3541: 'PO Headers updated : ' || l_debug_count);
3542: END IF;
3543:
3544: ELSIF (p_document_type = g_doc_type_PA) THEN

Line 3577: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3573: );
3574:
3575: IF g_debug_stmt THEN
3576: l_debug_count := SQL%ROWCOUNT;
3577: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3578: 'PA Headers updated : ' || l_debug_count);
3579: END IF;
3580:
3581: ELSIF (p_document_type = g_doc_type_RELEASE) THEN

Line 3612: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3608: );
3609:
3610: IF g_debug_stmt THEN
3611: l_debug_count := SQL%ROWCOUNT;
3612: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3613: 'Release shipments updated : ' || l_debug_count);
3614: END IF;
3615:
3616: l_progress := '060';

Line 3645: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3641: );
3642:
3643: IF g_debug_stmt THEN
3644: l_debug_count := SQL%ROWCOUNT;
3645: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3646: 'Release Headers updated : ' || l_debug_count);
3647: END IF;
3648:
3649: ELSE -- This is the case of requisitions. For requisitions, once the document is

Line 3661: PO_DEBUG.debug_end(l_log_head);

3657:
3658: l_progress := '070';
3659:
3660: IF g_debug_stmt THEN
3661: PO_DEBUG.debug_end(l_log_head);
3662: END IF;
3663:
3664: EXCEPTION
3665: WHEN OTHERS THEN

Line 3743: PO_DEBUG.debug_begin(l_log_head);

3739: l_error_rows_flag VARCHAR2(1);
3740: BEGIN
3741:
3742: IF g_debug_stmt THEN
3743: PO_DEBUG.debug_begin(l_log_head);
3744: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',
3745: p_gl_return_code);
3746: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);
3747: END IF;

Line 3744: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',

3740: BEGIN
3741:
3742: IF g_debug_stmt THEN
3743: PO_DEBUG.debug_begin(l_log_head);
3744: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',
3745: p_gl_return_code);
3746: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);
3747: END IF;
3748:

Line 3746: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);

3742: IF g_debug_stmt THEN
3743: PO_DEBUG.debug_begin(l_log_head);
3744: PO_DEBUG.debug_var(l_log_head,l_progress,'p_gl_return_code',
3745: p_gl_return_code);
3746: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);
3747: END IF;
3748:
3749: l_progress := '010';
3750:

Line 3784: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3780:
3781: l_progress := '030';
3782: IF g_debug_stmt THEN
3783: l_debug_count := SQL%ROWCOUNT;
3784: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3785: 'Appended entity nums to lines: ' || l_debug_count);
3786: END IF;
3787:
3788:

Line 3832: PO_DEBUG.debug_stmt(l_log_head,l_progress,

3828:
3829: l_progress := '040';
3830: IF g_debug_stmt THEN
3831: l_debug_count := SQL%ROWCOUNT;
3832: PO_DEBUG.debug_stmt(l_log_head,l_progress,
3833: 'Retrieved result info for rows: ' || l_debug_count);
3834: END IF;
3835:
3836: -- Make the autonomous call out to insert the result information.

Line 3906: PO_DEBUG.debug_var(l_log_head,l_progress,

3902: END IF;
3903:
3904: l_progress := '054';
3905: IF g_debug_stmt THEN
3906: PO_DEBUG.debug_var(l_log_head,l_progress,
3907: 'l_warning_rows_flag',l_warning_rows_flag);
3908: END IF;
3909:
3910: IF (nvl(l_warning_rows_flag,'N') = 'Y') THEN

Line 3948: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',

3944: END IF;
3945:
3946: l_progress := '060';
3947: IF g_debug_stmt THEN
3948: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',
3949: x_online_report_id);
3950: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',
3951: x_po_return_code);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_msg_name',

Line 3950: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',

3946: l_progress := '060';
3947: IF g_debug_stmt THEN
3948: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',
3949: x_online_report_id);
3950: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',
3951: x_po_return_code);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_msg_name',
3953: x_po_return_msg_name);
3954: PO_DEBUG.debug_end(l_log_head);

Line 3952: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_msg_name',

3948: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',
3949: x_online_report_id);
3950: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',
3951: x_po_return_code);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_msg_name',
3953: x_po_return_msg_name);
3954: PO_DEBUG.debug_end(l_log_head);
3955: END IF;
3956:

Line 3954: PO_DEBUG.debug_end(l_log_head);

3950: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_code',
3951: x_po_return_code);
3952: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_return_msg_name',
3953: x_po_return_msg_name);
3954: PO_DEBUG.debug_end(l_log_head);
3955: END IF;
3956:
3957: EXCEPTION
3958: WHEN OTHERS THEN

Line 4009: PO_DEBUG.debug_begin(l_log_head);

4005:
4006: BEGIN
4007:
4008: IF g_debug_stmt THEN
4009: PO_DEBUG.debug_begin(l_log_head);
4010: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_text', p_message_text);
4011: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);
4012: END IF;
4013:

Line 4010: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_text', p_message_text);

4006: BEGIN
4007:
4008: IF g_debug_stmt THEN
4009: PO_DEBUG.debug_begin(l_log_head);
4010: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_text', p_message_text);
4011: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);
4012: END IF;
4013:
4014: insert_report_autonomous(

Line 4011: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);

4007:
4008: IF g_debug_stmt THEN
4009: PO_DEBUG.debug_begin(l_log_head);
4010: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_text', p_message_text);
4011: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);
4012: END IF;
4013:
4014: insert_report_autonomous(
4015: p_reporting_level => g_REPORT_LEVEL_TRANSACTION

Line 4034: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',

4030: );
4031:
4032: l_progress := '010';
4033: IF g_debug_stmt THEN
4034: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',
4035: x_online_report_id);
4036: PO_DEBUG.debug_end(l_log_head);
4037: END IF;
4038:

Line 4036: PO_DEBUG.debug_end(l_log_head);

4032: l_progress := '010';
4033: IF g_debug_stmt THEN
4034: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',
4035: x_online_report_id);
4036: PO_DEBUG.debug_end(l_log_head);
4037: END IF;
4038:
4039: EXCEPTION
4040: WHEN OTHERS THEN

Line 4142: PO_DEBUG.debug_begin(l_log_head);

4138:
4139: BEGIN
4140:
4141: IF g_debug_stmt THEN
4142: PO_DEBUG.debug_begin(l_log_head);
4143: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reporting_level',
4144: p_reporting_level);
4145: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_text', p_message_text);
4146: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);

Line 4143: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reporting_level',

4139: BEGIN
4140:
4141: IF g_debug_stmt THEN
4142: PO_DEBUG.debug_begin(l_log_head);
4143: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reporting_level',
4144: p_reporting_level);
4145: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_text', p_message_text);
4146: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);
4147: PO_DEBUG.debug_var(l_log_head,l_progress,'p_text_line_tbl',p_text_line_tbl);

Line 4145: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_text', p_message_text);

4141: IF g_debug_stmt THEN
4142: PO_DEBUG.debug_begin(l_log_head);
4143: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reporting_level',
4144: p_reporting_level);
4145: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_text', p_message_text);
4146: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);
4147: PO_DEBUG.debug_var(l_log_head,l_progress,'p_text_line_tbl',p_text_line_tbl);
4148: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_type_tbl',p_message_type_tbl);
4149: END IF;

Line 4146: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);

4142: PO_DEBUG.debug_begin(l_log_head);
4143: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reporting_level',
4144: p_reporting_level);
4145: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_text', p_message_text);
4146: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);
4147: PO_DEBUG.debug_var(l_log_head,l_progress,'p_text_line_tbl',p_text_line_tbl);
4148: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_type_tbl',p_message_type_tbl);
4149: END IF;
4150:

Line 4147: PO_DEBUG.debug_var(l_log_head,l_progress,'p_text_line_tbl',p_text_line_tbl);

4143: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reporting_level',
4144: p_reporting_level);
4145: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_text', p_message_text);
4146: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);
4147: PO_DEBUG.debug_var(l_log_head,l_progress,'p_text_line_tbl',p_text_line_tbl);
4148: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_type_tbl',p_message_type_tbl);
4149: END IF;
4150:
4151: x_online_report_id := NULL;

Line 4148: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_type_tbl',p_message_type_tbl);

4144: p_reporting_level);
4145: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_text', p_message_text);
4146: PO_DEBUG.debug_var(l_log_head,l_progress,'p_user_id', p_user_id);
4147: PO_DEBUG.debug_var(l_log_head,l_progress,'p_text_line_tbl',p_text_line_tbl);
4148: PO_DEBUG.debug_var(l_log_head,l_progress,'p_message_type_tbl',p_message_type_tbl);
4149: END IF;
4150:
4151: x_online_report_id := NULL;
4152:

Line 4171: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_id',l_report_id);

4167: l_message_text := p_message_text;
4168: END IF;
4169:
4170: IF g_debug_stmt THEN
4171: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_id',l_report_id);
4172: PO_DEBUG.debug_var(l_log_head,l_progress,'l_user_id',l_user_id);
4173: END IF;
4174:
4175: ---

Line 4172: PO_DEBUG.debug_var(l_log_head,l_progress,'l_user_id',l_user_id);

4168: END IF;
4169:
4170: IF g_debug_stmt THEN
4171: PO_DEBUG.debug_var(l_log_head,l_progress,'l_report_id',l_report_id);
4172: PO_DEBUG.debug_var(l_log_head,l_progress,'l_user_id',l_user_id);
4173: END IF;
4174:
4175: --- 4176: --from psa_xla_accounting_errors table if there is an

Line 4251: PO_DEBUG.debug_var(l_log_head,l_progress,

4247: END IF;
4248:
4249: l_progress := '050';
4250: IF g_debug_stmt THEN
4251: PO_DEBUG.debug_var(l_log_head,l_progress,
4252: 'l_single_message_flag',l_single_message_flag);
4253: END IF;
4254:
4255: IF l_single_message_flag THEN

Line 4333: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',

4329: x_online_report_id := l_report_id;
4330:
4331: l_progress := '900';
4332: IF g_debug_stmt THEN
4333: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',
4334: x_online_report_id);
4335: PO_DEBUG.debug_end(l_log_head);
4336: END IF;
4337:

Line 4335: PO_DEBUG.debug_end(l_log_head);

4331: l_progress := '900';
4332: IF g_debug_stmt THEN
4333: PO_DEBUG.debug_var(l_log_head,l_progress,'x_online_report_id',
4334: x_online_report_id);
4335: PO_DEBUG.debug_end(l_log_head);
4336: END IF;
4337:
4338: COMMIT;
4339:

Line 4394: PO_DEBUG.debug_begin(l_log_head);

4390:
4391: BEGIN
4392:
4393: IF g_debug_stmt THEN
4394: PO_DEBUG.debug_begin(l_log_head);
4395: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
4396: END IF;
4397:
4398: l_progress := '010';

Line 4395: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);

4391: BEGIN
4392:
4393: IF g_debug_stmt THEN
4394: PO_DEBUG.debug_begin(l_log_head);
4395: PO_DEBUG.debug_var(l_log_head,l_progress,'p_packet_id',p_packet_id);
4396: END IF;
4397:
4398: l_progress := '010';
4399:

Line 4414: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Delete Packet GL API Called');

4410: END LOOP;
4411: --
4412:
4413: IF g_debug_stmt THEN
4414: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Delete Packet GL API Called');
4415: END IF;
4416:
4417: l_progress := '020';
4418:

Line 4421: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Delete Packet Committed');

4417: l_progress := '020';
4418:
4419:
4420: IF g_debug_stmt THEN
4421: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Delete Packet Committed');
4422: PO_DEBUG.debug_end(l_log_head);
4423: END IF;
4424:
4425: EXCEPTION

Line 4422: PO_DEBUG.debug_end(l_log_head);

4418:
4419:
4420: IF g_debug_stmt THEN
4421: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Delete Packet Committed');
4422: PO_DEBUG.debug_end(l_log_head);
4423: END IF;
4424:
4425: EXCEPTION
4426: WHEN OTHERS THEN

Line 4517: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Start of procedure');

4513: l_progress VARCHAR2(3);
4514: BEGIN
4515: l_progress :='000';
4516: If g_debug_stmt Then
4517: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Start of procedure');
4518: PO_DEBUG.debug_var(l_log_head,l_progress,'p_online_report_id',p_online_report_id);
4519: End If;
4520: --bug#5523323 Remove the call to populate_aut_bc_report_id as this is not necessary.
4521: --we have removed the autonomous transaction.

Line 4518: PO_DEBUG.debug_var(l_log_head,l_progress,'p_online_report_id',p_online_report_id);

4514: BEGIN
4515: l_progress :='000';
4516: If g_debug_stmt Then
4517: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Start of procedure');
4518: PO_DEBUG.debug_var(l_log_head,l_progress,'p_online_report_id',p_online_report_id);
4519: End If;
4520: --bug#5523323 Remove the call to populate_aut_bc_report_id as this is not necessary.
4521: --we have removed the autonomous transaction.
4522: UPDATE

Line 4535: PO_DEBUG.debug_var(l_log_head,l_progress,'sql%rowcount',sql%rowcount);

4531:
4532: l_progress :='001';
4533:
4534: If g_debug_stmt Then
4535: PO_DEBUG.debug_var(l_log_head,l_progress,'sql%rowcount',sql%rowcount);
4536: End If;
4537:
4538: l_progress :='002';
4539:

Line 4541: PO_DEBUG.debug_stmt(l_log_head,l_progress,'End of Procedure');

4537:
4538: l_progress :='002';
4539:
4540: If g_debug_stmt Then
4541: PO_DEBUG.debug_stmt(l_log_head,l_progress,'End of Procedure');
4542: End If;
4543: EXCEPTION
4544: WHEN OTHERS THEN
4545: --add message to the stack and log a debug msg if necessary

Line 4550: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Exception raised:'||SQLCODE||' '||SQLERRM);

4546: po_message_s.sql_error(g_pkg_name, l_module_name, l_progress, SQLCODE, SQLERRM);
4547: fnd_msg_pub.add;
4548:
4549: If g_debug_stmt Then
4550: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Exception raised:'||SQLCODE||' '||SQLERRM);
4551: End If;
4552:
4553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4554: END;

Line 4602: PO_DEBUG.debug_begin(l_log_head);

4598: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
4599: l_progress VARCHAR2(3) := '000';
4600: BEGIN
4601: IF g_debug_stmt THEN
4602: PO_DEBUG.debug_begin(l_log_head);
4603: PO_DEBUG.debug_var(l_log_head,l_progress,'p_event_type_code',p_event_type_code);
4604: PO_DEBUG.debug_var(l_log_head,l_progress,'p_main_or_backing_doc',p_main_or_backing_doc);
4605: PO_DEBUG.debug_var(l_log_head,l_progress,'p_adjustment_status',p_adjustment_status);
4606: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);

Line 4603: PO_DEBUG.debug_var(l_log_head,l_progress,'p_event_type_code',p_event_type_code);

4599: l_progress VARCHAR2(3) := '000';
4600: BEGIN
4601: IF g_debug_stmt THEN
4602: PO_DEBUG.debug_begin(l_log_head);
4603: PO_DEBUG.debug_var(l_log_head,l_progress,'p_event_type_code',p_event_type_code);
4604: PO_DEBUG.debug_var(l_log_head,l_progress,'p_main_or_backing_doc',p_main_or_backing_doc);
4605: PO_DEBUG.debug_var(l_log_head,l_progress,'p_adjustment_status',p_adjustment_status);
4606: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4607: END IF;

Line 4604: PO_DEBUG.debug_var(l_log_head,l_progress,'p_main_or_backing_doc',p_main_or_backing_doc);

4600: BEGIN
4601: IF g_debug_stmt THEN
4602: PO_DEBUG.debug_begin(l_log_head);
4603: PO_DEBUG.debug_var(l_log_head,l_progress,'p_event_type_code',p_event_type_code);
4604: PO_DEBUG.debug_var(l_log_head,l_progress,'p_main_or_backing_doc',p_main_or_backing_doc);
4605: PO_DEBUG.debug_var(l_log_head,l_progress,'p_adjustment_status',p_adjustment_status);
4606: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4607: END IF;
4608: l_progress := '010';

Line 4605: PO_DEBUG.debug_var(l_log_head,l_progress,'p_adjustment_status',p_adjustment_status);

4601: IF g_debug_stmt THEN
4602: PO_DEBUG.debug_begin(l_log_head);
4603: PO_DEBUG.debug_var(l_log_head,l_progress,'p_event_type_code',p_event_type_code);
4604: PO_DEBUG.debug_var(l_log_head,l_progress,'p_main_or_backing_doc',p_main_or_backing_doc);
4605: PO_DEBUG.debug_var(l_log_head,l_progress,'p_adjustment_status',p_adjustment_status);
4606: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4607: END IF;
4608: l_progress := '010';
4609: IF p_event_type_code = 'PO_REOPEN_FINAL_MATCH' AND

Line 4606: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);

4602: PO_DEBUG.debug_begin(l_log_head);
4603: PO_DEBUG.debug_var(l_log_head,l_progress,'p_event_type_code',p_event_type_code);
4604: PO_DEBUG.debug_var(l_log_head,l_progress,'p_main_or_backing_doc',p_main_or_backing_doc);
4605: PO_DEBUG.debug_var(l_log_head,l_progress,'p_adjustment_status',p_adjustment_status);
4606: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4607: END IF;
4608: l_progress := '010';
4609: IF p_event_type_code = 'PO_REOPEN_FINAL_MATCH' AND
4610: p_main_or_backing_doc = 'M' THEN

Line 4731: PO_DEBUG.debug_end(l_log_head);

4727:
4728: l_progress := '030';
4729:
4730: IF g_debug_stmt THEN
4731: PO_DEBUG.debug_end(l_log_head);
4732: PO_DEBUG.debug_var(l_log_head,l_progress,'l_cr_or_dr',l_cr_or_dr);
4733: PO_DEBUG.debug_var(l_log_head,l_progress,'l_multiplying_factor',l_multiplying_factor);
4734: END IF;
4735:

Line 4732: PO_DEBUG.debug_var(l_log_head,l_progress,'l_cr_or_dr',l_cr_or_dr);

4728: l_progress := '030';
4729:
4730: IF g_debug_stmt THEN
4731: PO_DEBUG.debug_end(l_log_head);
4732: PO_DEBUG.debug_var(l_log_head,l_progress,'l_cr_or_dr',l_cr_or_dr);
4733: PO_DEBUG.debug_var(l_log_head,l_progress,'l_multiplying_factor',l_multiplying_factor);
4734: END IF;
4735:
4736: return l_multiplying_factor;

Line 4733: PO_DEBUG.debug_var(l_log_head,l_progress,'l_multiplying_factor',l_multiplying_factor);

4729:
4730: IF g_debug_stmt THEN
4731: PO_DEBUG.debug_end(l_log_head);
4732: PO_DEBUG.debug_var(l_log_head,l_progress,'l_cr_or_dr',l_cr_or_dr);
4733: PO_DEBUG.debug_var(l_log_head,l_progress,'l_multiplying_factor',l_multiplying_factor);
4734: END IF;
4735:
4736: return l_multiplying_factor;
4737:

Line 4788: PO_DEBUG.debug_begin(l_log_head);

4784: l_progress VARCHAR2(3) := '000';
4785: BEGIN
4786:
4787: IF g_debug_stmt THEN
4788: PO_DEBUG.debug_begin(l_log_head);
4789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4790: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
4791: END IF;
4792:

Line 4789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);

4785: BEGIN
4786:
4787: IF g_debug_stmt THEN
4788: PO_DEBUG.debug_begin(l_log_head);
4789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4790: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
4791: END IF;
4792:
4793: get_doc_detail_from_dist_type(p_distribution_type => p_distribution_type,

Line 4790: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);

4786:
4787: IF g_debug_stmt THEN
4788: PO_DEBUG.debug_begin(l_log_head);
4789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4790: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
4791: END IF;
4792:
4793: get_doc_detail_from_dist_type(p_distribution_type => p_distribution_type,
4794: x_doc_type => l_doc_type,

Line 4797: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type);

4793: get_doc_detail_from_dist_type(p_distribution_type => p_distribution_type,
4794: x_doc_type => l_doc_type,
4795: x_doc_subtype => l_doc_subtype);
4796: IF g_debug_stmt THEN
4797: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type);
4798: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);
4799: END IF;
4800:
4801: get_event_and_entity_codes(p_doc_type => l_doc_type,

Line 4798: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);

4794: x_doc_type => l_doc_type,
4795: x_doc_subtype => l_doc_subtype);
4796: IF g_debug_stmt THEN
4797: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type);
4798: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);
4799: END IF;
4800:
4801: get_event_and_entity_codes(p_doc_type => l_doc_type,
4802: p_doc_subtype => l_doc_subtype,

Line 4808: PO_DEBUG.debug_end(l_log_head);

4804: x_event_type_code => l_event_type_code,
4805: x_entity_type_code => l_entity_type_code);
4806:
4807: IF g_debug_stmt THEN
4808: PO_DEBUG.debug_end(l_log_head);
4809: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_type_code',l_event_type_code);
4810: PO_DEBUG.debug_var(l_log_head,l_progress,'l_entity_type_code',l_entity_type_code);
4811: END IF;
4812:

Line 4809: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_type_code',l_event_type_code);

4805: x_entity_type_code => l_entity_type_code);
4806:
4807: IF g_debug_stmt THEN
4808: PO_DEBUG.debug_end(l_log_head);
4809: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_type_code',l_event_type_code);
4810: PO_DEBUG.debug_var(l_log_head,l_progress,'l_entity_type_code',l_entity_type_code);
4811: END IF;
4812:
4813: return l_event_type_code;

Line 4810: PO_DEBUG.debug_var(l_log_head,l_progress,'l_entity_type_code',l_entity_type_code);

4806:
4807: IF g_debug_stmt THEN
4808: PO_DEBUG.debug_end(l_log_head);
4809: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_type_code',l_event_type_code);
4810: PO_DEBUG.debug_var(l_log_head,l_progress,'l_entity_type_code',l_entity_type_code);
4811: END IF;
4812:
4813: return l_event_type_code;
4814: END;

Line 4854: PO_DEBUG.debug_begin(l_log_head);

4850: l_progress VARCHAR2(3) := '000';
4851: BEGIN
4852:
4853: IF g_debug_stmt THEN
4854: PO_DEBUG.debug_begin(l_log_head);
4855: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4856: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
4857: END IF;
4858:

Line 4855: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);

4851: BEGIN
4852:
4853: IF g_debug_stmt THEN
4854: PO_DEBUG.debug_begin(l_log_head);
4855: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4856: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
4857: END IF;
4858:
4859: get_doc_detail_from_dist_type(p_distribution_type => p_distribution_type,

Line 4856: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);

4852:
4853: IF g_debug_stmt THEN
4854: PO_DEBUG.debug_begin(l_log_head);
4855: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4856: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
4857: END IF;
4858:
4859: get_doc_detail_from_dist_type(p_distribution_type => p_distribution_type,
4860: x_doc_type => l_doc_type,

Line 4863: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type);

4859: get_doc_detail_from_dist_type(p_distribution_type => p_distribution_type,
4860: x_doc_type => l_doc_type,
4861: x_doc_subtype => l_doc_subtype);
4862: IF g_debug_stmt THEN
4863: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type);
4864: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);
4865: END IF;
4866:
4867:

Line 4864: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);

4860: x_doc_type => l_doc_type,
4861: x_doc_subtype => l_doc_subtype);
4862: IF g_debug_stmt THEN
4863: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type);
4864: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);
4865: END IF;
4866:
4867:
4868: get_event_and_entity_codes(p_doc_type => l_doc_type,

Line 4874: PO_DEBUG.debug_end(l_log_head);

4870: p_action => p_action,
4871: x_event_type_code => l_event_type_code,
4872: x_entity_type_code => l_entity_type_code);
4873: IF g_debug_stmt THEN
4874: PO_DEBUG.debug_end(l_log_head);
4875: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_type_code',l_event_type_code);
4876: PO_DEBUG.debug_var(l_log_head,l_progress,'l_entity_type_code',l_entity_type_code);
4877: END IF;
4878:

Line 4875: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_type_code',l_event_type_code);

4871: x_event_type_code => l_event_type_code,
4872: x_entity_type_code => l_entity_type_code);
4873: IF g_debug_stmt THEN
4874: PO_DEBUG.debug_end(l_log_head);
4875: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_type_code',l_event_type_code);
4876: PO_DEBUG.debug_var(l_log_head,l_progress,'l_entity_type_code',l_entity_type_code);
4877: END IF;
4878:
4879: return l_entity_type_code;

Line 4876: PO_DEBUG.debug_var(l_log_head,l_progress,'l_entity_type_code',l_entity_type_code);

4872: x_entity_type_code => l_entity_type_code);
4873: IF g_debug_stmt THEN
4874: PO_DEBUG.debug_end(l_log_head);
4875: PO_DEBUG.debug_var(l_log_head,l_progress,'l_event_type_code',l_event_type_code);
4876: PO_DEBUG.debug_var(l_log_head,l_progress,'l_entity_type_code',l_entity_type_code);
4877: END IF;
4878:
4879: return l_entity_type_code;
4880: END;

Line 4918: PO_DEBUG.debug_begin(l_log_head);

4914: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
4915: l_progress VARCHAR2(3) := '000';
4916: BEGIN
4917: IF g_debug_stmt THEN
4918: PO_DEBUG.debug_begin(l_log_head);
4919: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4920: END IF;
4921:
4922: CASE p_distribution_type

Line 4919: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);

4915: l_progress VARCHAR2(3) := '000';
4916: BEGIN
4917: IF g_debug_stmt THEN
4918: PO_DEBUG.debug_begin(l_log_head);
4919: PO_DEBUG.debug_var(l_log_head,l_progress,'p_distribution_type',p_distribution_type);
4920: END IF;
4921:
4922: CASE p_distribution_type
4923: WHEN g_dist_type_AGREEMENT THEN

Line 4946: PO_DEBUG.debug_end(l_log_head);

4942: x_doc_type := l_doc_type;
4943: x_doc_subtype := l_doc_subtype;
4944:
4945: IF g_debug_stmt THEN
4946: PO_DEBUG.debug_end(l_log_head);
4947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type);
4948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);
4949: END IF;
4950:

Line 4947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type);

4943: x_doc_subtype := l_doc_subtype;
4944:
4945: IF g_debug_stmt THEN
4946: PO_DEBUG.debug_end(l_log_head);
4947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type);
4948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);
4949: END IF;
4950:
4951: END;

Line 4948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);

4944:
4945: IF g_debug_stmt THEN
4946: PO_DEBUG.debug_end(l_log_head);
4947: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type);
4948: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_subtype',l_doc_subtype);
4949: END IF;
4950:
4951: END;
4952:

Line 5003: PO_DEBUG.debug_begin(l_log_head);

4999: l_progress VARCHAR2(3) := '000';
5000: BEGIN
5001:
5002: IF g_debug_stmt THEN
5003: PO_DEBUG.debug_begin(l_log_head);
5004: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
5005: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
5006: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
5007: END IF;

Line 5004: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);

5000: BEGIN
5001:
5002: IF g_debug_stmt THEN
5003: PO_DEBUG.debug_begin(l_log_head);
5004: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
5005: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
5006: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
5007: END IF;
5008:

Line 5005: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);

5001:
5002: IF g_debug_stmt THEN
5003: PO_DEBUG.debug_begin(l_log_head);
5004: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
5005: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
5006: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
5007: END IF;
5008:
5009: l_error_flag := 'N' ;

Line 5006: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);

5002: IF g_debug_stmt THEN
5003: PO_DEBUG.debug_begin(l_log_head);
5004: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type',p_doc_type);
5005: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_subtype',p_doc_subtype);
5006: PO_DEBUG.debug_var(l_log_head,l_progress,'p_action',p_action);
5007: END IF;
5008:
5009: l_error_flag := 'N' ;
5010: IF (p_doc_type = 'REQUISITION') THEN

Line 5066: PO_DEBUG.debug_end(l_log_head);

5062: x_entity_type_code := NULL ;
5063: END IF;
5064:
5065: IF g_debug_stmt THEN
5066: PO_DEBUG.debug_end(l_log_head);
5067: PO_DEBUG.debug_var(l_log_head,l_progress,'x_event_type_code',x_event_type_code);
5068: PO_DEBUG.debug_var(l_log_head,l_progress,'x_entity_type_code',x_entity_type_code);
5069: END IF;
5070:

Line 5067: PO_DEBUG.debug_var(l_log_head,l_progress,'x_event_type_code',x_event_type_code);

5063: END IF;
5064:
5065: IF g_debug_stmt THEN
5066: PO_DEBUG.debug_end(l_log_head);
5067: PO_DEBUG.debug_var(l_log_head,l_progress,'x_event_type_code',x_event_type_code);
5068: PO_DEBUG.debug_var(l_log_head,l_progress,'x_entity_type_code',x_entity_type_code);
5069: END IF;
5070:
5071: END get_event_and_entity_codes;

Line 5068: PO_DEBUG.debug_var(l_log_head,l_progress,'x_entity_type_code',x_entity_type_code);

5064:
5065: IF g_debug_stmt THEN
5066: PO_DEBUG.debug_end(l_log_head);
5067: PO_DEBUG.debug_var(l_log_head,l_progress,'x_event_type_code',x_event_type_code);
5068: PO_DEBUG.debug_var(l_log_head,l_progress,'x_entity_type_code',x_entity_type_code);
5069: END IF;
5070:
5071: END get_event_and_entity_codes;
5072: