APPS.PO_AP_PURGE_UTIL_PVT dependencies on FND_LOG

Line 166: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

162: ) IS
163:
164: l_api_name CONSTANT VARCHAR2(50) := 'seed_po';
165: l_progress VARCHAR2(3);
166: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
167: G_MODULE_PREFIX || l_api_name || '.';
168:
169: BEGIN
170:

Line 174: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

170:
171: l_progress := '000';
172:
173: IF (g_fnd_debug = 'Y') THEN
174: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
175: FND_LOG.string
176: ( log_level => FND_LOG.LEVEL_PROCEDURE,
177: module => l_module || l_progress,
178: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 175: FND_LOG.string

171: l_progress := '000';
172:
173: IF (g_fnd_debug = 'Y') THEN
174: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
175: FND_LOG.string
176: ( log_level => FND_LOG.LEVEL_PROCEDURE,
177: module => l_module || l_progress,
178: message => 'Entering ' || g_pkg_name || '.' || l_api_name
179: );

Line 176: ( log_level => FND_LOG.LEVEL_PROCEDURE,

172:
173: IF (g_fnd_debug = 'Y') THEN
174: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
175: FND_LOG.string
176: ( log_level => FND_LOG.LEVEL_PROCEDURE,
177: module => l_module || l_progress,
178: message => 'Entering ' || g_pkg_name || '.' || l_api_name
179: );
180: END IF;

Line 263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

259: WHERE RT.po_header_id = PH.po_header_id
260: AND RT.last_update_date > p_last_activity_date);
261:
262: IF (g_fnd_debug = 'Y') THEN
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
264: FND_LOG.string
265: ( log_level => FND_LOG.LEVEL_STATEMENT,
266: module => l_module || l_progress,
267: message => 'Done Seeded PO for ' || p_purge_category

Line 264: FND_LOG.string

260: AND RT.last_update_date > p_last_activity_date);
261:
262: IF (g_fnd_debug = 'Y') THEN
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
264: FND_LOG.string
265: ( log_level => FND_LOG.LEVEL_STATEMENT,
266: module => l_module || l_progress,
267: message => 'Done Seeded PO for ' || p_purge_category
268: );

Line 265: ( log_level => FND_LOG.LEVEL_STATEMENT,

261:
262: IF (g_fnd_debug = 'Y') THEN
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
264: FND_LOG.string
265: ( log_level => FND_LOG.LEVEL_STATEMENT,
266: module => l_module || l_progress,
267: message => 'Done Seeded PO for ' || p_purge_category
268: );
269: END IF;

Line 344: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

340: WHERE RT.po_header_id = PH.po_header_id
341: AND RT.last_update_date > p_last_activity_date);
342:
343: IF (g_fnd_debug = 'Y') THEN
344: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
345: FND_LOG.string
346: ( log_level => FND_LOG.LEVEL_STATEMENT,
347: module => l_module || l_progress,
348: message => 'Done seed po for ' || p_purge_category

Line 345: FND_LOG.string

341: AND RT.last_update_date > p_last_activity_date);
342:
343: IF (g_fnd_debug = 'Y') THEN
344: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
345: FND_LOG.string
346: ( log_level => FND_LOG.LEVEL_STATEMENT,
347: module => l_module || l_progress,
348: message => 'Done seed po for ' || p_purge_category
349: );

Line 346: ( log_level => FND_LOG.LEVEL_STATEMENT,

342:
343: IF (g_fnd_debug = 'Y') THEN
344: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
345: FND_LOG.string
346: ( log_level => FND_LOG.LEVEL_STATEMENT,
347: module => l_module || l_progress,
348: message => 'Done seed po for ' || p_purge_category
349: );
350: END IF;

Line 408: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

404:
405: l_progress := '040';
406:
407: IF (g_fnd_debug = 'Y') THEN
408: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
409: FND_LOG.string
410: ( log_level => FND_LOG.LEVEL_PROCEDURE,
411: module => l_module || l_progress,
412: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 409: FND_LOG.string

405: l_progress := '040';
406:
407: IF (g_fnd_debug = 'Y') THEN
408: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
409: FND_LOG.string
410: ( log_level => FND_LOG.LEVEL_PROCEDURE,
411: module => l_module || l_progress,
412: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
413: );

Line 410: ( log_level => FND_LOG.LEVEL_PROCEDURE,

406:
407: IF (g_fnd_debug = 'Y') THEN
408: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
409: FND_LOG.string
410: ( log_level => FND_LOG.LEVEL_PROCEDURE,
411: module => l_module || l_progress,
412: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
413: );
414: END IF;

Line 458: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

454:
455: l_api_name VARCHAR2(50) := 'filter_more_referenced_po';
456: l_progress VARCHAR2(3);
457: l_return_status VARCHAR2(1);
458: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
459: G_MODULE_PREFIX || l_api_name || '.';
460:
461: BEGIN
462:

Line 466: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

462:
463: l_progress := '000';
464:
465: IF (g_fnd_debug = 'Y') THEN
466: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
467: FND_LOG.string
468: ( log_level => FND_LOG.LEVEL_PROCEDURE,
469: module => l_module || l_progress,
470: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 467: FND_LOG.string

463: l_progress := '000';
464:
465: IF (g_fnd_debug = 'Y') THEN
466: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
467: FND_LOG.string
468: ( log_level => FND_LOG.LEVEL_PROCEDURE,
469: module => l_module || l_progress,
470: message => 'Entering ' || g_pkg_name || '.' || l_api_name
471: );

Line 468: ( log_level => FND_LOG.LEVEL_PROCEDURE,

464:
465: IF (g_fnd_debug = 'Y') THEN
466: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
467: FND_LOG.string
468: ( log_level => FND_LOG.LEVEL_PROCEDURE,
469: module => l_module || l_progress,
470: message => 'Entering ' || g_pkg_name || '.' || l_api_name
471: );
472: END IF;

Line 488: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:
487: IF (g_fnd_debug = 'Y') THEN
488: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
489: FND_LOG.string
490: ( log_level => FND_LOG.LEVEL_PROCEDURE,
491: module => l_module || l_progress,
492: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 489: FND_LOG.string

485: END IF;
486:
487: IF (g_fnd_debug = 'Y') THEN
488: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
489: FND_LOG.string
490: ( log_level => FND_LOG.LEVEL_PROCEDURE,
491: module => l_module || l_progress,
492: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
493: );

Line 490: ( log_level => FND_LOG.LEVEL_PROCEDURE,

486:
487: IF (g_fnd_debug = 'Y') THEN
488: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
489: FND_LOG.string
490: ( log_level => FND_LOG.LEVEL_PROCEDURE,
491: module => l_module || l_progress,
492: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
493: );
494: END IF;

Line 536: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

532:
533: l_api_name VARCHAR2(50) := 'filter_more_referenced_po';
534: l_progress VARCHAR2(3);
535: l_return_status VARCHAR2(1);
536: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
537: G_MODULE_PREFIX || l_api_name || '.';
538:
539: BEGIN
540:

Line 544: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

540:
541: l_progress := '000';
542:
543: IF (g_fnd_debug = 'Y') THEN
544: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
545: FND_LOG.string
546: ( log_level => FND_LOG.LEVEL_PROCEDURE,
547: module => l_module || l_progress,
548: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 545: FND_LOG.string

541: l_progress := '000';
542:
543: IF (g_fnd_debug = 'Y') THEN
544: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
545: FND_LOG.string
546: ( log_level => FND_LOG.LEVEL_PROCEDURE,
547: module => l_module || l_progress,
548: message => 'Entering ' || g_pkg_name || '.' || l_api_name
549: );

Line 546: ( log_level => FND_LOG.LEVEL_PROCEDURE,

542:
543: IF (g_fnd_debug = 'Y') THEN
544: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
545: FND_LOG.string
546: ( log_level => FND_LOG.LEVEL_PROCEDURE,
547: module => l_module || l_progress,
548: message => 'Entering ' || g_pkg_name || '.' || l_api_name
549: );
550: END IF;

Line 607: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606: IF (g_fnd_debug = 'Y') THEN
607: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
608: FND_LOG.string
609: ( log_level => FND_LOG.LEVEL_PROCEDURE,
610: module => l_module || l_progress,
611: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 608: FND_LOG.string

604: END IF;
605:
606: IF (g_fnd_debug = 'Y') THEN
607: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
608: FND_LOG.string
609: ( log_level => FND_LOG.LEVEL_PROCEDURE,
610: module => l_module || l_progress,
611: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
612: );

Line 609: ( log_level => FND_LOG.LEVEL_PROCEDURE,

605:
606: IF (g_fnd_debug = 'Y') THEN
607: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
608: FND_LOG.string
609: ( log_level => FND_LOG.LEVEL_PROCEDURE,
610: module => l_module || l_progress,
611: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
612: );
613: END IF;

Line 661: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

657:
658: l_api_name VARCHAR2(50) := 'delete_req_related_records';
659: l_progress VARCHAR2(3);
660: l_return_status VARCHAR2(1);
661: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
662: G_MODULE_PREFIX || l_api_name || '.';
663:
664: BEGIN
665:

Line 669: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

665:
666: l_progress := '000';
667:
668: IF (g_fnd_debug = 'Y') THEN
669: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
670: FND_LOG.string
671: ( log_level => FND_LOG.LEVEL_PROCEDURE,
672: module => l_module || l_progress,
673: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 670: FND_LOG.string

666: l_progress := '000';
667:
668: IF (g_fnd_debug = 'Y') THEN
669: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
670: FND_LOG.string
671: ( log_level => FND_LOG.LEVEL_PROCEDURE,
672: module => l_module || l_progress,
673: message => 'Entering ' || g_pkg_name || '.' || l_api_name
674: );

Line 671: ( log_level => FND_LOG.LEVEL_PROCEDURE,

667:
668: IF (g_fnd_debug = 'Y') THEN
669: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
670: FND_LOG.string
671: ( log_level => FND_LOG.LEVEL_PROCEDURE,
672: module => l_module || l_progress,
673: message => 'Entering ' || g_pkg_name || '.' || l_api_name
674: );
675: END IF;

Line 733: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:
732: IF (g_fnd_debug = 'Y') THEN
733: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
734: FND_LOG.string
735: ( log_level => FND_LOG.LEVEL_PROCEDURE,
736: module => l_module || l_progress,
737: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 734: FND_LOG.string

730: END IF;
731:
732: IF (g_fnd_debug = 'Y') THEN
733: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
734: FND_LOG.string
735: ( log_level => FND_LOG.LEVEL_PROCEDURE,
736: module => l_module || l_progress,
737: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
738: );

Line 735: ( log_level => FND_LOG.LEVEL_PROCEDURE,

731:
732: IF (g_fnd_debug = 'Y') THEN
733: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
734: FND_LOG.string
735: ( log_level => FND_LOG.LEVEL_PROCEDURE,
736: module => l_module || l_progress,
737: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
738: );
739: END IF;

Line 787: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

783:
784: l_api_name VARCHAR2(50) := 'delete_po_related_records';
785: l_progress VARCHAR2(3);
786: l_return_status VARCHAR2(1);
787: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
788: G_MODULE_PREFIX || l_api_name || '.';
789:
790: BEGIN
791:

Line 795: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

791:
792: l_progress := '000';
793:
794: IF (g_fnd_debug = 'Y') THEN
795: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
796: FND_LOG.string
797: ( log_level => FND_LOG.LEVEL_PROCEDURE,
798: module => l_module || l_progress,
799: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 796: FND_LOG.string

792: l_progress := '000';
793:
794: IF (g_fnd_debug = 'Y') THEN
795: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
796: FND_LOG.string
797: ( log_level => FND_LOG.LEVEL_PROCEDURE,
798: module => l_module || l_progress,
799: message => 'Entering ' || g_pkg_name || '.' || l_api_name
800: );

Line 797: ( log_level => FND_LOG.LEVEL_PROCEDURE,

793:
794: IF (g_fnd_debug = 'Y') THEN
795: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
796: FND_LOG.string
797: ( log_level => FND_LOG.LEVEL_PROCEDURE,
798: module => l_module || l_progress,
799: message => 'Entering ' || g_pkg_name || '.' || l_api_name
800: );
801: END IF;

Line 940: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
937: END IF;
938:
939: IF (g_fnd_debug = 'Y') THEN
940: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
941: FND_LOG.string
942: ( log_level => FND_LOG.LEVEL_PROCEDURE,
943: module => l_module || l_progress,
944: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 941: FND_LOG.string

937: END IF;
938:
939: IF (g_fnd_debug = 'Y') THEN
940: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
941: FND_LOG.string
942: ( log_level => FND_LOG.LEVEL_PROCEDURE,
943: module => l_module || l_progress,
944: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
945: );

Line 942: ( log_level => FND_LOG.LEVEL_PROCEDURE,

938:
939: IF (g_fnd_debug = 'Y') THEN
940: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
941: FND_LOG.string
942: ( log_level => FND_LOG.LEVEL_PROCEDURE,
943: module => l_module || l_progress,
944: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
945: );
946: END IF;

Line 993: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

989: ) IS
990:
991: l_api_name VARCHAR2(50) := 'filter_req_pon_validation';
992: l_progress VARCHAR2(3);
993: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
994: G_MODULE_PREFIX || l_api_name || '.';
995:
996: l_in_rec PON_PO_INTEGRATION_GRP.PURGE_IN_RECTYPE;
997: l_out_rec PON_PO_INTEGRATION_GRP.PURGE_OUT_RECTYPE;

Line 1013: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1009:
1010: l_progress := '000';
1011:
1012: IF (g_fnd_debug = 'Y') THEN
1013: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1014: FND_LOG.string
1015: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1016: module => l_module || l_progress,
1017: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1014: FND_LOG.string

1010: l_progress := '000';
1011:
1012: IF (g_fnd_debug = 'Y') THEN
1013: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1014: FND_LOG.string
1015: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1016: module => l_module || l_progress,
1017: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1018: );

Line 1015: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1011:
1012: IF (g_fnd_debug = 'Y') THEN
1013: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1014: FND_LOG.string
1015: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1016: module => l_module || l_progress,
1017: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1018: );
1019: END IF;

Line 1051: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1047: x_out_rec => l_out_rec
1048: );
1049:
1050: IF (g_fnd_debug = 'Y') THEN
1051: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1052: FND_LOG.string
1053: ( log_level => FND_LOG.LEVEL_STATEMENT,
1054: module => l_module || l_progress,
1055: message => 'After calling pon val api. rtn status = ' ||

Line 1052: FND_LOG.string

1048: );
1049:
1050: IF (g_fnd_debug = 'Y') THEN
1051: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1052: FND_LOG.string
1053: ( log_level => FND_LOG.LEVEL_STATEMENT,
1054: module => l_module || l_progress,
1055: message => 'After calling pon val api. rtn status = ' ||
1056: l_return_status

Line 1053: ( log_level => FND_LOG.LEVEL_STATEMENT,

1049:
1050: IF (g_fnd_debug = 'Y') THEN
1051: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1052: FND_LOG.string
1053: ( log_level => FND_LOG.LEVEL_STATEMENT,
1054: module => l_module || l_progress,
1055: message => 'After calling pon val api. rtn status = ' ||
1056: l_return_status
1057: );

Line 1085: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1081: p_entity => 'REQ'
1082: );
1083:
1084: IF (g_fnd_debug = 'Y') THEN
1085: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1086: FND_LOG.string
1087: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1088: module => l_module || l_progress,
1089: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 1086: FND_LOG.string

1082: );
1083:
1084: IF (g_fnd_debug = 'Y') THEN
1085: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1086: FND_LOG.string
1087: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1088: module => l_module || l_progress,
1089: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1090: );

Line 1087: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1083:
1084: IF (g_fnd_debug = 'Y') THEN
1085: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1086: FND_LOG.string
1087: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1088: module => l_module || l_progress,
1089: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1090: );
1091: END IF;

Line 1136: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1132: ) IS
1133:
1134: l_api_name VARCHAR2(50) := 'filter_po_fte_validation';
1135: l_progress VARCHAR2(3);
1136: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1137: G_MODULE_PREFIX || l_api_name || '.';
1138:
1139: CURSOR c_po_list IS
1140: SELECT po_header_id

Line 1154: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1150: BEGIN
1151: l_progress := '000';
1152:
1153: IF (g_fnd_debug = 'Y') THEN
1154: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1155: FND_LOG.string
1156: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1157: module => l_module || l_progress,
1158: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1155: FND_LOG.string

1151: l_progress := '000';
1152:
1153: IF (g_fnd_debug = 'Y') THEN
1154: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1155: FND_LOG.string
1156: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1157: module => l_module || l_progress,
1158: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1159: );

Line 1156: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1152:
1153: IF (g_fnd_debug = 'Y') THEN
1154: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1155: FND_LOG.string
1156: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1157: module => l_module || l_progress,
1158: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1159: );
1160: END IF;

Line 1173: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1169: OR
1170: WSH_CODE_CONTROL.Get_Code_Release_Level < '110510') THEN
1171:
1172: IF (g_fnd_debug = 'Y') THEN
1173: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1174: FND_LOG.string
1175: ( log_level => FND_LOG.LEVEL_STATEMENT,
1176: module => l_module || l_progress,
1177: message => 'Either FTE is not installed or WSH code level ' ||

Line 1174: FND_LOG.string

1170: WSH_CODE_CONTROL.Get_Code_Release_Level < '110510') THEN
1171:
1172: IF (g_fnd_debug = 'Y') THEN
1173: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1174: FND_LOG.string
1175: ( log_level => FND_LOG.LEVEL_STATEMENT,
1176: module => l_module || l_progress,
1177: message => 'Either FTE is not installed or WSH code level ' ||
1178: 'is not at 11.5.10 level or above. Quitting'

Line 1175: ( log_level => FND_LOG.LEVEL_STATEMENT,

1171:
1172: IF (g_fnd_debug = 'Y') THEN
1173: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1174: FND_LOG.string
1175: ( log_level => FND_LOG.LEVEL_STATEMENT,
1176: module => l_module || l_progress,
1177: message => 'Either FTE is not installed or WSH code level ' ||
1178: 'is not at 11.5.10 level or above. Quitting'
1179: );

Line 1213: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1209: x_out_rec => l_out_rec
1210: );
1211:
1212: IF (g_fnd_debug = 'Y') THEN
1213: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1214: FND_LOG.string
1215: ( log_level => FND_LOG.LEVEL_STATEMENT,
1216: module => l_module || l_progress,
1217: message => 'After calling FTE Validation API. rtn status= ' ||

Line 1214: FND_LOG.string

1210: );
1211:
1212: IF (g_fnd_debug = 'Y') THEN
1213: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1214: FND_LOG.string
1215: ( log_level => FND_LOG.LEVEL_STATEMENT,
1216: module => l_module || l_progress,
1217: message => 'After calling FTE Validation API. rtn status= ' ||
1218: l_return_status

Line 1215: ( log_level => FND_LOG.LEVEL_STATEMENT,

1211:
1212: IF (g_fnd_debug = 'Y') THEN
1213: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1214: FND_LOG.string
1215: ( log_level => FND_LOG.LEVEL_STATEMENT,
1216: module => l_module || l_progress,
1217: message => 'After calling FTE Validation API. rtn status= ' ||
1218: l_return_status
1219: );

Line 1247: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1243: p_entity => 'PO'
1244: );
1245:
1246: IF (g_fnd_debug = 'Y') THEN
1247: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1248: FND_LOG.string
1249: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1250: module => l_module || l_progress,
1251: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 1248: FND_LOG.string

1244: );
1245:
1246: IF (g_fnd_debug = 'Y') THEN
1247: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1248: FND_LOG.string
1249: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1250: module => l_module || l_progress,
1251: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1252: );

Line 1249: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1245:
1246: IF (g_fnd_debug = 'Y') THEN
1247: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1248: FND_LOG.string
1249: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1250: module => l_module || l_progress,
1251: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1252: );
1253: END IF;

Line 1299: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1295: ) IS
1296:
1297: l_api_name VARCHAR2(50) := 'filter_po_cst_validation';
1298: l_progress VARCHAR2(3);
1299: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1300: G_MODULE_PREFIX || l_api_name || '.';
1301:
1302: CURSOR c_po_list IS
1303: SELECT po_header_id

Line 1320: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1316:
1317: l_progress := '000';
1318:
1319: IF (g_fnd_debug = 'Y') THEN
1320: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1321: FND_LOG.string
1322: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1323: module => l_module || l_progress,
1324: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1321: FND_LOG.string

1317: l_progress := '000';
1318:
1319: IF (g_fnd_debug = 'Y') THEN
1320: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1321: FND_LOG.string
1322: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1323: module => l_module || l_progress,
1324: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1325: );

Line 1322: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1318:
1319: IF (g_fnd_debug = 'Y') THEN
1320: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1321: FND_LOG.string
1322: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1323: module => l_module || l_progress,
1324: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1325: );
1326: END IF;

Line 1357: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1353: x_purge_out_rec => l_out_rec
1354: );
1355:
1356: IF (g_fnd_debug = 'Y') THEN
1357: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1358: FND_LOG.string
1359: ( log_level => FND_LOG.LEVEL_STATEMENT,
1360: module => l_module || l_progress,
1361: message => 'After calling CST Val API. rtn status = ' ||

Line 1358: FND_LOG.string

1354: );
1355:
1356: IF (g_fnd_debug = 'Y') THEN
1357: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1358: FND_LOG.string
1359: ( log_level => FND_LOG.LEVEL_STATEMENT,
1360: module => l_module || l_progress,
1361: message => 'After calling CST Val API. rtn status = ' ||
1362: l_return_status

Line 1359: ( log_level => FND_LOG.LEVEL_STATEMENT,

1355:
1356: IF (g_fnd_debug = 'Y') THEN
1357: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1358: FND_LOG.string
1359: ( log_level => FND_LOG.LEVEL_STATEMENT,
1360: module => l_module || l_progress,
1361: message => 'After calling CST Val API. rtn status = ' ||
1362: l_return_status
1363: );

Line 1391: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1387: p_entity => 'PO'
1388: );
1389:
1390: IF (g_fnd_debug = 'Y') THEN
1391: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1392: FND_LOG.string
1393: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1394: module => l_module || l_progress,
1395: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 1392: FND_LOG.string

1388: );
1389:
1390: IF (g_fnd_debug = 'Y') THEN
1391: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1392: FND_LOG.string
1393: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1394: module => l_module || l_progress,
1395: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1396: );

Line 1393: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1389:
1390: IF (g_fnd_debug = 'Y') THEN
1391: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1392: FND_LOG.string
1393: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1394: module => l_module || l_progress,
1395: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1396: );
1397: END IF;

Line 1444: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1440: ) IS
1441:
1442: l_api_name VARCHAR2(50) := 'filter_po_oe_validation';
1443: l_progress VARCHAR2(3);
1444: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1445: G_MODULE_PREFIX || l_api_name || '.';
1446:
1447: l_hdr_id_tbl OE_DROP_SHIP_GRP.PO_ENTITY_ID_TBL_TYPE;
1448: l_purge_allowed_tbl OE_DROP_SHIP_GRP.VAL_STATUS_TBL_TYPE;

Line 1464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1460:
1461: l_progress := '000';
1462:
1463: IF (g_fnd_debug = 'Y') THEN
1464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1465: FND_LOG.string
1466: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1467: module => l_module || l_progress,
1468: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1465: FND_LOG.string

1461: l_progress := '000';
1462:
1463: IF (g_fnd_debug = 'Y') THEN
1464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1465: FND_LOG.string
1466: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1467: module => l_module || l_progress,
1468: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1469: );

Line 1466: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1462:
1463: IF (g_fnd_debug = 'Y') THEN
1464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1465: FND_LOG.string
1466: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1467: module => l_module || l_progress,
1468: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1469: );
1470: END IF;

Line 1482: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1478: PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J
1479: OR OE_CODE_CONTROL.code_release_level < '110510') THEN
1480:
1481: IF (g_fnd_debug = 'Y') THEN
1482: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1483: FND_LOG.string
1484: ( log_level => FND_LOG.LEVEL_STATEMENT,
1485: module => l_module || l_progress,
1486: message => 'Either PO is not at FPJ or above or OM code ' ||

Line 1483: FND_LOG.string

1479: OR OE_CODE_CONTROL.code_release_level < '110510') THEN
1480:
1481: IF (g_fnd_debug = 'Y') THEN
1482: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1483: FND_LOG.string
1484: ( log_level => FND_LOG.LEVEL_STATEMENT,
1485: module => l_module || l_progress,
1486: message => 'Either PO is not at FPJ or above or OM code ' ||
1487: 'level is not at 11.5.10 level or above. Quitting'

Line 1484: ( log_level => FND_LOG.LEVEL_STATEMENT,

1480:
1481: IF (g_fnd_debug = 'Y') THEN
1482: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1483: FND_LOG.string
1484: ( log_level => FND_LOG.LEVEL_STATEMENT,
1485: module => l_module || l_progress,
1486: message => 'Either PO is not at FPJ or above or OM code ' ||
1487: 'level is not at 11.5.10 level or above. Quitting'
1488: );

Line 1524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1520: x_purge_allowed_tbl => l_purge_allowed_tbl
1521: );
1522:
1523: IF (g_fnd_debug = 'Y') THEN
1524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1525: FND_LOG.string
1526: ( log_level => FND_LOG.LEVEL_STATEMENT,
1527: module => l_module || l_progress,
1528: message => 'After calling OE Val API. rtn status = ' ||

Line 1525: FND_LOG.string

1521: );
1522:
1523: IF (g_fnd_debug = 'Y') THEN
1524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1525: FND_LOG.string
1526: ( log_level => FND_LOG.LEVEL_STATEMENT,
1527: module => l_module || l_progress,
1528: message => 'After calling OE Val API. rtn status = ' ||
1529: l_return_status

Line 1526: ( log_level => FND_LOG.LEVEL_STATEMENT,

1522:
1523: IF (g_fnd_debug = 'Y') THEN
1524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1525: FND_LOG.string
1526: ( log_level => FND_LOG.LEVEL_STATEMENT,
1527: module => l_module || l_progress,
1528: message => 'After calling OE Val API. rtn status = ' ||
1529: l_return_status
1530: );

Line 1562: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1558: p_entity => 'PO'
1559: );
1560:
1561: IF (g_fnd_debug = 'Y') THEN
1562: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1563: FND_LOG.string
1564: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1565: module => l_module || l_progress,
1566: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 1563: FND_LOG.string

1559: );
1560:
1561: IF (g_fnd_debug = 'Y') THEN
1562: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1563: FND_LOG.string
1564: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1565: module => l_module || l_progress,
1566: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1567: );

Line 1564: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1560:
1561: IF (g_fnd_debug = 'Y') THEN
1562: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1563: FND_LOG.string
1564: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1565: module => l_module || l_progress,
1566: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1567: );
1568: END IF;

Line 1615: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1611: ) IS
1612:
1613: l_api_name VARCHAR2(50) := 'filter_po_pon_validation';
1614: l_progress VARCHAR2(3);
1615: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1616: G_MODULE_PREFIX || l_api_name || '.';
1617:
1618: l_in_rec PON_PO_INTEGRATION_GRP.PURGE_IN_RECTYPE;
1619: l_out_rec PON_PO_INTEGRATION_GRP.PURGE_OUT_RECTYPE;

Line 1635: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1631:
1632: l_progress := '000';
1633:
1634: IF (g_fnd_debug = 'Y') THEN
1635: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1636: FND_LOG.string
1637: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1638: module => l_module || l_progress,
1639: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1636: FND_LOG.string

1632: l_progress := '000';
1633:
1634: IF (g_fnd_debug = 'Y') THEN
1635: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1636: FND_LOG.string
1637: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1638: module => l_module || l_progress,
1639: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1640: );

Line 1637: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1633:
1634: IF (g_fnd_debug = 'Y') THEN
1635: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1636: FND_LOG.string
1637: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1638: module => l_module || l_progress,
1639: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1640: );
1641: END IF;

Line 1673: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1669: x_out_rec => l_out_rec
1670: );
1671:
1672: IF (g_fnd_debug = 'Y') THEN
1673: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1674: FND_LOG.string
1675: ( log_level => FND_LOG.LEVEL_STATEMENT,
1676: module => l_module || l_progress,
1677: message => 'After calling pon val api. rtn status = ' ||

Line 1674: FND_LOG.string

1670: );
1671:
1672: IF (g_fnd_debug = 'Y') THEN
1673: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1674: FND_LOG.string
1675: ( log_level => FND_LOG.LEVEL_STATEMENT,
1676: module => l_module || l_progress,
1677: message => 'After calling pon val api. rtn status = ' ||
1678: l_return_status

Line 1675: ( log_level => FND_LOG.LEVEL_STATEMENT,

1671:
1672: IF (g_fnd_debug = 'Y') THEN
1673: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1674: FND_LOG.string
1675: ( log_level => FND_LOG.LEVEL_STATEMENT,
1676: module => l_module || l_progress,
1677: message => 'After calling pon val api. rtn status = ' ||
1678: l_return_status
1679: );

Line 1707: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1703: p_entity => 'PO'
1704: );
1705:
1706: IF (g_fnd_debug = 'Y') THEN
1707: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1708: FND_LOG.string
1709: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1710: module => l_module || l_progress,
1711: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 1708: FND_LOG.string

1704: );
1705:
1706: IF (g_fnd_debug = 'Y') THEN
1707: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1708: FND_LOG.string
1709: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1710: module => l_module || l_progress,
1711: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1712: );

Line 1709: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1705:
1706: IF (g_fnd_debug = 'Y') THEN
1707: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1708: FND_LOG.string
1709: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1710: module => l_module || l_progress,
1711: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1712: );
1713: END IF;

Line 1759: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1755: ) IS
1756:
1757: l_api_name VARCHAR2(50) := 'filter_po_hr_validation';
1758: l_progress VARCHAR2(3);
1759: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1760: G_MODULE_PREFIX || l_api_name || '.';
1761:
1762: l_in_tbl HR_PO_INFO.g_table_numbers_t;
1763: l_out_tbl HR_PO_INFO.g_table_numbers_t;

Line 1775: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1771:
1772: l_progress := '000';
1773:
1774: IF (g_fnd_debug = 'Y') THEN
1775: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1776: FND_LOG.string
1777: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1778: module => l_module || l_progress,
1779: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1776: FND_LOG.string

1772: l_progress := '000';
1773:
1774: IF (g_fnd_debug = 'Y') THEN
1775: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1776: FND_LOG.string
1777: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1778: module => l_module || l_progress,
1779: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1780: );

Line 1777: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1773:
1774: IF (g_fnd_debug = 'Y') THEN
1775: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1776: FND_LOG.string
1777: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1778: module => l_module || l_progress,
1779: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1780: );
1781: END IF;

Line 1805: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1801: p_po_out_tbl => l_out_tbl
1802: );
1803:
1804: IF (g_fnd_debug = 'Y') THEN
1805: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1806: FND_LOG.string
1807: ( log_level => FND_LOG.LEVEL_STATEMENT,
1808: module => l_module || l_progress,
1809: message => 'After calling hr val api.'

Line 1806: FND_LOG.string

1802: );
1803:
1804: IF (g_fnd_debug = 'Y') THEN
1805: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1806: FND_LOG.string
1807: ( log_level => FND_LOG.LEVEL_STATEMENT,
1808: module => l_module || l_progress,
1809: message => 'After calling hr val api.'
1810: );

Line 1807: ( log_level => FND_LOG.LEVEL_STATEMENT,

1803:
1804: IF (g_fnd_debug = 'Y') THEN
1805: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1806: FND_LOG.string
1807: ( log_level => FND_LOG.LEVEL_STATEMENT,
1808: module => l_module || l_progress,
1809: message => 'After calling hr val api.'
1810: );
1811: END IF;

Line 1833: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1829: p_entity => 'PO'
1830: );
1831:
1832: IF (g_fnd_debug = 'Y') THEN
1833: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1834: FND_LOG.string
1835: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1836: module => l_module || l_progress,
1837: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 1834: FND_LOG.string

1830: );
1831:
1832: IF (g_fnd_debug = 'Y') THEN
1833: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1834: FND_LOG.string
1835: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1836: module => l_module || l_progress,
1837: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1838: );

Line 1835: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1831:
1832: IF (g_fnd_debug = 'Y') THEN
1833: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1834: FND_LOG.string
1835: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1836: module => l_module || l_progress,
1837: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1838: );
1839: END IF;

Line 1891: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1887: ) IS
1888:
1889: l_api_name VARCHAR2(50) := 'delete_asl_ref';
1890: l_progress VARCHAR2(3);
1891: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1892: G_MODULE_PREFIX || l_api_name || '.';
1893:
1894: BEGIN
1895:

Line 1899: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1895:
1896: l_progress := '000';
1897:
1898: IF (g_fnd_debug = 'Y') THEN
1899: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1900: FND_LOG.string
1901: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1902: module => l_module || l_progress,
1903: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1900: FND_LOG.string

1896: l_progress := '000';
1897:
1898: IF (g_fnd_debug = 'Y') THEN
1899: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1900: FND_LOG.string
1901: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1902: module => l_module || l_progress,
1903: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1904: );

Line 1901: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1897:
1898: IF (g_fnd_debug = 'Y') THEN
1899: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1900: FND_LOG.string
1901: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1902: module => l_module || l_progress,
1903: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1904: );
1905: END IF;

Line 1927: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1923: AND PPL.po_header_id BETWEEN p_range_low
1924: AND p_range_high);
1925:
1926: IF (g_fnd_debug = 'Y') THEN
1927: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1928: FND_LOG.string
1929: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1930: module => l_module || l_progress,
1931: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 1928: FND_LOG.string

1924: AND p_range_high);
1925:
1926: IF (g_fnd_debug = 'Y') THEN
1927: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1928: FND_LOG.string
1929: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1930: module => l_module || l_progress,
1931: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1932: );

Line 1929: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1925:
1926: IF (g_fnd_debug = 'Y') THEN
1927: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1928: FND_LOG.string
1929: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1930: module => l_module || l_progress,
1931: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1932: );
1933: END IF;

Line 1980: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1976: ) IS
1977:
1978: l_api_name VARCHAR2(50) := 'delete_org_assignments';
1979: l_progress VARCHAR2(3);
1980: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1981: G_MODULE_PREFIX || l_api_name || '.';
1982:
1983: BEGIN
1984:

Line 1988: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1984:
1985: l_progress := '000';
1986:
1987: IF (g_fnd_debug = 'Y') THEN
1988: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1989: FND_LOG.string
1990: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1991: module => l_module || l_progress,
1992: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1989: FND_LOG.string

1985: l_progress := '000';
1986:
1987: IF (g_fnd_debug = 'Y') THEN
1988: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1989: FND_LOG.string
1990: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1991: module => l_module || l_progress,
1992: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1993: );

Line 1990: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1986:
1987: IF (g_fnd_debug = 'Y') THEN
1988: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1989: FND_LOG.string
1990: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1991: module => l_module || l_progress,
1992: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1993: );
1994: END IF;

Line 2009: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2005: AND PPL.po_header_id BETWEEN p_range_low
2006: AND p_range_high);
2007:
2008: IF (g_fnd_debug = 'Y') THEN
2009: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2010: FND_LOG.string
2011: ( log_level => FND_LOG.LEVEL_STATEMENT,
2012: module => l_module || l_progress,
2013: message => 'Deleted PGOA rowcount = ' || SQL%ROWCOUNT

Line 2010: FND_LOG.string

2006: AND p_range_high);
2007:
2008: IF (g_fnd_debug = 'Y') THEN
2009: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2010: FND_LOG.string
2011: ( log_level => FND_LOG.LEVEL_STATEMENT,
2012: module => l_module || l_progress,
2013: message => 'Deleted PGOA rowcount = ' || SQL%ROWCOUNT
2014: );

Line 2011: ( log_level => FND_LOG.LEVEL_STATEMENT,

2007:
2008: IF (g_fnd_debug = 'Y') THEN
2009: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2010: FND_LOG.string
2011: ( log_level => FND_LOG.LEVEL_STATEMENT,
2012: module => l_module || l_progress,
2013: message => 'Deleted PGOA rowcount = ' || SQL%ROWCOUNT
2014: );
2015: END IF;

Line 2030: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2026: AND PPL.po_header_id BETWEEN p_range_low
2027: AND p_range_high);
2028:
2029: IF (g_fnd_debug = 'Y') THEN
2030: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2031: FND_LOG.string
2032: ( log_level => FND_LOG.LEVEL_STATEMENT,
2033: module => l_module || l_progress,
2034: message => 'Deleted PGOAA rowcount = ' || SQL%ROWCOUNT

Line 2031: FND_LOG.string

2027: AND p_range_high);
2028:
2029: IF (g_fnd_debug = 'Y') THEN
2030: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2031: FND_LOG.string
2032: ( log_level => FND_LOG.LEVEL_STATEMENT,
2033: module => l_module || l_progress,
2034: message => 'Deleted PGOAA rowcount = ' || SQL%ROWCOUNT
2035: );

Line 2032: ( log_level => FND_LOG.LEVEL_STATEMENT,

2028:
2029: IF (g_fnd_debug = 'Y') THEN
2030: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2031: FND_LOG.string
2032: ( log_level => FND_LOG.LEVEL_STATEMENT,
2033: module => l_module || l_progress,
2034: message => 'Deleted PGOAA rowcount = ' || SQL%ROWCOUNT
2035: );
2036: END IF;

Line 2040: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2036: END IF;
2037: END IF;
2038:
2039: IF (g_fnd_debug = 'Y') THEN
2040: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2041: FND_LOG.string
2042: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2043: module => l_module || l_progress,
2044: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2041: FND_LOG.string

2037: END IF;
2038:
2039: IF (g_fnd_debug = 'Y') THEN
2040: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2041: FND_LOG.string
2042: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2043: module => l_module || l_progress,
2044: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2045: );

Line 2042: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2038:
2039: IF (g_fnd_debug = 'Y') THEN
2040: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2041: FND_LOG.string
2042: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2043: module => l_module || l_progress,
2044: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2045: );
2046: END IF;

Line 2094: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2090:
2091: l_api_name VARCHAR2(50) := 'delete_drop_ship_po_links';
2092: l_progress VARCHAR2(3);
2093: l_return_status VARCHAR2(1);
2094: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2095: G_MODULE_PREFIX || l_api_name || '.';
2096:
2097: l_po_hdr_tbl OE_DROP_SHIP_GRP.PO_ENTITY_ID_TBL_TYPE;
2098:

Line 2106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2102: BEGIN
2103: l_progress := '000';
2104:
2105: IF (g_fnd_debug = 'Y') THEN
2106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2107: FND_LOG.string
2108: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2109: module => l_module || l_progress,
2110: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 2107: FND_LOG.string

2103: l_progress := '000';
2104:
2105: IF (g_fnd_debug = 'Y') THEN
2106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2107: FND_LOG.string
2108: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2109: module => l_module || l_progress,
2110: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2111: );

Line 2108: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2104:
2105: IF (g_fnd_debug = 'Y') THEN
2106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2107: FND_LOG.string
2108: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2109: module => l_module || l_progress,
2110: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2111: );
2112: END IF;

Line 2147: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2143: p_entity_id_tbl => l_po_hdr_tbl
2144: );
2145:
2146: IF (g_fnd_debug = 'Y') THEN
2147: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2148: FND_LOG.string
2149: ( log_level => FND_LOG.LEVEL_STATEMENT,
2150: module => l_module || l_progress,
2151: message => 'After calling OE purge API. rtn status = ' ||

Line 2148: FND_LOG.string

2144: );
2145:
2146: IF (g_fnd_debug = 'Y') THEN
2147: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2148: FND_LOG.string
2149: ( log_level => FND_LOG.LEVEL_STATEMENT,
2150: module => l_module || l_progress,
2151: message => 'After calling OE purge API. rtn status = ' ||
2152: l_return_status

Line 2149: ( log_level => FND_LOG.LEVEL_STATEMENT,

2145:
2146: IF (g_fnd_debug = 'Y') THEN
2147: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2148: FND_LOG.string
2149: ( log_level => FND_LOG.LEVEL_STATEMENT,
2150: module => l_module || l_progress,
2151: message => 'After calling OE purge API. rtn status = ' ||
2152: l_return_status
2153: );

Line 2164: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2160:
2161: END IF; -- IF PO Level > FPJ and OM level > 110510
2162:
2163: IF (g_fnd_debug = 'Y') THEN
2164: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2165: FND_LOG.string
2166: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2167: module => l_module || l_progress,
2168: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2165: FND_LOG.string

2161: END IF; -- IF PO Level > FPJ and OM level > 110510
2162:
2163: IF (g_fnd_debug = 'Y') THEN
2164: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2165: FND_LOG.string
2166: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2167: module => l_module || l_progress,
2168: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2169: );

Line 2166: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2162:
2163: IF (g_fnd_debug = 'Y') THEN
2164: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2165: FND_LOG.string
2166: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2167: module => l_module || l_progress,
2168: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2169: );
2170: END IF;

Line 2217: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2213:
2214: l_api_name VARCHAR2(50) := 'delete_fte';
2215: l_progress VARCHAR2(3);
2216: l_return_status VARCHAR2(1);
2217: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2218: G_MODULE_PREFIX || l_api_name || '.';
2219:
2220: l_fte_in_rec WSH_PO_INTG_TYPES_GRP.purge_in_rectype;
2221: l_msg_count NUMBER;

Line 2228: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2224: BEGIN
2225: l_progress := '000';
2226:
2227: IF (g_fnd_debug = 'Y') THEN
2228: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2229: FND_LOG.string
2230: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2231: module => l_module || l_progress,
2232: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 2229: FND_LOG.string

2225: l_progress := '000';
2226:
2227: IF (g_fnd_debug = 'Y') THEN
2228: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2229: FND_LOG.string
2230: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2231: module => l_module || l_progress,
2232: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2233: );

Line 2230: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2226:
2227: IF (g_fnd_debug = 'Y') THEN
2228: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2229: FND_LOG.string
2230: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2231: module => l_module || l_progress,
2232: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2233: );
2234: END IF;

Line 2244: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2240: OR
2241: WSH_CODE_CONTROL.Get_Code_Release_Level < '110510') THEN
2242:
2243: IF (g_fnd_debug = 'Y') THEN
2244: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2245: FND_LOG.string
2246: ( log_level => FND_LOG.LEVEL_STATEMENT,
2247: module => l_module || l_progress,
2248: message => 'Either FTE is not installed or WSH code level '||

Line 2245: FND_LOG.string

2241: WSH_CODE_CONTROL.Get_Code_Release_Level < '110510') THEN
2242:
2243: IF (g_fnd_debug = 'Y') THEN
2244: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2245: FND_LOG.string
2246: ( log_level => FND_LOG.LEVEL_STATEMENT,
2247: module => l_module || l_progress,
2248: message => 'Either FTE is not installed or WSH code level '||
2249: 'is not at 11.5.10 level. Quitting'

Line 2246: ( log_level => FND_LOG.LEVEL_STATEMENT,

2242:
2243: IF (g_fnd_debug = 'Y') THEN
2244: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2245: FND_LOG.string
2246: ( log_level => FND_LOG.LEVEL_STATEMENT,
2247: module => l_module || l_progress,
2248: message => 'Either FTE is not installed or WSH code level '||
2249: 'is not at 11.5.10 level. Quitting'
2250: );

Line 2279: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2275: p_in_rec => l_fte_in_rec
2276: );
2277:
2278: IF (g_fnd_debug = 'Y') THEN
2279: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2280: FND_LOG.string
2281: ( log_level => FND_LOG.LEVEL_STATEMENT,
2282: module => l_module || l_progress,
2283: message => 'After calling FTE Purge API. rtn status = ' ||

Line 2280: FND_LOG.string

2276: );
2277:
2278: IF (g_fnd_debug = 'Y') THEN
2279: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2280: FND_LOG.string
2281: ( log_level => FND_LOG.LEVEL_STATEMENT,
2282: module => l_module || l_progress,
2283: message => 'After calling FTE Purge API. rtn status = ' ||
2284: l_return_status

Line 2281: ( log_level => FND_LOG.LEVEL_STATEMENT,

2277:
2278: IF (g_fnd_debug = 'Y') THEN
2279: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2280: FND_LOG.string
2281: ( log_level => FND_LOG.LEVEL_STATEMENT,
2282: module => l_module || l_progress,
2283: message => 'After calling FTE Purge API. rtn status = ' ||
2284: l_return_status
2285: );

Line 2294: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2291: END IF;
2292:
2293: IF (g_fnd_debug = 'Y') THEN
2294: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2295: FND_LOG.string
2296: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2297: module => l_module || l_progress,
2298: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2295: FND_LOG.string

2291: END IF;
2292:
2293: IF (g_fnd_debug = 'Y') THEN
2294: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2295: FND_LOG.string
2296: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2297: module => l_module || l_progress,
2298: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2299: );

Line 2296: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2292:
2293: IF (g_fnd_debug = 'Y') THEN
2294: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2295: FND_LOG.string
2296: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2297: module => l_module || l_progress,
2298: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2299: );
2300: END IF;

Line 2351: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2347:
2348: l_api_name VARCHAR2(50) := 'delete_pon';
2349: l_progress VARCHAR2(3);
2350: l_return_status VARCHAR2(1);
2351: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2352: G_MODULE_PREFIX || l_api_name || '.';
2353:
2354: l_in_rec PON_PO_INTEGRATION_GRP.purge_in_rectype;
2355: l_msg_count NUMBER;

Line 2362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2358: BEGIN
2359: l_progress := '000';
2360:
2361: IF (g_fnd_debug = 'Y') THEN
2362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2363: FND_LOG.string
2364: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2365: module => l_module || l_progress,
2366: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 2363: FND_LOG.string

2359: l_progress := '000';
2360:
2361: IF (g_fnd_debug = 'Y') THEN
2362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2363: FND_LOG.string
2364: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2365: module => l_module || l_progress,
2366: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2367: );

Line 2364: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2360:
2361: IF (g_fnd_debug = 'Y') THEN
2362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2363: FND_LOG.string
2364: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2365: module => l_module || l_progress,
2366: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2367: );
2368: END IF;

Line 2409: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2405: p_in_rec => l_in_rec
2406: );
2407:
2408: IF (g_fnd_debug = 'Y') THEN
2409: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2410: FND_LOG.string
2411: ( log_level => FND_LOG.LEVEL_STATEMENT,
2412: module => l_module || l_progress,
2413: message => 'After calling PON Purge API. rtn status = ' ||

Line 2410: FND_LOG.string

2406: );
2407:
2408: IF (g_fnd_debug = 'Y') THEN
2409: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2410: FND_LOG.string
2411: ( log_level => FND_LOG.LEVEL_STATEMENT,
2412: module => l_module || l_progress,
2413: message => 'After calling PON Purge API. rtn status = ' ||
2414: l_return_status

Line 2411: ( log_level => FND_LOG.LEVEL_STATEMENT,

2407:
2408: IF (g_fnd_debug = 'Y') THEN
2409: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2410: FND_LOG.string
2411: ( log_level => FND_LOG.LEVEL_STATEMENT,
2412: module => l_module || l_progress,
2413: message => 'After calling PON Purge API. rtn status = ' ||
2414: l_return_status
2415: );

Line 2424: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2421: END IF;
2422:
2423: IF (g_fnd_debug = 'Y') THEN
2424: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2425: FND_LOG.string
2426: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2427: module => l_module || l_progress,
2428: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2425: FND_LOG.string

2421: END IF;
2422:
2423: IF (g_fnd_debug = 'Y') THEN
2424: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2425: FND_LOG.string
2426: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2427: module => l_module || l_progress,
2428: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2429: );

Line 2426: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2422:
2423: IF (g_fnd_debug = 'Y') THEN
2424: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2425: FND_LOG.string
2426: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2427: module => l_module || l_progress,
2428: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2429: );
2430: END IF;

Line 2479: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2475:
2476: l_api_name VARCHAR2(50) := 'delete_contract_terms';
2477: l_progress VARCHAR2(3);
2478: l_return_status VARCHAR2(1);
2479: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2480: G_MODULE_PREFIX || l_api_name || '.';
2481:
2482: l_header_tbl OKC_TERMS_UTIL_GRP.doc_tbl_type;
2483: l_msg_count NUMBER;

Line 2515: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2511: BEGIN
2512: l_progress := '000';
2513:
2514: IF (g_fnd_debug = 'Y') THEN
2515: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2516: FND_LOG.string
2517: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2518: module => l_module || l_progress,
2519: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 2516: FND_LOG.string

2512: l_progress := '000';
2513:
2514: IF (g_fnd_debug = 'Y') THEN
2515: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2516: FND_LOG.string
2517: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2518: module => l_module || l_progress,
2519: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2520: );

Line 2517: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2513:
2514: IF (g_fnd_debug = 'Y') THEN
2515: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2516: FND_LOG.string
2517: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2518: module => l_module || l_progress,
2519: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2520: );
2521: END IF;

Line 2528: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2524: x_return_status := FND_API.G_RET_STS_SUCCESS;
2525:
2526: IF (PO_CONTERMS_UTL_GRP.is_contracts_enabled = 'N') THEN
2527: IF (g_fnd_debug = 'Y') THEN
2528: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2529: FND_LOG.string
2530: ( log_level => FND_LOG.LEVEL_STATEMENT,
2531: module => l_module || l_progress,
2532: message => 'Procurement Contract is not available. Exit ' ||

Line 2529: FND_LOG.string

2525:
2526: IF (PO_CONTERMS_UTL_GRP.is_contracts_enabled = 'N') THEN
2527: IF (g_fnd_debug = 'Y') THEN
2528: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2529: FND_LOG.string
2530: ( log_level => FND_LOG.LEVEL_STATEMENT,
2531: module => l_module || l_progress,
2532: message => 'Procurement Contract is not available. Exit ' ||
2533: 'delete_contract_terms'

Line 2530: ( log_level => FND_LOG.LEVEL_STATEMENT,

2526: IF (PO_CONTERMS_UTL_GRP.is_contracts_enabled = 'N') THEN
2527: IF (g_fnd_debug = 'Y') THEN
2528: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2529: FND_LOG.string
2530: ( log_level => FND_LOG.LEVEL_STATEMENT,
2531: module => l_module || l_progress,
2532: message => 'Procurement Contract is not available. Exit ' ||
2533: 'delete_contract_terms'
2534: );

Line 2566: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2562: p_doc_tbl => l_header_tbl
2563: );
2564:
2565: IF (g_fnd_debug = 'Y') THEN
2566: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2567: FND_LOG.string
2568: ( log_level => FND_LOG.LEVEL_STATEMENT,
2569: module => l_module || l_progress,
2570: message => 'After calling okc purge API. rtn status = ' ||

Line 2567: FND_LOG.string

2563: );
2564:
2565: IF (g_fnd_debug = 'Y') THEN
2566: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2567: FND_LOG.string
2568: ( log_level => FND_LOG.LEVEL_STATEMENT,
2569: module => l_module || l_progress,
2570: message => 'After calling okc purge API. rtn status = ' ||
2571: l_return_status

Line 2568: ( log_level => FND_LOG.LEVEL_STATEMENT,

2564:
2565: IF (g_fnd_debug = 'Y') THEN
2566: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2567: FND_LOG.string
2568: ( log_level => FND_LOG.LEVEL_STATEMENT,
2569: module => l_module || l_progress,
2570: message => 'After calling okc purge API. rtn status = ' ||
2571: l_return_status
2572: );

Line 2581: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2578: END IF;
2579:
2580: IF (g_fnd_debug = 'Y') THEN
2581: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2582: FND_LOG.string
2583: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2584: module => l_module || l_progress,
2585: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2582: FND_LOG.string

2578: END IF;
2579:
2580: IF (g_fnd_debug = 'Y') THEN
2581: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2582: FND_LOG.string
2583: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2584: module => l_module || l_progress,
2585: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2586: );

Line 2583: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2579:
2580: IF (g_fnd_debug = 'Y') THEN
2581: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2582: FND_LOG.string
2583: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2584: module => l_module || l_progress,
2585: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2586: );
2587: END IF;

Line 2639: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2635:
2636: l_api_name VARCHAR2(50) := 'delete_price_differentials';
2637: l_progress VARCHAR2(3);
2638: l_return_status VARCHAR2(1);
2639: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2640: G_MODULE_PREFIX || l_api_name || '.';
2641:
2642: BEGIN
2643:

Line 2647: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2643:
2644: l_progress := '000';
2645:
2646: IF (g_fnd_debug = 'Y') THEN
2647: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2648: FND_LOG.string
2649: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2650: module => l_module || l_progress,
2651: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 2648: FND_LOG.string

2644: l_progress := '000';
2645:
2646: IF (g_fnd_debug = 'Y') THEN
2647: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2648: FND_LOG.string
2649: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2650: module => l_module || l_progress,
2651: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2652: );

Line 2649: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2645:
2646: IF (g_fnd_debug = 'Y') THEN
2647: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2648: FND_LOG.string
2649: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2650: module => l_module || l_progress,
2651: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2652: );
2653: END IF;

Line 2676: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2672: AND PPRL.requisition_header_id BETWEEN p_range_low
2673: AND p_range_high);
2674:
2675: IF (g_fnd_debug = 'Y') THEN
2676: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2677: FND_LOG.string
2678: ( log_level => FND_LOG.LEVEL_STATEMENT,
2679: module => l_module || l_progress,
2680: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT

Line 2677: FND_LOG.string

2673: AND p_range_high);
2674:
2675: IF (g_fnd_debug = 'Y') THEN
2676: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2677: FND_LOG.string
2678: ( log_level => FND_LOG.LEVEL_STATEMENT,
2679: module => l_module || l_progress,
2680: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT
2681: );

Line 2678: ( log_level => FND_LOG.LEVEL_STATEMENT,

2674:
2675: IF (g_fnd_debug = 'Y') THEN
2676: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2677: FND_LOG.string
2678: ( log_level => FND_LOG.LEVEL_STATEMENT,
2679: module => l_module || l_progress,
2680: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT
2681: );
2682: END IF;

Line 2702: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2698: AND PPL.po_header_id BETWEEN p_range_low
2699: AND p_range_high);
2700:
2701: IF (g_fnd_debug = 'Y') THEN
2702: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2703: FND_LOG.string
2704: ( log_level => FND_LOG.LEVEL_STATEMENT,
2705: module => l_module || l_progress,
2706: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT

Line 2703: FND_LOG.string

2699: AND p_range_high);
2700:
2701: IF (g_fnd_debug = 'Y') THEN
2702: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2703: FND_LOG.string
2704: ( log_level => FND_LOG.LEVEL_STATEMENT,
2705: module => l_module || l_progress,
2706: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT
2707: );

Line 2704: ( log_level => FND_LOG.LEVEL_STATEMENT,

2700:
2701: IF (g_fnd_debug = 'Y') THEN
2702: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2703: FND_LOG.string
2704: ( log_level => FND_LOG.LEVEL_STATEMENT,
2705: module => l_module || l_progress,
2706: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT
2707: );
2708: END IF;

Line 2727: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2723: AND PPL.po_header_id BETWEEN p_range_low
2724: AND p_range_high);
2725:
2726: IF (g_fnd_debug = 'Y') THEN
2727: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2728: FND_LOG.string
2729: ( log_level => FND_LOG.LEVEL_STATEMENT,
2730: module => l_module || l_progress,
2731: message => 'Deleted PPDA rowcount = ' || SQL%ROWCOUNT

Line 2728: FND_LOG.string

2724: AND p_range_high);
2725:
2726: IF (g_fnd_debug = 'Y') THEN
2727: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2728: FND_LOG.string
2729: ( log_level => FND_LOG.LEVEL_STATEMENT,
2730: module => l_module || l_progress,
2731: message => 'Deleted PPDA rowcount = ' || SQL%ROWCOUNT
2732: );

Line 2729: ( log_level => FND_LOG.LEVEL_STATEMENT,

2725:
2726: IF (g_fnd_debug = 'Y') THEN
2727: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2728: FND_LOG.string
2729: ( log_level => FND_LOG.LEVEL_STATEMENT,
2730: module => l_module || l_progress,
2731: message => 'Deleted PPDA rowcount = ' || SQL%ROWCOUNT
2732: );
2733: END IF;

Line 2752: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2748: AND PPL.po_header_id BETWEEN p_range_low
2749: AND p_range_high);
2750:
2751: IF (g_fnd_debug = 'Y') THEN
2752: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2753: FND_LOG.string
2754: ( log_level => FND_LOG.LEVEL_STATEMENT,
2755: module => l_module || l_progress,
2756: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT

Line 2753: FND_LOG.string

2749: AND p_range_high);
2750:
2751: IF (g_fnd_debug = 'Y') THEN
2752: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2753: FND_LOG.string
2754: ( log_level => FND_LOG.LEVEL_STATEMENT,
2755: module => l_module || l_progress,
2756: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT
2757: );

Line 2754: ( log_level => FND_LOG.LEVEL_STATEMENT,

2750:
2751: IF (g_fnd_debug = 'Y') THEN
2752: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2753: FND_LOG.string
2754: ( log_level => FND_LOG.LEVEL_STATEMENT,
2755: module => l_module || l_progress,
2756: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT
2757: );
2758: END IF;

Line 2777: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2773: AND PPL.po_header_id BETWEEN p_range_low
2774: AND p_range_high);
2775:
2776: IF (g_fnd_debug = 'Y') THEN
2777: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2778: FND_LOG.string
2779: ( log_level => FND_LOG.LEVEL_STATEMENT,
2780: module => l_module || l_progress,
2781: message => 'Deleted PPDA rowcount = ' || SQL%ROWCOUNT

Line 2778: FND_LOG.string

2774: AND p_range_high);
2775:
2776: IF (g_fnd_debug = 'Y') THEN
2777: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2778: FND_LOG.string
2779: ( log_level => FND_LOG.LEVEL_STATEMENT,
2780: module => l_module || l_progress,
2781: message => 'Deleted PPDA rowcount = ' || SQL%ROWCOUNT
2782: );

Line 2779: ( log_level => FND_LOG.LEVEL_STATEMENT,

2775:
2776: IF (g_fnd_debug = 'Y') THEN
2777: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2778: FND_LOG.string
2779: ( log_level => FND_LOG.LEVEL_STATEMENT,
2780: module => l_module || l_progress,
2781: message => 'Deleted PPDA rowcount = ' || SQL%ROWCOUNT
2782: );
2783: END IF;

Line 2789: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2785:
2786: END IF; -- p_purge_category = 'REQ'
2787:
2788: IF (g_fnd_debug = 'Y') THEN
2789: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2790: FND_LOG.string
2791: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2792: module => l_module || l_progress,
2793: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2790: FND_LOG.string

2786: END IF; -- p_purge_category = 'REQ'
2787:
2788: IF (g_fnd_debug = 'Y') THEN
2789: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2790: FND_LOG.string
2791: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2792: module => l_module || l_progress,
2793: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2794: );

Line 2791: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2787:
2788: IF (g_fnd_debug = 'Y') THEN
2789: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2790: FND_LOG.string
2791: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2792: module => l_module || l_progress,
2793: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2794: );
2795: END IF;

Line 2844: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2840:
2841: l_api_name VARCHAR2(50) := 'delete_attr_values';
2842: l_progress VARCHAR2(3);
2843: l_return_status VARCHAR2(1);
2844: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2845: G_MODULE_PREFIX || l_api_name || '.';
2846:
2847: BEGIN
2848:

Line 2852: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2848:
2849: l_progress := '000';
2850:
2851: IF (g_fnd_debug = 'Y') THEN
2852: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2853: FND_LOG.string
2854: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2855: module => l_module || l_progress,
2856: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 2853: FND_LOG.string

2849: l_progress := '000';
2850:
2851: IF (g_fnd_debug = 'Y') THEN
2852: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2853: FND_LOG.string
2854: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2855: module => l_module || l_progress,
2856: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2857: );

Line 2854: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2850:
2851: IF (g_fnd_debug = 'Y') THEN
2852: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2853: FND_LOG.string
2854: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2855: module => l_module || l_progress,
2856: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2857: );
2858: END IF;

Line 2879: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2875: AND PPL.po_header_id BETWEEN p_range_low
2876: AND p_range_high);
2877:
2878: IF (g_fnd_debug = 'Y') THEN
2879: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2880: FND_LOG.string
2881: ( log_level => FND_LOG.LEVEL_STATEMENT,
2882: module => l_module || l_progress,
2883: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT

Line 2880: FND_LOG.string

2876: AND p_range_high);
2877:
2878: IF (g_fnd_debug = 'Y') THEN
2879: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2880: FND_LOG.string
2881: ( log_level => FND_LOG.LEVEL_STATEMENT,
2882: module => l_module || l_progress,
2883: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT
2884: );

Line 2881: ( log_level => FND_LOG.LEVEL_STATEMENT,

2877:
2878: IF (g_fnd_debug = 'Y') THEN
2879: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2880: FND_LOG.string
2881: ( log_level => FND_LOG.LEVEL_STATEMENT,
2882: module => l_module || l_progress,
2883: message => 'Deleted PPD rowcount = ' || SQL%ROWCOUNT
2884: );
2885: END IF;

Line 2902: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2898: AND PPL.po_header_id BETWEEN p_range_low
2899: AND p_range_high);
2900:
2901: IF (g_fnd_debug = 'Y') THEN
2902: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2903: FND_LOG.string
2904: ( log_level => FND_LOG.LEVEL_STATEMENT,
2905: module => l_module || l_progress,
2906: message => 'Deleted PAV rowcount = ' || SQL%ROWCOUNT

Line 2903: FND_LOG.string

2899: AND p_range_high);
2900:
2901: IF (g_fnd_debug = 'Y') THEN
2902: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2903: FND_LOG.string
2904: ( log_level => FND_LOG.LEVEL_STATEMENT,
2905: module => l_module || l_progress,
2906: message => 'Deleted PAV rowcount = ' || SQL%ROWCOUNT
2907: );

Line 2904: ( log_level => FND_LOG.LEVEL_STATEMENT,

2900:
2901: IF (g_fnd_debug = 'Y') THEN
2902: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2903: FND_LOG.string
2904: ( log_level => FND_LOG.LEVEL_STATEMENT,
2905: module => l_module || l_progress,
2906: message => 'Deleted PAV rowcount = ' || SQL%ROWCOUNT
2907: );
2908: END IF;

Line 2925: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2921: AND PPL.po_header_id BETWEEN p_range_low
2922: AND p_range_high);
2923:
2924: IF (g_fnd_debug = 'Y') THEN
2925: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2926: FND_LOG.string
2927: ( log_level => FND_LOG.LEVEL_STATEMENT,
2928: module => l_module || l_progress,
2929: message => 'Deleted PAVT rowcount = ' || SQL%ROWCOUNT

Line 2926: FND_LOG.string

2922: AND p_range_high);
2923:
2924: IF (g_fnd_debug = 'Y') THEN
2925: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2926: FND_LOG.string
2927: ( log_level => FND_LOG.LEVEL_STATEMENT,
2928: module => l_module || l_progress,
2929: message => 'Deleted PAVT rowcount = ' || SQL%ROWCOUNT
2930: );

Line 2927: ( log_level => FND_LOG.LEVEL_STATEMENT,

2923:
2924: IF (g_fnd_debug = 'Y') THEN
2925: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2926: FND_LOG.string
2927: ( log_level => FND_LOG.LEVEL_STATEMENT,
2928: module => l_module || l_progress,
2929: message => 'Deleted PAVT rowcount = ' || SQL%ROWCOUNT
2930: );
2931: END IF;

Line 2935: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2931: END IF;
2932: END IF;
2933:
2934: IF (g_fnd_debug = 'Y') THEN
2935: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2936: FND_LOG.string
2937: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2938: module => l_module || l_progress,
2939: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2936: FND_LOG.string

2932: END IF;
2933:
2934: IF (g_fnd_debug = 'Y') THEN
2935: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2936: FND_LOG.string
2937: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2938: module => l_module || l_progress,
2939: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2940: );

Line 2937: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2933:
2934: IF (g_fnd_debug = 'Y') THEN
2935: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2936: FND_LOG.string
2937: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2938: module => l_module || l_progress,
2939: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2940: );
2941: END IF;

Line 2989: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2985: ) IS
2986:
2987: l_api_name VARCHAR2(50) := 'delete_req_attachments';
2988: l_progress VARCHAR2(3);
2989: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2990: G_MODULE_PREFIX || l_api_name || '.';
2991:
2992: CURSOR c_req_header IS
2993: SELECT PPRL.requisition_header_id

Line 3011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

3007:
3008: l_progress := '000';
3009:
3010: IF (g_fnd_debug = 'Y') THEN
3011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3012: FND_LOG.string
3013: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3014: module => l_module || l_progress,
3015: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 3012: FND_LOG.string

3008: l_progress := '000';
3009:
3010: IF (g_fnd_debug = 'Y') THEN
3011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3012: FND_LOG.string
3013: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3014: module => l_module || l_progress,
3015: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3016: );

Line 3013: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3009:
3010: IF (g_fnd_debug = 'Y') THEN
3011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3012: FND_LOG.string
3013: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3014: module => l_module || l_progress,
3015: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3016: );
3017: END IF;

Line 3051: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

3047:
3048: END LOOP;
3049:
3050: IF (g_fnd_debug = 'Y') THEN
3051: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3052: FND_LOG.string
3053: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3054: module => l_module || l_progress,
3055: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 3052: FND_LOG.string

3048: END LOOP;
3049:
3050: IF (g_fnd_debug = 'Y') THEN
3051: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3052: FND_LOG.string
3053: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3054: module => l_module || l_progress,
3055: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3056: );

Line 3053: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3049:
3050: IF (g_fnd_debug = 'Y') THEN
3051: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3052: FND_LOG.string
3053: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3054: module => l_module || l_progress,
3055: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3056: );
3057: END IF;

Line 3114: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3110: ) IS
3111:
3112: l_api_name VARCHAR2(50) := 'delete_po_attachments';
3113: l_progress VARCHAR2(3);
3114: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3115: G_MODULE_PREFIX || l_api_name || '.';
3116:
3117: CURSOR c_po_header IS
3118: SELECT PPL.po_header_id

Line 3152: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

3148:
3149: l_progress := '000';
3150:
3151: IF (g_fnd_debug = 'Y') THEN
3152: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3153: FND_LOG.string
3154: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3155: module => l_module || l_progress,
3156: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 3153: FND_LOG.string

3149: l_progress := '000';
3150:
3151: IF (g_fnd_debug = 'Y') THEN
3152: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3153: FND_LOG.string
3154: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3155: module => l_module || l_progress,
3156: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3157: );

Line 3154: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3150:
3151: IF (g_fnd_debug = 'Y') THEN
3152: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3153: FND_LOG.string
3154: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3155: module => l_module || l_progress,
3156: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3157: );
3158: END IF;

Line 3251: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

3247:
3248: END LOOP;
3249:
3250: IF (g_fnd_debug = 'Y') THEN
3251: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3252: FND_LOG.string
3253: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3254: module => l_module || l_progress,
3255: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 3252: FND_LOG.string

3248: END LOOP;
3249:
3250: IF (g_fnd_debug = 'Y') THEN
3251: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3252: FND_LOG.string
3253: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3254: module => l_module || l_progress,
3255: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3256: );

Line 3253: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3249:
3250: IF (g_fnd_debug = 'Y') THEN
3251: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3252: FND_LOG.string
3253: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3254: module => l_module || l_progress,
3255: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3256: );
3257: END IF;

Line 3322: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3318: ) IS
3319:
3320: l_api_name VARCHAR2(50) := 'delete_drafts';
3321: l_progress VARCHAR2(3);
3322: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3323: G_MODULE_PREFIX || l_api_name || '.';
3324:
3325: l_dft_id_tbl PO_TBL_NUMBER;
3326:

Line 3332: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

3328:
3329: l_progress := '000';
3330:
3331: IF (g_fnd_debug = 'Y') THEN
3332: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3333: FND_LOG.string
3334: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3335: module => l_module || l_progress,
3336: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 3333: FND_LOG.string

3329: l_progress := '000';
3330:
3331: IF (g_fnd_debug = 'Y') THEN
3332: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3333: FND_LOG.string
3334: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3335: module => l_module || l_progress,
3336: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3337: );

Line 3334: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3330:
3331: IF (g_fnd_debug = 'Y') THEN
3332: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3333: FND_LOG.string
3334: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3335: module => l_module || l_progress,
3336: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3337: );
3338: END IF;

Line 3362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

3358: );
3359: END LOOP;
3360:
3361: IF (g_fnd_debug = 'Y') THEN
3362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3363: FND_LOG.string
3364: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3365: module => l_module || l_progress,
3366: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 3363: FND_LOG.string

3359: END LOOP;
3360:
3361: IF (g_fnd_debug = 'Y') THEN
3362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3363: FND_LOG.string
3364: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3365: module => l_module || l_progress,
3366: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3367: );

Line 3364: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3360:
3361: IF (g_fnd_debug = 'Y') THEN
3362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3363: FND_LOG.string
3364: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3365: module => l_module || l_progress,
3366: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3367: );
3368: END IF;

Line 3423: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3419: ) IS
3420:
3421: l_api_name VARCHAR2(50) := 'delete_po_approval_list';
3422: l_progress VARCHAR2(3);
3423: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3424: G_MODULE_PREFIX || l_api_name || '.';
3425: BEGIN
3426:
3427: l_progress := '000';

Line 3430: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

3426:
3427: l_progress := '000';
3428:
3429: IF (g_fnd_debug = 'Y') THEN
3430: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3431: FND_LOG.string
3432: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3433: module => l_module || l_progress,
3434: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 3431: FND_LOG.string

3427: l_progress := '000';
3428:
3429: IF (g_fnd_debug = 'Y') THEN
3430: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3431: FND_LOG.string
3432: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3433: module => l_module || l_progress,
3434: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3435: );

Line 3432: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3428:
3429: IF (g_fnd_debug = 'Y') THEN
3430: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3431: FND_LOG.string
3432: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3433: module => l_module || l_progress,
3434: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3435: );
3436: END IF;

Line 3461: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3457: AND PALH.document_type = 'REQUISITION'
3458: );
3459:
3460: IF (g_fnd_debug = 'Y') THEN
3461: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3462: FND_LOG.string
3463: ( log_level => FND_LOG.LEVEL_STATEMENT,
3464: module => l_module || l_progress,
3465: message => 'Deleted po_appr_lines rowcount = ' || SQL%ROWCOUNT

Line 3462: FND_LOG.string

3458: );
3459:
3460: IF (g_fnd_debug = 'Y') THEN
3461: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3462: FND_LOG.string
3463: ( log_level => FND_LOG.LEVEL_STATEMENT,
3464: module => l_module || l_progress,
3465: message => 'Deleted po_appr_lines rowcount = ' || SQL%ROWCOUNT
3466: );

Line 3463: ( log_level => FND_LOG.LEVEL_STATEMENT,

3459:
3460: IF (g_fnd_debug = 'Y') THEN
3461: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3462: FND_LOG.string
3463: ( log_level => FND_LOG.LEVEL_STATEMENT,
3464: module => l_module || l_progress,
3465: message => 'Deleted po_appr_lines rowcount = ' || SQL%ROWCOUNT
3466: );
3467: END IF;

Line 3487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3483: AND p_range_high
3484: );
3485:
3486: IF (g_fnd_debug = 'Y') THEN
3487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3488: FND_LOG.string
3489: ( log_level => FND_LOG.LEVEL_STATEMENT,
3490: module => l_module || l_progress,
3491: message => 'Deleted po_appr_hdrs rowcount = ' || SQL%ROWCOUNT

Line 3488: FND_LOG.string

3484: );
3485:
3486: IF (g_fnd_debug = 'Y') THEN
3487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3488: FND_LOG.string
3489: ( log_level => FND_LOG.LEVEL_STATEMENT,
3490: module => l_module || l_progress,
3491: message => 'Deleted po_appr_hdrs rowcount = ' || SQL%ROWCOUNT
3492: );

Line 3489: ( log_level => FND_LOG.LEVEL_STATEMENT,

3485:
3486: IF (g_fnd_debug = 'Y') THEN
3487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3488: FND_LOG.string
3489: ( log_level => FND_LOG.LEVEL_STATEMENT,
3490: module => l_module || l_progress,
3491: message => 'Deleted po_appr_hdrs rowcount = ' || SQL%ROWCOUNT
3492: );
3493: END IF;

Line 3498: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

3494: END IF;
3495: END IF;
3496:
3497: IF (g_fnd_debug = 'Y') THEN
3498: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3499: FND_LOG.string
3500: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3501: module => l_module || l_progress,
3502: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 3499: FND_LOG.string

3495: END IF;
3496:
3497: IF (g_fnd_debug = 'Y') THEN
3498: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3499: FND_LOG.string
3500: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3501: module => l_module || l_progress,
3502: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3503: );

Line 3500: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3496:
3497: IF (g_fnd_debug = 'Y') THEN
3498: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3499: FND_LOG.string
3500: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3501: module => l_module || l_progress,
3502: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3503: );
3504: END IF;

Line 3526: --Function: Put the record count of the purge table into FND_LOG_MESSAGES,

3522: --Modifies:
3523: -- None
3524: --Locks:
3525: -- None
3526: --Function: Put the record count of the purge table into FND_LOG_MESSAGES,
3527: -- if logging is turned on
3528: --Parameters:
3529: --IN:
3530: --p_module

Line 3569: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3565: FROM po_purge_po_list
3566: WHERE double_check_flag = 'Y';
3567:
3568: END IF;
3569: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3570: FND_LOG.string
3571: ( log_level => FND_LOG.LEVEL_STATEMENT,
3572: module => p_module,
3573: message => p_entity || ' purge list count = ' || l_count

Line 3570: FND_LOG.string

3566: WHERE double_check_flag = 'Y';
3567:
3568: END IF;
3569: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3570: FND_LOG.string
3571: ( log_level => FND_LOG.LEVEL_STATEMENT,
3572: module => p_module,
3573: message => p_entity || ' purge list count = ' || l_count
3574: );

Line 3571: ( log_level => FND_LOG.LEVEL_STATEMENT,

3567:
3568: END IF;
3569: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3570: FND_LOG.string
3571: ( log_level => FND_LOG.LEVEL_STATEMENT,
3572: module => p_module,
3573: message => p_entity || ' purge list count = ' || l_count
3574: );
3575: END IF;