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

APPS.PO_AP_PURGE_PVT dependencies on FND_LOG

Line 119: --Dump All messages to FND_LOG

115: p_po_upper_limit IN NUMBER
116: );
117:
118: --bug3256316
119: --Dump All messages to FND_LOG
120:
121: PROCEDURE dump_msg_to_log
122: ( p_module IN VARCHAR2
123: );

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

175:
176: l_api_name CONSTANT VARCHAR2(50) := 'seed_records';
177: l_api_version CONSTANT NUMBER := 1.0;
178: l_progress VARCHAR2(3);
179: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
180: G_MODULE_PREFIX || l_api_name || '.';
181: l_msg_idx NUMBER;
182:
183: BEGIN

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

184:
185: l_progress := '000';
186:
187: IF (g_fnd_debug = 'Y') THEN
188: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
189: FND_LOG.string
190: ( log_level => FND_LOG.LEVEL_PROCEDURE,
191: module => l_module || l_progress,
192: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 189: FND_LOG.string

185: l_progress := '000';
186:
187: IF (g_fnd_debug = 'Y') THEN
188: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
189: FND_LOG.string
190: ( log_level => FND_LOG.LEVEL_PROCEDURE,
191: module => l_module || l_progress,
192: message => 'Entering ' || g_pkg_name || '.' || l_api_name
193: );

Line 190: ( log_level => FND_LOG.LEVEL_PROCEDURE,

186:
187: IF (g_fnd_debug = 'Y') THEN
188: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
189: FND_LOG.string
190: ( log_level => FND_LOG.LEVEL_PROCEDURE,
191: module => l_module || l_progress,
192: message => 'Entering ' || g_pkg_name || '.' || l_api_name
193: );
194: END IF;

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

266:
267: END IF;
268:
269: IF (g_fnd_debug = 'Y') THEN
270: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
271: FND_LOG.string
272: ( log_level => FND_LOG.LEVEL_PROCEDURE,
273: module => l_module || l_progress,
274: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 271: FND_LOG.string

267: END IF;
268:
269: IF (g_fnd_debug = 'Y') THEN
270: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
271: FND_LOG.string
272: ( log_level => FND_LOG.LEVEL_PROCEDURE,
273: module => l_module || l_progress,
274: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
275: );

Line 272: ( log_level => FND_LOG.LEVEL_PROCEDURE,

268:
269: IF (g_fnd_debug = 'Y') THEN
270: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
271: FND_LOG.string
272: ( log_level => FND_LOG.LEVEL_PROCEDURE,
273: module => l_module || l_progress,
274: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
275: );
276: END IF;

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

360: l_api_name CONSTANT VARCHAR2(50) := 'filter_records';
361: l_api_version CONSTANT NUMBER := 1.0;
362: l_progress VARCHAR2(3);
363: l_return_status VARCHAR2(1);
364: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
365: G_MODULE_PREFIX || l_api_name || '.';
366: l_msg_idx NUMBER;
367:
368: BEGIN

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

369:
370: l_progress := '000';
371:
372: IF (g_fnd_debug = 'Y') THEN
373: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
374: FND_LOG.string
375: ( log_level => FND_LOG.LEVEL_PROCEDURE,
376: module => l_module || l_progress,
377: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 374: FND_LOG.string

370: l_progress := '000';
371:
372: IF (g_fnd_debug = 'Y') THEN
373: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
374: FND_LOG.string
375: ( log_level => FND_LOG.LEVEL_PROCEDURE,
376: module => l_module || l_progress,
377: message => 'Entering ' || g_pkg_name || '.' || l_api_name
378: );

Line 375: ( log_level => FND_LOG.LEVEL_PROCEDURE,

371:
372: IF (g_fnd_debug = 'Y') THEN
373: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
374: FND_LOG.string
375: ( log_level => FND_LOG.LEVEL_PROCEDURE,
376: module => l_module || l_progress,
377: message => 'Entering ' || g_pkg_name || '.' || l_api_name
378: );
379: END IF;

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

514: COMMIT;
515: END IF;
516:
517: IF (g_fnd_debug = 'Y') THEN
518: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
519: FND_LOG.string
520: ( log_level => FND_LOG.LEVEL_PROCEDURE,
521: module => l_module || l_progress,
522: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 519: FND_LOG.string

515: END IF;
516:
517: IF (g_fnd_debug = 'Y') THEN
518: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
519: FND_LOG.string
520: ( log_level => FND_LOG.LEVEL_PROCEDURE,
521: module => l_module || l_progress,
522: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
523: );

Line 520: ( log_level => FND_LOG.LEVEL_PROCEDURE,

516:
517: IF (g_fnd_debug = 'Y') THEN
518: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
519: FND_LOG.string
520: ( log_level => FND_LOG.LEVEL_PROCEDURE,
521: module => l_module || l_progress,
522: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
523: );
524: END IF;

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

592: l_api_name CONSTANT VARCHAR2(50) := 'confirm_records';
593: l_api_version CONSTANT NUMBER := 1.0;
594: l_progress VARCHAR2(3);
595: l_return_status VARCHAR2(1);
596: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
597: G_MODULE_PREFIX || l_api_name || '.';
598: l_msg_idx NUMBER;
599: BEGIN
600:

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

600:
601: l_progress := '000';
602:
603: IF (g_fnd_debug = 'Y') THEN
604: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
605: FND_LOG.string
606: ( log_level => FND_LOG.LEVEL_PROCEDURE,
607: module => l_module || l_progress,
608: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 605: FND_LOG.string

601: l_progress := '000';
602:
603: IF (g_fnd_debug = 'Y') THEN
604: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
605: FND_LOG.string
606: ( log_level => FND_LOG.LEVEL_PROCEDURE,
607: module => l_module || l_progress,
608: message => 'Entering ' || g_pkg_name || '.' || l_api_name
609: );

Line 606: ( log_level => FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 673: FND_LOG.string

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

Line 674: ( log_level => FND_LOG.LEVEL_PROCEDURE,

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

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

748: l_api_name CONSTANT VARCHAR2(50) := 'summarize_records';
749: l_api_version CONSTANT NUMBER := 1.0;
750: l_progress VARCHAR2(3);
751: l_return_status VARCHAR2(1);
752: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
753: G_MODULE_PREFIX || l_api_name || '.';
754:
755: l_req_lower_limit NUMBER;
756: l_req_upper_limit NUMBER;

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

761:
762: l_progress := '000';
763:
764: IF (g_fnd_debug = 'Y') THEN
765: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
766: FND_LOG.string
767: ( log_level => FND_LOG.LEVEL_PROCEDURE,
768: module => l_module || l_progress,
769: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 766: FND_LOG.string

762: l_progress := '000';
763:
764: IF (g_fnd_debug = 'Y') THEN
765: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
766: FND_LOG.string
767: ( log_level => FND_LOG.LEVEL_PROCEDURE,
768: module => l_module || l_progress,
769: message => 'Entering ' || g_pkg_name || '.' || l_api_name
770: );

Line 767: ( log_level => FND_LOG.LEVEL_PROCEDURE,

763:
764: IF (g_fnd_debug = 'Y') THEN
765: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
766: FND_LOG.string
767: ( log_level => FND_LOG.LEVEL_PROCEDURE,
768: module => l_module || l_progress,
769: message => 'Entering ' || g_pkg_name || '.' || l_api_name
770: );
771: END IF;

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

827: p_req_upper_limit => l_req_upper_limit
828: );
829:
830: IF (g_fnd_debug = 'Y') THEN
831: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
832: FND_LOG.string
833: ( log_level => FND_LOG.LEVEL_STATEMENT,
834: module => l_module || l_progress,
835: message => 'After summ_reqs. rtn_status = ' || l_return_status

Line 832: FND_LOG.string

828: );
829:
830: IF (g_fnd_debug = 'Y') THEN
831: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
832: FND_LOG.string
833: ( log_level => FND_LOG.LEVEL_STATEMENT,
834: module => l_module || l_progress,
835: message => 'After summ_reqs. rtn_status = ' || l_return_status
836: );

Line 833: ( log_level => FND_LOG.LEVEL_STATEMENT,

829:
830: IF (g_fnd_debug = 'Y') THEN
831: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
832: FND_LOG.string
833: ( log_level => FND_LOG.LEVEL_STATEMENT,
834: module => l_module || l_progress,
835: message => 'After summ_reqs. rtn_status = ' || l_return_status
836: );
837: END IF;

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

867: p_po_upper_limit => l_po_upper_limit
868: );
869:
870: IF (g_fnd_debug = 'Y') THEN
871: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
872: FND_LOG.string
873: ( log_level => FND_LOG.LEVEL_STATEMENT,
874: module => l_module || l_progress,
875: message => 'After summ_pos. rtn_status = ' || l_return_status

Line 872: FND_LOG.string

868: );
869:
870: IF (g_fnd_debug = 'Y') THEN
871: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
872: FND_LOG.string
873: ( log_level => FND_LOG.LEVEL_STATEMENT,
874: module => l_module || l_progress,
875: message => 'After summ_pos. rtn_status = ' || l_return_status
876: );

Line 873: ( log_level => FND_LOG.LEVEL_STATEMENT,

869:
870: IF (g_fnd_debug = 'Y') THEN
871: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
872: FND_LOG.string
873: ( log_level => FND_LOG.LEVEL_STATEMENT,
874: module => l_module || l_progress,
875: message => 'After summ_pos. rtn_status = ' || l_return_status
876: );
877: END IF;

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

891: p_po_upper_limit => l_po_upper_limit
892: );
893:
894: IF (g_fnd_debug = 'Y') THEN
895: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
896: FND_LOG.string
897: ( log_level => FND_LOG.LEVEL_STATEMENT,
898: module => l_module || l_progress,
899: message => 'After summ_rcv. rtn_status = ' || l_return_status

Line 896: FND_LOG.string

892: );
893:
894: IF (g_fnd_debug = 'Y') THEN
895: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
896: FND_LOG.string
897: ( log_level => FND_LOG.LEVEL_STATEMENT,
898: module => l_module || l_progress,
899: message => 'After summ_rcv. rtn_status = ' || l_return_status
900: );

Line 897: ( log_level => FND_LOG.LEVEL_STATEMENT,

893:
894: IF (g_fnd_debug = 'Y') THEN
895: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
896: FND_LOG.string
897: ( log_level => FND_LOG.LEVEL_STATEMENT,
898: module => l_module || l_progress,
899: message => 'After summ_rcv. rtn_status = ' || l_return_status
900: );
901: END IF;

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

907:
908: END IF; -- p_purge_category IN (simple_po, matched_po_inv)
909:
910: IF (g_fnd_debug = 'Y') THEN
911: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
912: FND_LOG.string
913: ( log_level => FND_LOG.LEVEL_PROCEDURE,
914: module => l_module || l_progress,
915: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 912: FND_LOG.string

908: END IF; -- p_purge_category IN (simple_po, matched_po_inv)
909:
910: IF (g_fnd_debug = 'Y') THEN
911: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
912: FND_LOG.string
913: ( log_level => FND_LOG.LEVEL_PROCEDURE,
914: module => l_module || l_progress,
915: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
916: );

Line 913: ( log_level => FND_LOG.LEVEL_PROCEDURE,

909:
910: IF (g_fnd_debug = 'Y') THEN
911: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
912: FND_LOG.string
913: ( log_level => FND_LOG.LEVEL_PROCEDURE,
914: module => l_module || l_progress,
915: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
916: );
917: END IF;

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

921: WHEN OTHERS THEN
922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
923:
924: IF (g_fnd_debug = 'Y') THEN
925: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
926: FND_LOG.string
927: ( log_level => FND_LOG.LEVEL_STATEMENT,
928: module => l_module || l_progress,
929: message => 'Exception in ' || l_api_name || '.' ||

Line 926: FND_LOG.string

922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
923:
924: IF (g_fnd_debug = 'Y') THEN
925: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
926: FND_LOG.string
927: ( log_level => FND_LOG.LEVEL_STATEMENT,
928: module => l_module || l_progress,
929: message => 'Exception in ' || l_api_name || '.' ||
930: l_progress

Line 927: ( log_level => FND_LOG.LEVEL_STATEMENT,

923:
924: IF (g_fnd_debug = 'Y') THEN
925: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
926: FND_LOG.string
927: ( log_level => FND_LOG.LEVEL_STATEMENT,
928: module => l_module || l_progress,
929: message => 'Exception in ' || l_api_name || '.' ||
930: l_progress
931: );

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

996: l_api_name CONSTANT VARCHAR2(50) := 'delete_records';
997: l_api_version CONSTANT NUMBER := 1.0;
998: l_progress VARCHAR2(3);
999: l_return_status VARCHAR2(1);
1000: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1001: G_MODULE_PREFIX || l_api_name || '.';
1002: l_msg_idx NUMBER;
1003:
1004: l_req_lower_limit NUMBER;

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

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

Line 1015: FND_LOG.string

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

Line 1016: ( log_level => FND_LOG.LEVEL_PROCEDURE,

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

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

1122:
1123: END IF; -- if purge category = simple_po or matched po_inv
1124:
1125: IF (g_fnd_debug = 'Y') THEN
1126: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1127: FND_LOG.string
1128: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1129: module => l_module || l_progress,
1130: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 1127: FND_LOG.string

1123: END IF; -- if purge category = simple_po or matched po_inv
1124:
1125: IF (g_fnd_debug = 'Y') THEN
1126: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1127: FND_LOG.string
1128: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1129: module => l_module || l_progress,
1130: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1131: );

Line 1128: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1124:
1125: IF (g_fnd_debug = 'Y') THEN
1126: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1127: FND_LOG.string
1128: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1129: module => l_module || l_progress,
1130: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1131: );
1132: END IF;

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

1191:
1192: l_api_name CONSTANT VARCHAR2(50) := 'delete_purge_lists';
1193: l_api_version CONSTANT NUMBER := 1.0;
1194: l_progress VARCHAR2(3);
1195: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1196: G_MODULE_PREFIX || l_api_name || '.';
1197: l_msg_idx NUMBER;
1198:
1199: BEGIN

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

1200:
1201: l_progress := '000';
1202:
1203: IF (g_fnd_debug = 'Y') THEN
1204: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1205: FND_LOG.string
1206: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1207: module => l_module || l_progress,
1208: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1205: FND_LOG.string

1201: l_progress := '000';
1202:
1203: IF (g_fnd_debug = 'Y') THEN
1204: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1205: FND_LOG.string
1206: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1207: module => l_module || l_progress,
1208: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1209: );

Line 1206: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1202:
1203: IF (g_fnd_debug = 'Y') THEN
1204: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1205: FND_LOG.string
1206: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1207: module => l_module || l_progress,
1208: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1209: );
1210: END IF;

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

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

Line 1250: FND_LOG.string

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

Line 1251: ( log_level => FND_LOG.LEVEL_PROCEDURE,

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

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

1317: l_api_name CONSTANT VARCHAR2(50) := 'delete_history_tables';
1318: l_api_version CONSTANT NUMBER := 1.0;
1319: l_progress VARCHAR2(3);
1320: l_return_status VARCHAR2(1);
1321: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1322: G_MODULE_PREFIX || l_api_name || '.';
1323: l_msg_idx NUMBER;
1324:
1325: BEGIN

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

1326:
1327: l_progress := '000';
1328:
1329: IF (g_fnd_debug = 'Y') THEN
1330: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1331: FND_LOG.string
1332: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1333: module => l_module || l_progress,
1334: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1331: FND_LOG.string

1327: l_progress := '000';
1328:
1329: IF (g_fnd_debug = 'Y') THEN
1330: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1331: FND_LOG.string
1332: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1333: module => l_module || l_progress,
1334: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1335: );

Line 1332: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1328:
1329: IF (g_fnd_debug = 'Y') THEN
1330: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1331: FND_LOG.string
1332: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1333: module => l_module || l_progress,
1334: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1335: );
1336: END IF;

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

1381: COMMIT;
1382: END IF;
1383:
1384: IF (g_fnd_debug = 'Y') THEN
1385: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1386: FND_LOG.string
1387: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1388: module => l_module || l_progress,
1389: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 1386: FND_LOG.string

1382: END IF;
1383:
1384: IF (g_fnd_debug = 'Y') THEN
1385: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1386: FND_LOG.string
1387: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1388: module => l_module || l_progress,
1389: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1390: );

Line 1387: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1383:
1384: IF (g_fnd_debug = 'Y') THEN
1385: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1386: FND_LOG.string
1387: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1388: module => l_module || l_progress,
1389: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1390: );
1391: END IF;

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

1462: l_api_name VARCHAR2(50) := 'count_po_rows';
1463: l_api_version NUMBER := 1.0;
1464: l_progress VARCHAR2(3);
1465: l_return_status VARCHAR2(1);
1466: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1467: G_MODULE_PREFIX || l_api_name || '.';
1468: l_msg_idx NUMBER;
1469:
1470: BEGIN

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

1471:
1472: l_progress := '000';
1473:
1474: IF (g_fnd_debug = 'Y') THEN
1475: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1476: FND_LOG.string
1477: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1478: module => l_module || l_progress,
1479: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1476: FND_LOG.string

1472: l_progress := '000';
1473:
1474: IF (g_fnd_debug = 'Y') THEN
1475: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1476: FND_LOG.string
1477: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1478: module => l_module || l_progress,
1479: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1480: );

Line 1477: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1473:
1474: IF (g_fnd_debug = 'Y') THEN
1475: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1476: FND_LOG.string
1477: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1478: module => l_module || l_progress,
1479: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1480: );
1481: END IF;

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

1540: INTO x_asl_doc_count
1541: FROM po_asl_documents;
1542:
1543: IF (g_fnd_debug = 'Y') THEN
1544: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1545: FND_LOG.string
1546: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1547: module => l_module || l_progress,
1548: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 1545: FND_LOG.string

1541: FROM po_asl_documents;
1542:
1543: IF (g_fnd_debug = 'Y') THEN
1544: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1545: FND_LOG.string
1546: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1547: module => l_module || l_progress,
1548: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1549: );

Line 1546: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1542:
1543: IF (g_fnd_debug = 'Y') THEN
1544: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1545: FND_LOG.string
1546: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1547: module => l_module || l_progress,
1548: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1549: );
1550: END IF;

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

1601: ) IS
1602:
1603: l_api_name CONSTANT VARCHAR2(50) := 'seed_simple_req';
1604: l_progress VARCHAR2(3);
1605: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1606: G_MODULE_PREFIX || l_api_name || '.';
1607:
1608: BEGIN
1609: l_progress := '000';

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

1608: BEGIN
1609: l_progress := '000';
1610:
1611: IF (g_fnd_debug = 'Y') THEN
1612: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1613: FND_LOG.string
1614: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1615: module => l_module || l_progress,
1616: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1613: FND_LOG.string

1609: l_progress := '000';
1610:
1611: IF (g_fnd_debug = 'Y') THEN
1612: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1613: FND_LOG.string
1614: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1615: module => l_module || l_progress,
1616: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1617: );

Line 1614: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1610:
1611: IF (g_fnd_debug = 'Y') THEN
1612: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1613: FND_LOG.string
1614: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1615: module => l_module || l_progress,
1616: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1617: );
1618: END IF;

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

1664: AND PRD.last_update_date >
1665: p_last_activity_date)));
1666:
1667: IF (g_fnd_debug = 'Y') THEN
1668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1669: FND_LOG.string
1670: ( log_level => FND_LOG.LEVEL_STATEMENT,
1671: module => l_module || l_progress,
1672: message => 'Inserted ' || SQL%ROWCOUNT || ' Reqs to purge list'

Line 1669: FND_LOG.string

1665: p_last_activity_date)));
1666:
1667: IF (g_fnd_debug = 'Y') THEN
1668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1669: FND_LOG.string
1670: ( log_level => FND_LOG.LEVEL_STATEMENT,
1671: module => l_module || l_progress,
1672: message => 'Inserted ' || SQL%ROWCOUNT || ' Reqs to purge list'
1673: );

Line 1670: ( log_level => FND_LOG.LEVEL_STATEMENT,

1666:
1667: IF (g_fnd_debug = 'Y') THEN
1668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1669: FND_LOG.string
1670: ( log_level => FND_LOG.LEVEL_STATEMENT,
1671: module => l_module || l_progress,
1672: message => 'Inserted ' || SQL%ROWCOUNT || ' Reqs to purge list'
1673: );
1674: END IF;

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

1681: p_entity => 'REQ'
1682: );
1683:
1684: IF (g_fnd_debug = 'Y') THEN
1685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1686: FND_LOG.string
1687: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1688: module => l_module || l_progress,
1689: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 1686: FND_LOG.string

1682: );
1683:
1684: IF (g_fnd_debug = 'Y') THEN
1685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1686: FND_LOG.string
1687: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1688: module => l_module || l_progress,
1689: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1690: );

Line 1687: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1683:
1684: IF (g_fnd_debug = 'Y') THEN
1685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1686: FND_LOG.string
1687: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1688: module => l_module || l_progress,
1689: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
1690: );
1691: END IF;

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

1740:
1741: l_api_name CONSTANT VARCHAR2(50) := 'seed_po';
1742: l_progress VARCHAR2(3);
1743: l_return_status VARCHAR2(1);
1744: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1745: G_MODULE_PREFIX || l_api_name || '.';
1746:
1747: BEGIN
1748:

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

1748:
1749: l_progress := '000';
1750:
1751: IF (g_fnd_debug = 'Y') THEN
1752: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1753: FND_LOG.string
1754: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1755: module => l_module || l_progress,
1756: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 1753: FND_LOG.string

1749: l_progress := '000';
1750:
1751: IF (g_fnd_debug = 'Y') THEN
1752: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1753: FND_LOG.string
1754: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1755: module => l_module || l_progress,
1756: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1757: );

Line 1754: ( log_level => FND_LOG.LEVEL_PROCEDURE,

1750:
1751: IF (g_fnd_debug = 'Y') THEN
1752: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1753: FND_LOG.string
1754: ( log_level => FND_LOG.LEVEL_PROCEDURE,
1755: module => l_module || l_progress,
1756: message => 'Entering ' || g_pkg_name || '.' || l_api_name
1757: );
1758: END IF;

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

1769: IF (PO_CODE_RELEASE_GRP.Current_Release <
1770: PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J) THEN
1771:
1772: IF (g_fnd_debug = 'Y') THEN
1773: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1774: FND_LOG.string
1775: ( log_level => FND_LOG.LEVEL_STATEMENT,
1776: module => l_module || l_progress,
1777: message => 'PO level is less than FPJ '

Line 1774: FND_LOG.string

1770: PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J) THEN
1771:
1772: IF (g_fnd_debug = 'Y') THEN
1773: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1774: FND_LOG.string
1775: ( log_level => FND_LOG.LEVEL_STATEMENT,
1776: module => l_module || l_progress,
1777: message => 'PO level is less than FPJ '
1778: );

Line 1775: ( log_level => FND_LOG.LEVEL_STATEMENT,

1771:
1772: IF (g_fnd_debug = 'Y') THEN
1773: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1774: FND_LOG.string
1775: ( log_level => FND_LOG.LEVEL_STATEMENT,
1776: module => l_module || l_progress,
1777: message => 'PO level is less than FPJ '
1778: );
1779: END IF;

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

1896:
1897: END IF; -- p_purge_category = ...
1898:
1899: IF (g_fnd_debug = 'Y') THEN
1900: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1901: FND_LOG.string
1902: ( log_level => FND_LOG.LEVEL_STATEMENT,
1903: module => l_module || l_progress,
1904: message => 'inserted ' || SQL%ROWCOUNT || ' POs to purge'

Line 1901: FND_LOG.string

1897: END IF; -- p_purge_category = ...
1898:
1899: IF (g_fnd_debug = 'Y') THEN
1900: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1901: FND_LOG.string
1902: ( log_level => FND_LOG.LEVEL_STATEMENT,
1903: module => l_module || l_progress,
1904: message => 'inserted ' || SQL%ROWCOUNT || ' POs to purge'
1905: || ' list. purge_cat = ' || p_purge_category

Line 1902: ( log_level => FND_LOG.LEVEL_STATEMENT,

1898:
1899: IF (g_fnd_debug = 'Y') THEN
1900: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1901: FND_LOG.string
1902: ( log_level => FND_LOG.LEVEL_STATEMENT,
1903: module => l_module || l_progress,
1904: message => 'inserted ' || SQL%ROWCOUNT || ' POs to purge'
1905: || ' list. purge_cat = ' || p_purge_category
1906: );

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

1949: AND PRD.last_update_date >
1950: p_last_activity_date)));
1951:
1952: IF (g_fnd_debug = 'Y') THEN
1953: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1954: FND_LOG.string
1955: ( log_level => FND_LOG.LEVEL_STATEMENT,
1956: module => l_module || l_progress,
1957: message => 'inserted ' || SQL%ROWCOUNT || ' REQs to purge list'

Line 1954: FND_LOG.string

1950: p_last_activity_date)));
1951:
1952: IF (g_fnd_debug = 'Y') THEN
1953: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1954: FND_LOG.string
1955: ( log_level => FND_LOG.LEVEL_STATEMENT,
1956: module => l_module || l_progress,
1957: message => 'inserted ' || SQL%ROWCOUNT || ' REQs to purge list'
1958: );

Line 1955: ( log_level => FND_LOG.LEVEL_STATEMENT,

1951:
1952: IF (g_fnd_debug = 'Y') THEN
1953: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1954: FND_LOG.string
1955: ( log_level => FND_LOG.LEVEL_STATEMENT,
1956: module => l_module || l_progress,
1957: message => 'inserted ' || SQL%ROWCOUNT || ' REQs to purge list'
1958: );
1959: END IF;

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

1966:
1967: l_progress := '050';
1968:
1969: IF (g_fnd_debug = 'Y') THEN
1970: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1971: FND_LOG.string
1972: ( log_level => FND_LOG.LEVEL_STATEMENT,
1973: module => l_module || l_progress,
1974: message => 'PO Code Level > FPJ'

Line 1971: FND_LOG.string

1967: l_progress := '050';
1968:
1969: IF (g_fnd_debug = 'Y') THEN
1970: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1971: FND_LOG.string
1972: ( log_level => FND_LOG.LEVEL_STATEMENT,
1973: module => l_module || l_progress,
1974: message => 'PO Code Level > FPJ'
1975: );

Line 1972: ( log_level => FND_LOG.LEVEL_STATEMENT,

1968:
1969: IF (g_fnd_debug = 'Y') THEN
1970: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1971: FND_LOG.string
1972: ( log_level => FND_LOG.LEVEL_STATEMENT,
1973: module => l_module || l_progress,
1974: message => 'PO Code Level > FPJ'
1975: );
1976: END IF;

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

2002: );
2003:
2004:
2005: IF (g_fnd_debug = 'Y') THEN
2006: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2007: FND_LOG.string
2008: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2009: module => l_module || l_progress,
2010: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2007: FND_LOG.string

2003:
2004:
2005: IF (g_fnd_debug = 'Y') THEN
2006: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2007: FND_LOG.string
2008: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2009: module => l_module || l_progress,
2010: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2011: );

Line 2008: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2004:
2005: IF (g_fnd_debug = 'Y') THEN
2006: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2007: FND_LOG.string
2008: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2009: module => l_module || l_progress,
2010: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2011: );
2012: END IF;

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

2050: l_api_name CONSTANT VARCHAR2(50) := 'set_product_inst_status';
2051: l_api_version CONSTANT NUMBER := 1.0;
2052: l_progress VARCHAR2(3);
2053: l_return_status VARCHAR2(1);
2054: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2055: G_MODULE_PREFIX || l_api_name || '.';
2056:
2057: BEGIN
2058:

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

2058:
2059: l_progress := '000';
2060:
2061: IF (g_fnd_debug = 'Y') THEN
2062: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2063: FND_LOG.string
2064: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2065: module => l_module || l_progress,
2066: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 2063: FND_LOG.string

2059: l_progress := '000';
2060:
2061: IF (g_fnd_debug = 'Y') THEN
2062: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2063: FND_LOG.string
2064: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2065: module => l_module || l_progress,
2066: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2067: );

Line 2064: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2060:
2061: IF (g_fnd_debug = 'Y') THEN
2062: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2063: FND_LOG.string
2064: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2065: module => l_module || l_progress,
2066: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2067: );
2068: END IF;

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

2137: x_inst_status => g_pjm_install_status
2138: );
2139:
2140: IF (g_fnd_debug = 'Y') THEN
2141: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2142: FND_LOG.string
2143: ( log_level => FND_LOG.LEVEL_STATEMENT,
2144: module => l_module || l_progress,
2145: message => 'inv = ' || g_inv_install_status ||

Line 2142: FND_LOG.string

2138: );
2139:
2140: IF (g_fnd_debug = 'Y') THEN
2141: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2142: FND_LOG.string
2143: ( log_level => FND_LOG.LEVEL_STATEMENT,
2144: module => l_module || l_progress,
2145: message => 'inv = ' || g_inv_install_status ||
2146: ',wip = ' || g_wip_install_status ||

Line 2143: ( log_level => FND_LOG.LEVEL_STATEMENT,

2139:
2140: IF (g_fnd_debug = 'Y') THEN
2141: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2142: FND_LOG.string
2143: ( log_level => FND_LOG.LEVEL_STATEMENT,
2144: module => l_module || l_progress,
2145: message => 'inv = ' || g_inv_install_status ||
2146: ',wip = ' || g_wip_install_status ||
2147: ',mrp = ' || g_mrp_install_status ||

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

2161: -- has been called and all the product installation status have been set
2162: g_set_product_inst_status := FND_API.G_TRUE;
2163:
2164: IF (g_fnd_debug = 'Y') THEN
2165: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2166: FND_LOG.string
2167: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2168: module => l_module || l_progress,
2169: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2166: FND_LOG.string

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

Line 2167: ( log_level => FND_LOG.LEVEL_PROCEDURE,

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

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

2215: ) IS
2216:
2217: l_api_name VARCHAR2(50) := 'get_installation_status';
2218: l_progress VARCHAR2(3);
2219: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2220: G_MODULE_PREFIX || l_api_name || '.';
2221:
2222: l_inst_check VARCHAR2(1);
2223: l_dummy VARCHAR2(1);

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

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

Line 2232: FND_LOG.string

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

Line 2233: ( log_level => FND_LOG.LEVEL_PROCEDURE,

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

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

2260:
2261: END IF; -- FND_INSTALLATION.get()
2262:
2263: IF (g_fnd_debug = 'Y') THEN
2264: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2265: FND_LOG.string
2266: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2267: module => l_module || l_progress,
2268: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2265: FND_LOG.string

2261: END IF; -- FND_INSTALLATION.get()
2262:
2263: IF (g_fnd_debug = 'Y') THEN
2264: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2265: FND_LOG.string
2266: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2267: module => l_module || l_progress,
2268: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2269: );

Line 2266: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2262:
2263: IF (g_fnd_debug = 'Y') THEN
2264: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2265: FND_LOG.string
2266: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2267: module => l_module || l_progress,
2268: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2269: );
2270: END IF;

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

2308: )IS
2309:
2310: l_api_name VARCHAR2(50) := 'filter_referenced_req';
2311: l_progress VARCHAR2(3);
2312: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2313: G_MODULE_PREFIX || l_api_name || '.';
2314:
2315: l_return_status VARCHAR2(1);
2316:

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

2318:
2319: l_progress := '000';
2320:
2321: IF (g_fnd_debug = 'Y') THEN
2322: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2323: FND_LOG.string
2324: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2325: module => l_module || l_progress,
2326: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 2323: FND_LOG.string

2319: l_progress := '000';
2320:
2321: IF (g_fnd_debug = 'Y') THEN
2322: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2323: FND_LOG.string
2324: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2325: module => l_module || l_progress,
2326: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2327: );

Line 2324: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2320:
2321: IF (g_fnd_debug = 'Y') THEN
2322: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2323: FND_LOG.string
2324: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2325: module => l_module || l_progress,
2326: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2327: );
2328: END IF;

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

2342: WHERE CIO.document_header_id = PPRL.requisition_header_id
2343: AND CIO.supply_document_type = 'REQUISITION');
2344:
2345: IF (g_fnd_debug = 'Y') THEN
2346: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2347: FND_LOG.string
2348: ( log_level => FND_LOG.LEVEL_STATEMENT,
2349: module => l_module || l_progress,
2350: message => 'Check CHV. Updated rowcount = ' || SQL%ROWCOUNT

Line 2347: FND_LOG.string

2343: AND CIO.supply_document_type = 'REQUISITION');
2344:
2345: IF (g_fnd_debug = 'Y') THEN
2346: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2347: FND_LOG.string
2348: ( log_level => FND_LOG.LEVEL_STATEMENT,
2349: module => l_module || l_progress,
2350: message => 'Check CHV. Updated rowcount = ' || SQL%ROWCOUNT
2351: );

Line 2348: ( log_level => FND_LOG.LEVEL_STATEMENT,

2344:
2345: IF (g_fnd_debug = 'Y') THEN
2346: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2347: FND_LOG.string
2348: ( log_level => FND_LOG.LEVEL_STATEMENT,
2349: module => l_module || l_progress,
2350: message => 'Check CHV. Updated rowcount = ' || SQL%ROWCOUNT
2351: );
2352: END IF;

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

2375: -- Do not hardcode schema name.
2376: -- GSCC checker parses PA as schema name even though it's text
2377: -- due to extra _. Modified message from _PA_ to PA product.
2378: IF (g_fnd_debug = 'Y') THEN
2379: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2380: FND_LOG.string
2381: ( log_level => FND_LOG.LEVEL_STATEMENT,
2382: module => l_module || l_progress,
2383: message => 'Check PA product. ' ||

Line 2380: FND_LOG.string

2376: -- GSCC checker parses PA as schema name even though it's text
2377: -- due to extra _. Modified message from _PA_ to PA product.
2378: IF (g_fnd_debug = 'Y') THEN
2379: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2380: FND_LOG.string
2381: ( log_level => FND_LOG.LEVEL_STATEMENT,
2382: module => l_module || l_progress,
2383: message => 'Check PA product. ' ||
2384: 'Updated rowcount = ' || SQL%ROWCOUNT

Line 2381: ( log_level => FND_LOG.LEVEL_STATEMENT,

2377: -- due to extra _. Modified message from _PA_ to PA product.
2378: IF (g_fnd_debug = 'Y') THEN
2379: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2380: FND_LOG.string
2381: ( log_level => FND_LOG.LEVEL_STATEMENT,
2382: module => l_module || l_progress,
2383: message => 'Check PA product. ' ||
2384: 'Updated rowcount = ' || SQL%ROWCOUNT
2385: );

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

2409: -- Do not hardcode schema name.
2410: -- GSCC checker parses PJM as schema name even though it's text
2411: -- due to extra _. Modified message from _PJM_ to PJM product.
2412: IF (g_fnd_debug = 'Y') THEN
2413: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2414: FND_LOG.string
2415: ( log_level => FND_LOG.LEVEL_STATEMENT,
2416: module => l_module || l_progress,
2417: message => 'Check PJM product, ' ||

Line 2414: FND_LOG.string

2410: -- GSCC checker parses PJM as schema name even though it's text
2411: -- due to extra _. Modified message from _PJM_ to PJM product.
2412: IF (g_fnd_debug = 'Y') THEN
2413: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2414: FND_LOG.string
2415: ( log_level => FND_LOG.LEVEL_STATEMENT,
2416: module => l_module || l_progress,
2417: message => 'Check PJM product, ' ||
2418: 'Updated rowcount = ' || SQL%ROWCOUNT

Line 2415: ( log_level => FND_LOG.LEVEL_STATEMENT,

2411: -- due to extra _. Modified message from _PJM_ to PJM product.
2412: IF (g_fnd_debug = 'Y') THEN
2413: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2414: FND_LOG.string
2415: ( log_level => FND_LOG.LEVEL_STATEMENT,
2416: module => l_module || l_progress,
2417: message => 'Check PJM product, ' ||
2418: 'Updated rowcount = ' || SQL%ROWCOUNT
2419: );

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

2444: p_entity => 'REQ'
2445: );
2446:
2447: IF (g_fnd_debug = 'Y') THEN
2448: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2449: FND_LOG.string
2450: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2451: module => l_module || l_progress,
2452: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2449: FND_LOG.string

2445: );
2446:
2447: IF (g_fnd_debug = 'Y') THEN
2448: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2449: FND_LOG.string
2450: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2451: module => l_module || l_progress,
2452: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2453: );

Line 2450: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2446:
2447: IF (g_fnd_debug = 'Y') THEN
2448: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2449: FND_LOG.string
2450: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2451: module => l_module || l_progress,
2452: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2453: );
2454: END IF;

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

2493:
2494: l_api_name VARCHAR2(50) := 'filter_referenced_po';
2495: l_progress VARCHAR2(3);
2496: l_return_status VARCHAR2(1);
2497: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2498: G_MODULE_PREFIX || l_api_name || '.';
2499:
2500: BEGIN
2501:

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

2501:
2502: l_progress := '000';
2503:
2504: IF (g_fnd_debug = 'Y') THEN
2505: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2506: FND_LOG.string
2507: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2508: module => l_module || l_progress,
2509: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 2506: FND_LOG.string

2502: l_progress := '000';
2503:
2504: IF (g_fnd_debug = 'Y') THEN
2505: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2506: FND_LOG.string
2507: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2508: module => l_module || l_progress,
2509: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2510: );

Line 2507: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2503:
2504: IF (g_fnd_debug = 'Y') THEN
2505: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2506: FND_LOG.string
2507: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2508: module => l_module || l_progress,
2509: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2510: );
2511: END IF;

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

2529: -- Do not hardcode schema name.
2530: -- GSCC checker parses INV as schema name even though it's text
2531: -- due to extra _. Modified message from _INV_ to INV product.
2532: IF (g_fnd_debug = 'Y') THEN
2533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2534: FND_LOG.string
2535: ( log_level => FND_LOG.LEVEL_STATEMENT,
2536: module => l_module || l_progress,
2537: message => 'Check INV product. ' ||

Line 2534: FND_LOG.string

2530: -- GSCC checker parses INV as schema name even though it's text
2531: -- due to extra _. Modified message from _INV_ to INV product.
2532: IF (g_fnd_debug = 'Y') THEN
2533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2534: FND_LOG.string
2535: ( log_level => FND_LOG.LEVEL_STATEMENT,
2536: module => l_module || l_progress,
2537: message => 'Check INV product. ' ||
2538: 'Updated rowcount = ' || SQL%ROWCOUNT

Line 2535: ( log_level => FND_LOG.LEVEL_STATEMENT,

2531: -- due to extra _. Modified message from _INV_ to INV product.
2532: IF (g_fnd_debug = 'Y') THEN
2533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2534: FND_LOG.string
2535: ( log_level => FND_LOG.LEVEL_STATEMENT,
2536: module => l_module || l_progress,
2537: message => 'Check INV product. ' ||
2538: 'Updated rowcount = ' || SQL%ROWCOUNT
2539: );

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

2557: -- Do not hardcode schema name.
2558: -- GSCC checker parses WIP as schema name even though it's text
2559: -- due to extra _. Modified message from _WIP_ to WIP product.
2560: IF (g_fnd_debug = 'Y') THEN
2561: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2562: FND_LOG.string
2563: ( log_level => FND_LOG.LEVEL_STATEMENT,
2564: module => l_module || l_progress,
2565: message => 'Check WIP product. ' ||

Line 2562: FND_LOG.string

2558: -- GSCC checker parses WIP as schema name even though it's text
2559: -- due to extra _. Modified message from _WIP_ to WIP product.
2560: IF (g_fnd_debug = 'Y') THEN
2561: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2562: FND_LOG.string
2563: ( log_level => FND_LOG.LEVEL_STATEMENT,
2564: module => l_module || l_progress,
2565: message => 'Check WIP product. ' ||
2566: 'Updated rowcount = ' || SQL%ROWCOUNT

Line 2563: ( log_level => FND_LOG.LEVEL_STATEMENT,

2559: -- due to extra _. Modified message from _WIP_ to WIP product.
2560: IF (g_fnd_debug = 'Y') THEN
2561: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2562: FND_LOG.string
2563: ( log_level => FND_LOG.LEVEL_STATEMENT,
2564: module => l_module || l_progress,
2565: message => 'Check WIP product. ' ||
2566: 'Updated rowcount = ' || SQL%ROWCOUNT
2567: );

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

2586: -- Do not hardcode schema name.
2587: -- GSCC checker parses MRP as schema name even though it's text
2588: -- due to extra _. Modified message from _MRP_ to MRP product.
2589: IF (g_fnd_debug = 'Y') THEN
2590: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2591: FND_LOG.string
2592: ( log_level => FND_LOG.LEVEL_STATEMENT,
2593: module => l_module || l_progress,
2594: message => 'Check MRP product. ' ||

Line 2591: FND_LOG.string

2587: -- GSCC checker parses MRP as schema name even though it's text
2588: -- due to extra _. Modified message from _MRP_ to MRP product.
2589: IF (g_fnd_debug = 'Y') THEN
2590: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2591: FND_LOG.string
2592: ( log_level => FND_LOG.LEVEL_STATEMENT,
2593: module => l_module || l_progress,
2594: message => 'Check MRP product. ' ||
2595: 'Updated rowcount = ' || SQL%ROWCOUNT

Line 2592: ( log_level => FND_LOG.LEVEL_STATEMENT,

2588: -- due to extra _. Modified message from _MRP_ to MRP product.
2589: IF (g_fnd_debug = 'Y') THEN
2590: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2591: FND_LOG.string
2592: ( log_level => FND_LOG.LEVEL_STATEMENT,
2593: module => l_module || l_progress,
2594: message => 'Check MRP product. ' ||
2595: 'Updated rowcount = ' || SQL%ROWCOUNT
2596: );

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

2611: WHERE CIO.document_header_id = PPL.po_header_id
2612: AND CIO.supply_document_type = 'RELEASE');
2613:
2614: IF (g_fnd_debug = 'Y') THEN
2615: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2616: FND_LOG.string
2617: ( log_level => FND_LOG.LEVEL_STATEMENT,
2618: module => l_module || l_progress,
2619: message => 'Check CHV. Updated rowcount = ' || SQL%ROWCOUNT

Line 2616: FND_LOG.string

2612: AND CIO.supply_document_type = 'RELEASE');
2613:
2614: IF (g_fnd_debug = 'Y') THEN
2615: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2616: FND_LOG.string
2617: ( log_level => FND_LOG.LEVEL_STATEMENT,
2618: module => l_module || l_progress,
2619: message => 'Check CHV. Updated rowcount = ' || SQL%ROWCOUNT
2620: );

Line 2617: ( log_level => FND_LOG.LEVEL_STATEMENT,

2613:
2614: IF (g_fnd_debug = 'Y') THEN
2615: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2616: FND_LOG.string
2617: ( log_level => FND_LOG.LEVEL_STATEMENT,
2618: module => l_module || l_progress,
2619: message => 'Check CHV. Updated rowcount = ' || SQL%ROWCOUNT
2620: );
2621: END IF;

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

2640: -- Do not hardcode schema name.
2641: -- GSCC checker parses PA as schema name even though it's text
2642: -- due to extra _. Modified message from _PA_ to PA product.
2643: IF (g_fnd_debug = 'Y') THEN
2644: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2645: FND_LOG.string
2646: ( log_level => FND_LOG.LEVEL_STATEMENT,
2647: module => l_module || l_progress,
2648: message => 'Check PA product. ' ||

Line 2645: FND_LOG.string

2641: -- GSCC checker parses PA as schema name even though it's text
2642: -- due to extra _. Modified message from _PA_ to PA product.
2643: IF (g_fnd_debug = 'Y') THEN
2644: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2645: FND_LOG.string
2646: ( log_level => FND_LOG.LEVEL_STATEMENT,
2647: module => l_module || l_progress,
2648: message => 'Check PA product. ' ||
2649: 'Updated rowcount = ' || SQL%ROWCOUNT

Line 2646: ( log_level => FND_LOG.LEVEL_STATEMENT,

2642: -- due to extra _. Modified message from _PA_ to PA product.
2643: IF (g_fnd_debug = 'Y') THEN
2644: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2645: FND_LOG.string
2646: ( log_level => FND_LOG.LEVEL_STATEMENT,
2647: module => l_module || l_progress,
2648: message => 'Check PA product. ' ||
2649: 'Updated rowcount = ' || SQL%ROWCOUNT
2650: );

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

2670: -- Do not hardcode schema name.
2671: -- GSCC checker parses PJM as schema name even though it's text
2672: -- due to extra _. Modified message from _PJM_ to PJM product.
2673: IF (g_fnd_debug = 'Y') THEN
2674: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2675: FND_LOG.string
2676: ( log_level => FND_LOG.LEVEL_STATEMENT,
2677: module => l_module || l_progress,
2678: message => 'Check PJM product. ' ||

Line 2675: FND_LOG.string

2671: -- GSCC checker parses PJM as schema name even though it's text
2672: -- due to extra _. Modified message from _PJM_ to PJM product.
2673: IF (g_fnd_debug = 'Y') THEN
2674: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2675: FND_LOG.string
2676: ( log_level => FND_LOG.LEVEL_STATEMENT,
2677: module => l_module || l_progress,
2678: message => 'Check PJM product. ' ||
2679: 'Updated rowcount = ' || SQL%ROWCOUNT

Line 2676: ( log_level => FND_LOG.LEVEL_STATEMENT,

2672: -- due to extra _. Modified message from _PJM_ to PJM product.
2673: IF (g_fnd_debug = 'Y') THEN
2674: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2675: FND_LOG.string
2676: ( log_level => FND_LOG.LEVEL_STATEMENT,
2677: module => l_module || l_progress,
2678: message => 'Check PJM product. ' ||
2679: 'Updated rowcount = ' || SQL%ROWCOUNT
2680: );

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

2702: p_entity => 'PO'
2703: );
2704:
2705: IF (g_fnd_debug = 'Y') THEN
2706: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2707: FND_LOG.string
2708: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2709: module => l_module || l_progress,
2710: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2707: FND_LOG.string

2703: );
2704:
2705: IF (g_fnd_debug = 'Y') THEN
2706: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2707: FND_LOG.string
2708: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2709: module => l_module || l_progress,
2710: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2711: );

Line 2708: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2704:
2705: IF (g_fnd_debug = 'Y') THEN
2706: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2707: FND_LOG.string
2708: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2709: module => l_module || l_progress,
2710: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2711: );
2712: END IF;

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

2754: ) IS
2755:
2756: l_api_name VARCHAR2(50) := 'filter_dependent_po_req_list';
2757: l_progress VARCHAR2(3);
2758: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2759: G_MODULE_PREFIX || l_api_name || '.';
2760:
2761: l_po_count NUMBER;
2762: l_req_count NUMBER;

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

2764: BEGIN
2765: l_progress := '000';
2766:
2767: IF (g_fnd_debug = 'Y') THEN
2768: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2769: FND_LOG.string
2770: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2771: module => l_module || l_progress,
2772: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 2769: FND_LOG.string

2765: l_progress := '000';
2766:
2767: IF (g_fnd_debug = 'Y') THEN
2768: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2769: FND_LOG.string
2770: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2771: module => l_module || l_progress,
2772: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2773: );

Line 2770: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2766:
2767: IF (g_fnd_debug = 'Y') THEN
2768: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2769: FND_LOG.string
2770: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2771: module => l_module || l_progress,
2772: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2773: );
2774: END IF;

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

2889: PLL.po_header_id));
2890: l_req_count := SQL%ROWCOUNT;
2891:
2892: IF (g_fnd_debug = 'Y') THEN
2893: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2894: FND_LOG.string
2895: ( log_level => FND_LOG.LEVEL_STATEMENT,
2896: module => l_module || l_progress,
2897: message => 'Updated po_count = ' || l_po_count ||

Line 2894: FND_LOG.string

2890: l_req_count := SQL%ROWCOUNT;
2891:
2892: IF (g_fnd_debug = 'Y') THEN
2893: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2894: FND_LOG.string
2895: ( log_level => FND_LOG.LEVEL_STATEMENT,
2896: module => l_module || l_progress,
2897: message => 'Updated po_count = ' || l_po_count ||
2898: ', Updated req_count = ' || l_req_count

Line 2895: ( log_level => FND_LOG.LEVEL_STATEMENT,

2891:
2892: IF (g_fnd_debug = 'Y') THEN
2893: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2894: FND_LOG.string
2895: ( log_level => FND_LOG.LEVEL_STATEMENT,
2896: module => l_module || l_progress,
2897: message => 'Updated po_count = ' || l_po_count ||
2898: ', Updated req_count = ' || l_req_count
2899: );

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

2920:
2921: END LOOP;
2922:
2923: IF (g_fnd_debug = 'Y') THEN
2924: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2925: FND_LOG.string
2926: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2927: module => l_module || l_progress,
2928: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 2925: FND_LOG.string

2921: END LOOP;
2922:
2923: IF (g_fnd_debug = 'Y') THEN
2924: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2925: FND_LOG.string
2926: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2927: module => l_module || l_progress,
2928: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2929: );

Line 2926: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2922:
2923: IF (g_fnd_debug = 'Y') THEN
2924: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2925: FND_LOG.string
2926: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2927: module => l_module || l_progress,
2928: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
2929: );
2930: END IF;

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

2970: ) IS
2971:
2972: l_api_name VARCHAR2(50) := 'filter_dependent_po_ap_list';
2973: l_progress VARCHAR2(3);
2974: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2975: G_MODULE_PREFIX || l_api_name || '.';
2976:
2977: l_po_count NUMBER;
2978:

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

2979: BEGIN
2980: l_progress := '000';
2981:
2982: IF (g_fnd_debug = 'Y') THEN
2983: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2984: FND_LOG.string
2985: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2986: module => l_module || l_progress,
2987: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 2984: FND_LOG.string

2980: l_progress := '000';
2981:
2982: IF (g_fnd_debug = 'Y') THEN
2983: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2984: FND_LOG.string
2985: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2986: module => l_module || l_progress,
2987: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2988: );

Line 2985: ( log_level => FND_LOG.LEVEL_PROCEDURE,

2981:
2982: IF (g_fnd_debug = 'Y') THEN
2983: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2984: FND_LOG.string
2985: ( log_level => FND_LOG.LEVEL_PROCEDURE,
2986: module => l_module || l_progress,
2987: message => 'Entering ' || g_pkg_name || '.' || l_api_name
2988: );
2989: END IF;

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

3014:
3015: l_po_count := SQL%ROWCOUNT;
3016:
3017: IF (g_fnd_debug = 'Y') THEN
3018: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3019: FND_LOG.string
3020: ( log_level => FND_LOG.LEVEL_STATEMENT,
3021: module => l_module || l_progress,
3022: message => 'Updated po rowcount = ' || l_po_count

Line 3019: FND_LOG.string

3015: l_po_count := SQL%ROWCOUNT;
3016:
3017: IF (g_fnd_debug = 'Y') THEN
3018: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3019: FND_LOG.string
3020: ( log_level => FND_LOG.LEVEL_STATEMENT,
3021: module => l_module || l_progress,
3022: message => 'Updated po rowcount = ' || l_po_count
3023: );

Line 3020: ( log_level => FND_LOG.LEVEL_STATEMENT,

3016:
3017: IF (g_fnd_debug = 'Y') THEN
3018: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3019: FND_LOG.string
3020: ( log_level => FND_LOG.LEVEL_STATEMENT,
3021: module => l_module || l_progress,
3022: message => 'Updated po rowcount = ' || l_po_count
3023: );
3024: END IF;

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

3033: p_entity => 'PO'
3034: );
3035:
3036: IF (g_fnd_debug = 'Y') THEN
3037: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3038: FND_LOG.string
3039: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3040: module => l_module || l_progress,
3041: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 3038: FND_LOG.string

3034: );
3035:
3036: IF (g_fnd_debug = 'Y') THEN
3037: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3038: FND_LOG.string
3039: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3040: module => l_module || l_progress,
3041: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3042: );

Line 3039: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3035:
3036: IF (g_fnd_debug = 'Y') THEN
3037: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3038: FND_LOG.string
3039: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3040: module => l_module || l_progress,
3041: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3042: );
3043: END IF;

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

3084: ) IS
3085:
3086: l_api_name VARCHAR2(50) := 'remove_filtered_records';
3087: l_progress VARCHAR2(3);
3088: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3089: G_MODULE_PREFIX || l_api_name || '.';
3090:
3091: BEGIN
3092:

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

3092:
3093: l_progress := '000';
3094:
3095: IF (g_fnd_debug = 'Y') THEN
3096: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3097: FND_LOG.string
3098: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3099: module => l_module || l_progress,
3100: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 3097: FND_LOG.string

3093: l_progress := '000';
3094:
3095: IF (g_fnd_debug = 'Y') THEN
3096: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3097: FND_LOG.string
3098: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3099: module => l_module || l_progress,
3100: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3101: );

Line 3098: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3094:
3095: IF (g_fnd_debug = 'Y') THEN
3096: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3097: FND_LOG.string
3098: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3099: module => l_module || l_progress,
3100: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3101: );
3102: END IF;

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

3107: DELETE FROM po_purge_req_list
3108: WHERE double_check_flag = 'N';
3109:
3110: IF (g_fnd_debug = 'Y') THEN
3111: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3112: FND_LOG.string
3113: ( log_level => FND_LOG.LEVEL_STATEMENT,
3114: module => l_module || l_progress,
3115: message => 'Deleted ' || SQL%ROWCOUNT || ' reqs from purge list'

Line 3112: FND_LOG.string

3108: WHERE double_check_flag = 'N';
3109:
3110: IF (g_fnd_debug = 'Y') THEN
3111: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3112: FND_LOG.string
3113: ( log_level => FND_LOG.LEVEL_STATEMENT,
3114: module => l_module || l_progress,
3115: message => 'Deleted ' || SQL%ROWCOUNT || ' reqs from purge list'
3116: );

Line 3113: ( log_level => FND_LOG.LEVEL_STATEMENT,

3109:
3110: IF (g_fnd_debug = 'Y') THEN
3111: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3112: FND_LOG.string
3113: ( log_level => FND_LOG.LEVEL_STATEMENT,
3114: module => l_module || l_progress,
3115: message => 'Deleted ' || SQL%ROWCOUNT || ' reqs from purge list'
3116: );
3117: END IF;

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

3126: DELETE FROM po_purge_po_list
3127: WHERE double_check_flag = 'N';
3128:
3129: IF (g_fnd_debug = 'Y') THEN
3130: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3131: FND_LOG.string
3132: ( log_level => FND_LOG.LEVEL_STATEMENT,
3133: module => l_module || l_progress,
3134: message => 'Deleted ' || SQL%ROWCOUNT || ' pos from purge list'

Line 3131: FND_LOG.string

3127: WHERE double_check_flag = 'N';
3128:
3129: IF (g_fnd_debug = 'Y') THEN
3130: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3131: FND_LOG.string
3132: ( log_level => FND_LOG.LEVEL_STATEMENT,
3133: module => l_module || l_progress,
3134: message => 'Deleted ' || SQL%ROWCOUNT || ' pos from purge list'
3135: );

Line 3132: ( log_level => FND_LOG.LEVEL_STATEMENT,

3128:
3129: IF (g_fnd_debug = 'Y') THEN
3130: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3131: FND_LOG.string
3132: ( log_level => FND_LOG.LEVEL_STATEMENT,
3133: module => l_module || l_progress,
3134: message => 'Deleted ' || SQL%ROWCOUNT || ' pos from purge list'
3135: );
3136: END IF;

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

3138:
3139: END IF; -- p_purge_category
3140:
3141: IF (g_fnd_debug = 'Y') THEN
3142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3143: FND_LOG.string
3144: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3145: module => l_module || l_progress,
3146: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 3143: FND_LOG.string

3139: END IF; -- p_purge_category
3140:
3141: IF (g_fnd_debug = 'Y') THEN
3142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3143: FND_LOG.string
3144: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3145: module => l_module || l_progress,
3146: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3147: );

Line 3144: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3140:
3141: IF (g_fnd_debug = 'Y') THEN
3142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3143: FND_LOG.string
3144: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3145: module => l_module || l_progress,
3146: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3147: );
3148: END IF;

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

3189: ) IS
3190:
3191: l_api_name VARCHAR2(50) := 'confirm_simple_req';
3192: l_progress VARCHAR2(3);
3193: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3194: G_MODULE_PREFIX || l_api_name || '.';
3195:
3196: BEGIN
3197:

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

3197:
3198: l_progress := '000';
3199:
3200: IF (g_fnd_debug = 'Y') THEN
3201: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3202: FND_LOG.string
3203: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3204: module => l_module || l_progress,
3205: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 3202: FND_LOG.string

3198: l_progress := '000';
3199:
3200: IF (g_fnd_debug = 'Y') THEN
3201: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3202: FND_LOG.string
3203: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3204: module => l_module || l_progress,
3205: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3206: );

Line 3203: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3199:
3200: IF (g_fnd_debug = 'Y') THEN
3201: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3202: FND_LOG.string
3203: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3204: module => l_module || l_progress,
3205: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3206: );
3207: END IF;

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

3257: AND RD.last_update_date >
3258: p_last_activity_date))));
3259:
3260: IF (g_fnd_debug = 'Y') THEN
3261: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3262: FND_LOG.string
3263: ( log_level => FND_LOG.LEVEL_STATEMENT,
3264: module => l_module || l_progress,
3265: message => 'Excluded ' || SQL%ROWCOUNT || ' reqs in purge list'

Line 3262: FND_LOG.string

3258: p_last_activity_date))));
3259:
3260: IF (g_fnd_debug = 'Y') THEN
3261: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3262: FND_LOG.string
3263: ( log_level => FND_LOG.LEVEL_STATEMENT,
3264: module => l_module || l_progress,
3265: message => 'Excluded ' || SQL%ROWCOUNT || ' reqs in purge list'
3266: );

Line 3263: ( log_level => FND_LOG.LEVEL_STATEMENT,

3259:
3260: IF (g_fnd_debug = 'Y') THEN
3261: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3262: FND_LOG.string
3263: ( log_level => FND_LOG.LEVEL_STATEMENT,
3264: module => l_module || l_progress,
3265: message => 'Excluded ' || SQL%ROWCOUNT || ' reqs in purge list'
3266: );
3267: END IF;

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

3274: p_entity => 'REQ'
3275: );
3276:
3277: IF (g_fnd_debug = 'Y') THEN
3278: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3279: FND_LOG.string
3280: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3281: module => l_module || l_progress,
3282: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 3279: FND_LOG.string

3275: );
3276:
3277: IF (g_fnd_debug = 'Y') THEN
3278: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3279: FND_LOG.string
3280: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3281: module => l_module || l_progress,
3282: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3283: );

Line 3280: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3276:
3277: IF (g_fnd_debug = 'Y') THEN
3278: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3279: FND_LOG.string
3280: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3281: module => l_module || l_progress,
3282: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3283: );
3284: END IF;

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

3328: ) IS
3329:
3330: l_api_name VARCHAR2(50) := 'confirm_po';
3331: l_progress VARCHAR2(3);
3332: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3333: G_MODULE_PREFIX || l_api_name || '.';
3334:
3335: BEGIN
3336:

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

3336:
3337: l_progress := '000';
3338:
3339: IF (g_fnd_debug = 'Y') THEN
3340: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3341: FND_LOG.string
3342: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3343: module => l_module || l_progress,
3344: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 3341: FND_LOG.string

3337: l_progress := '000';
3338:
3339: IF (g_fnd_debug = 'Y') THEN
3340: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3341: FND_LOG.string
3342: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3343: module => l_module || l_progress,
3344: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3345: );

Line 3342: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3338:
3339: IF (g_fnd_debug = 'Y') THEN
3340: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3341: FND_LOG.string
3342: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3343: module => l_module || l_progress,
3344: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3345: );
3346: END IF;

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

3484: END IF; -- purge_category = 'SIMPLE PO'
3485:
3486:
3487: IF (g_fnd_debug = 'Y') THEN
3488: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3489: FND_LOG.string
3490: ( log_level => FND_LOG.LEVEL_STATEMENT,
3491: module => l_module || l_progress,
3492: message => 'Excluded ' || SQL%ROWCOUNT || ' pos frm purge ' ||

Line 3489: FND_LOG.string

3485:
3486:
3487: IF (g_fnd_debug = 'Y') THEN
3488: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3489: FND_LOG.string
3490: ( log_level => FND_LOG.LEVEL_STATEMENT,
3491: module => l_module || l_progress,
3492: message => 'Excluded ' || SQL%ROWCOUNT || ' pos frm purge ' ||
3493: 'list. p_purge_category = ' || p_purge_category

Line 3490: ( log_level => FND_LOG.LEVEL_STATEMENT,

3486:
3487: IF (g_fnd_debug = 'Y') THEN
3488: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3489: FND_LOG.string
3490: ( log_level => FND_LOG.LEVEL_STATEMENT,
3491: module => l_module || l_progress,
3492: message => 'Excluded ' || SQL%ROWCOUNT || ' pos frm purge ' ||
3493: 'list. p_purge_category = ' || p_purge_category
3494: );

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

3543: p_last_activity_date))));
3544:
3545:
3546: IF (g_fnd_debug = 'Y') THEN
3547: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3548: FND_LOG.string
3549: ( log_level => FND_LOG.LEVEL_STATEMENT,
3550: module => l_module || l_progress,
3551: message => 'Excluded ' || SQL%ROWCOUNT || ' reqs frm purge ' ||

Line 3548: FND_LOG.string

3544:
3545:
3546: IF (g_fnd_debug = 'Y') THEN
3547: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3548: FND_LOG.string
3549: ( log_level => FND_LOG.LEVEL_STATEMENT,
3550: module => l_module || l_progress,
3551: message => 'Excluded ' || SQL%ROWCOUNT || ' reqs frm purge ' ||
3552: 'list'

Line 3549: ( log_level => FND_LOG.LEVEL_STATEMENT,

3545:
3546: IF (g_fnd_debug = 'Y') THEN
3547: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3548: FND_LOG.string
3549: ( log_level => FND_LOG.LEVEL_STATEMENT,
3550: module => l_module || l_progress,
3551: message => 'Excluded ' || SQL%ROWCOUNT || ' reqs frm purge ' ||
3552: 'list'
3553: );

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

3564: p_entity => 'PO'
3565: );
3566:
3567: IF (g_fnd_debug = 'Y') THEN
3568: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3569: FND_LOG.string
3570: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3571: module => l_module || l_progress,
3572: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 3569: FND_LOG.string

3565: );
3566:
3567: IF (g_fnd_debug = 'Y') THEN
3568: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3569: FND_LOG.string
3570: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3571: module => l_module || l_progress,
3572: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3573: );

Line 3570: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3566:
3567: IF (g_fnd_debug = 'Y') THEN
3568: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3569: FND_LOG.string
3570: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3571: module => l_module || l_progress,
3572: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3573: );
3574: END IF;

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

3621: ) IS
3622:
3623: l_api_name VARCHAR2(50) := 'get_purge_list_range';
3624: l_progress VARCHAR2(3);
3625: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3626: G_MODULE_PREFIX || l_api_name || '.';
3627:
3628: BEGIN
3629:

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

3629:
3630: l_progress := '000';
3631:
3632: IF (g_fnd_debug = 'Y') THEN
3633: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3634: FND_LOG.string
3635: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3636: module => l_module || l_progress,
3637: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 3634: FND_LOG.string

3630: l_progress := '000';
3631:
3632: IF (g_fnd_debug = 'Y') THEN
3633: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3634: FND_LOG.string
3635: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3636: module => l_module || l_progress,
3637: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3638: );

Line 3635: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3631:
3632: IF (g_fnd_debug = 'Y') THEN
3633: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3634: FND_LOG.string
3635: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3636: module => l_module || l_progress,
3637: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3638: );
3639: END IF;

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

3670: END IF; -- p_category
3671:
3672:
3673: IF (g_fnd_debug = 'Y') THEN
3674: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3675: FND_LOG.string
3676: ( log_level => FND_LOG.LEVEL_STATEMENT,
3677: module => l_module || l_progress,
3678: message => 'p_category = ' || p_category || ', lower_limit = ' ||

Line 3675: FND_LOG.string

3671:
3672:
3673: IF (g_fnd_debug = 'Y') THEN
3674: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3675: FND_LOG.string
3676: ( log_level => FND_LOG.LEVEL_STATEMENT,
3677: module => l_module || l_progress,
3678: message => 'p_category = ' || p_category || ', lower_limit = ' ||
3679: x_lower_limit || ', higher_limit = ' || x_upper_limit

Line 3676: ( log_level => FND_LOG.LEVEL_STATEMENT,

3672:
3673: IF (g_fnd_debug = 'Y') THEN
3674: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3675: FND_LOG.string
3676: ( log_level => FND_LOG.LEVEL_STATEMENT,
3677: module => l_module || l_progress,
3678: message => 'p_category = ' || p_category || ', lower_limit = ' ||
3679: x_lower_limit || ', higher_limit = ' || x_upper_limit
3680: );

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

3681: END IF;
3682: END IF;
3683:
3684: IF (g_fnd_debug = 'Y') THEN
3685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3686: FND_LOG.string
3687: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3688: module => l_module || l_progress,
3689: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 3686: FND_LOG.string

3682: END IF;
3683:
3684: IF (g_fnd_debug = 'Y') THEN
3685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3686: FND_LOG.string
3687: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3688: module => l_module || l_progress,
3689: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3690: );

Line 3687: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3683:
3684: IF (g_fnd_debug = 'Y') THEN
3685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3686: FND_LOG.string
3687: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3688: module => l_module || l_progress,
3689: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3690: );
3691: END IF;

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

3741: ) IS
3742:
3743: l_api_name VARCHAR2(50) := 'summarize_reqs';
3744: l_progress VARCHAR2(3);
3745: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3746: G_MODULE_PREFIX || l_api_name || '.';
3747:
3748: l_range_inserted VARCHAR2(1);
3749: l_range_low NUMBER;

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

3753:
3754: l_progress := '000';
3755:
3756: IF (g_fnd_debug = 'Y') THEN
3757: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3758: FND_LOG.string
3759: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3760: module => l_module || l_progress,
3761: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 3758: FND_LOG.string

3754: l_progress := '000';
3755:
3756: IF (g_fnd_debug = 'Y') THEN
3757: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3758: FND_LOG.string
3759: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3760: module => l_module || l_progress,
3761: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3762: );

Line 3759: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3755:
3756: IF (g_fnd_debug = 'Y') THEN
3757: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3758: FND_LOG.string
3759: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3760: module => l_module || l_progress,
3761: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3762: );
3763: END IF;

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

3775: LOOP
3776: l_progress := '010';
3777:
3778: IF (g_fnd_debug = 'Y') THEN
3779: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3780: FND_LOG.string
3781: ( log_level => FND_LOG.LEVEL_STATEMENT,
3782: module => l_module || l_progress,
3783: message => 'range_low=' || l_range_low ||

Line 3780: FND_LOG.string

3776: l_progress := '010';
3777:
3778: IF (g_fnd_debug = 'Y') THEN
3779: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3780: FND_LOG.string
3781: ( log_level => FND_LOG.LEVEL_STATEMENT,
3782: module => l_module || l_progress,
3783: message => 'range_low=' || l_range_low ||
3784: ' range_high=' || l_range_high

Line 3781: ( log_level => FND_LOG.LEVEL_STATEMENT,

3777:
3778: IF (g_fnd_debug = 'Y') THEN
3779: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3780: FND_LOG.string
3781: ( log_level => FND_LOG.LEVEL_STATEMENT,
3782: module => l_module || l_progress,
3783: message => 'range_low=' || l_range_low ||
3784: ' range_high=' || l_range_high
3785: );

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

3814: END;
3815:
3816:
3817: IF (g_fnd_debug = 'Y') THEN
3818: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3819: FND_LOG.string
3820: ( log_level => FND_LOG.LEVEL_STATEMENT,
3821: module => l_module || l_progress,
3822: message => 'range inserted = ' || l_range_inserted

Line 3819: FND_LOG.string

3815:
3816:
3817: IF (g_fnd_debug = 'Y') THEN
3818: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3819: FND_LOG.string
3820: ( log_level => FND_LOG.LEVEL_STATEMENT,
3821: module => l_module || l_progress,
3822: message => 'range inserted = ' || l_range_inserted
3823: );

Line 3820: ( log_level => FND_LOG.LEVEL_STATEMENT,

3816:
3817: IF (g_fnd_debug = 'Y') THEN
3818: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3819: FND_LOG.string
3820: ( log_level => FND_LOG.LEVEL_STATEMENT,
3821: module => l_module || l_progress,
3822: message => 'range inserted = ' || l_range_inserted
3823: );
3824: END IF;

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

3884:
3885: END LOOP;
3886:
3887: IF (g_fnd_debug = 'Y') THEN
3888: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3889: FND_LOG.string
3890: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3891: module => l_module || l_progress,
3892: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 3889: FND_LOG.string

3885: END LOOP;
3886:
3887: IF (g_fnd_debug = 'Y') THEN
3888: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3889: FND_LOG.string
3890: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3891: module => l_module || l_progress,
3892: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3893: );

Line 3890: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3886:
3887: IF (g_fnd_debug = 'Y') THEN
3888: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3889: FND_LOG.string
3890: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3891: module => l_module || l_progress,
3892: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
3893: );
3894: END IF;

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

3944: ) IS
3945:
3946: l_api_name VARCHAR2(50) := 'summarize_pos';
3947: l_progress VARCHAR2(3);
3948: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3949: G_MODULE_PREFIX || l_api_name || '.';
3950:
3951: l_range_inserted VARCHAR2(1);
3952: l_range_low NUMBER;

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

3956:
3957: l_progress := '000';
3958:
3959: IF (g_fnd_debug = 'Y') THEN
3960: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3961: FND_LOG.string
3962: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3963: module => l_module || l_progress,
3964: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 3961: FND_LOG.string

3957: l_progress := '000';
3958:
3959: IF (g_fnd_debug = 'Y') THEN
3960: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3961: FND_LOG.string
3962: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3963: module => l_module || l_progress,
3964: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3965: );

Line 3962: ( log_level => FND_LOG.LEVEL_PROCEDURE,

3958:
3959: IF (g_fnd_debug = 'Y') THEN
3960: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3961: FND_LOG.string
3962: ( log_level => FND_LOG.LEVEL_PROCEDURE,
3963: module => l_module || l_progress,
3964: message => 'Entering ' || g_pkg_name || '.' || l_api_name
3965: );
3966: END IF;

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

3978: LOOP
3979: l_progress := '010';
3980:
3981: IF (g_fnd_debug = 'Y') THEN
3982: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3983: FND_LOG.string
3984: ( log_level => FND_LOG.LEVEL_STATEMENT,
3985: module => l_module || l_progress,
3986: message => 'range_low=' || l_range_low ||

Line 3983: FND_LOG.string

3979: l_progress := '010';
3980:
3981: IF (g_fnd_debug = 'Y') THEN
3982: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3983: FND_LOG.string
3984: ( log_level => FND_LOG.LEVEL_STATEMENT,
3985: module => l_module || l_progress,
3986: message => 'range_low=' || l_range_low ||
3987: ' range_high=' || l_range_high

Line 3984: ( log_level => FND_LOG.LEVEL_STATEMENT,

3980:
3981: IF (g_fnd_debug = 'Y') THEN
3982: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3983: FND_LOG.string
3984: ( log_level => FND_LOG.LEVEL_STATEMENT,
3985: module => l_module || l_progress,
3986: message => 'range_low=' || l_range_low ||
3987: ' range_high=' || l_range_high
3988: );

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

4017: END;
4018:
4019:
4020: IF (g_fnd_debug = 'Y') THEN
4021: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4022: FND_LOG.string
4023: ( log_level => FND_LOG.LEVEL_STATEMENT,
4024: module => l_module || l_progress,
4025: message => 'range inserted = ' || l_range_inserted

Line 4022: FND_LOG.string

4018:
4019:
4020: IF (g_fnd_debug = 'Y') THEN
4021: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4022: FND_LOG.string
4023: ( log_level => FND_LOG.LEVEL_STATEMENT,
4024: module => l_module || l_progress,
4025: message => 'range inserted = ' || l_range_inserted
4026: );

Line 4023: ( log_level => FND_LOG.LEVEL_STATEMENT,

4019:
4020: IF (g_fnd_debug = 'Y') THEN
4021: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4022: FND_LOG.string
4023: ( log_level => FND_LOG.LEVEL_STATEMENT,
4024: module => l_module || l_progress,
4025: message => 'range inserted = ' || l_range_inserted
4026: );
4027: END IF;

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

4094: PH.org_id; -- bug5446437
4095:
4096:
4097: IF (g_fnd_debug = 'Y') THEN
4098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4099: FND_LOG.string
4100: ( log_level => FND_LOG.LEVEL_STATEMENT,
4101: module => l_module || l_progress,
4102: message => 'Rows inserted for std/planned po/local bpa:' ||

Line 4099: FND_LOG.string

4095:
4096:
4097: IF (g_fnd_debug = 'Y') THEN
4098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4099: FND_LOG.string
4100: ( log_level => FND_LOG.LEVEL_STATEMENT,
4101: module => l_module || l_progress,
4102: message => 'Rows inserted for std/planned po/local bpa:' ||
4103: SQL%ROWCOUNT

Line 4100: ( log_level => FND_LOG.LEVEL_STATEMENT,

4096:
4097: IF (g_fnd_debug = 'Y') THEN
4098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4099: FND_LOG.string
4100: ( log_level => FND_LOG.LEVEL_STATEMENT,
4101: module => l_module || l_progress,
4102: message => 'Rows inserted for std/planned po/local bpa:' ||
4103: SQL%ROWCOUNT
4104: );

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

4168: PH.creation_date,
4169: PH.org_id; -- bug5446437
4170:
4171: IF (g_fnd_debug = 'Y') THEN
4172: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4173: FND_LOG.string
4174: ( log_level => FND_LOG.LEVEL_STATEMENT,
4175: module => l_module || l_progress,
4176: message => 'Rows inserted for gbpa:' || SQL%ROWCOUNT

Line 4173: FND_LOG.string

4169: PH.org_id; -- bug5446437
4170:
4171: IF (g_fnd_debug = 'Y') THEN
4172: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4173: FND_LOG.string
4174: ( log_level => FND_LOG.LEVEL_STATEMENT,
4175: module => l_module || l_progress,
4176: message => 'Rows inserted for gbpa:' || SQL%ROWCOUNT
4177: );

Line 4174: ( log_level => FND_LOG.LEVEL_STATEMENT,

4170:
4171: IF (g_fnd_debug = 'Y') THEN
4172: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4173: FND_LOG.string
4174: ( log_level => FND_LOG.LEVEL_STATEMENT,
4175: module => l_module || l_progress,
4176: message => 'Rows inserted for gbpa:' || SQL%ROWCOUNT
4177: );
4178: END IF;

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

4242: PH.creation_date,
4243: PH.org_id; -- bug5446437
4244:
4245: IF (g_fnd_debug = 'Y') THEN
4246: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4247: FND_LOG.string
4248: ( log_level => FND_LOG.LEVEL_STATEMENT,
4249: module => l_module || l_progress,
4250: message => 'Rows inserted for contracts:' || SQL%ROWCOUNT

Line 4247: FND_LOG.string

4243: PH.org_id; -- bug5446437
4244:
4245: IF (g_fnd_debug = 'Y') THEN
4246: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4247: FND_LOG.string
4248: ( log_level => FND_LOG.LEVEL_STATEMENT,
4249: module => l_module || l_progress,
4250: message => 'Rows inserted for contracts:' || SQL%ROWCOUNT
4251: );

Line 4248: ( log_level => FND_LOG.LEVEL_STATEMENT,

4244:
4245: IF (g_fnd_debug = 'Y') THEN
4246: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4247: FND_LOG.string
4248: ( log_level => FND_LOG.LEVEL_STATEMENT,
4249: module => l_module || l_progress,
4250: message => 'Rows inserted for contracts:' || SQL%ROWCOUNT
4251: );
4252: END IF;

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

4320: PH.creation_date,
4321: PH.org_id; -- bug5446437
4322:
4323: IF (g_fnd_debug = 'Y') THEN
4324: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4325: FND_LOG.string
4326: ( log_level => FND_LOG.LEVEL_STATEMENT,
4327: module => l_module || l_progress,
4328: message => 'Rows inserted for releases: ' || SQL%ROWCOUNT

Line 4325: FND_LOG.string

4321: PH.org_id; -- bug5446437
4322:
4323: IF (g_fnd_debug = 'Y') THEN
4324: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4325: FND_LOG.string
4326: ( log_level => FND_LOG.LEVEL_STATEMENT,
4327: module => l_module || l_progress,
4328: message => 'Rows inserted for releases: ' || SQL%ROWCOUNT
4329: );

Line 4326: ( log_level => FND_LOG.LEVEL_STATEMENT,

4322:
4323: IF (g_fnd_debug = 'Y') THEN
4324: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4325: FND_LOG.string
4326: ( log_level => FND_LOG.LEVEL_STATEMENT,
4327: module => l_module || l_progress,
4328: message => 'Rows inserted for releases: ' || SQL%ROWCOUNT
4329: );
4330: END IF;

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

4344:
4345: END LOOP;
4346:
4347: IF (g_fnd_debug = 'Y') THEN
4348: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4349: FND_LOG.string
4350: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4351: module => l_module || l_progress,
4352: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 4349: FND_LOG.string

4345: END LOOP;
4346:
4347: IF (g_fnd_debug = 'Y') THEN
4348: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4349: FND_LOG.string
4350: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4351: module => l_module || l_progress,
4352: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
4353: );

Line 4350: ( log_level => FND_LOG.LEVEL_PROCEDURE,

4346:
4347: IF (g_fnd_debug = 'Y') THEN
4348: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4349: FND_LOG.string
4350: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4351: module => l_module || l_progress,
4352: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
4353: );
4354: END IF;

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

4405:
4406: l_api_name VARCHAR2(50) := 'delete_reqs';
4407: l_progress VARCHAR2(3);
4408: l_return_status VARCHAR2(1);
4409: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
4410: G_MODULE_PREFIX || l_api_name || '.';
4411:
4412: l_range_low NUMBER;
4413: l_range_high NUMBER;

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

4416:
4417: l_progress := '000';
4418:
4419: IF (g_fnd_debug = 'Y') THEN
4420: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4421: FND_LOG.string
4422: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4423: module => l_module || l_progress,
4424: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 4421: FND_LOG.string

4417: l_progress := '000';
4418:
4419: IF (g_fnd_debug = 'Y') THEN
4420: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4421: FND_LOG.string
4422: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4423: module => l_module || l_progress,
4424: message => 'Entering ' || g_pkg_name || '.' || l_api_name
4425: );

Line 4422: ( log_level => FND_LOG.LEVEL_PROCEDURE,

4418:
4419: IF (g_fnd_debug = 'Y') THEN
4420: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4421: FND_LOG.string
4422: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4423: module => l_module || l_progress,
4424: message => 'Entering ' || g_pkg_name || '.' || l_api_name
4425: );
4426: END IF;

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

4459: l_range_high := l_ids_tbl(i+1);
4460: END IF;
4461:
4462: IF (g_fnd_debug = 'Y') THEN
4463: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4464: FND_LOG.string
4465: ( log_level => FND_LOG.LEVEL_STATEMENT,
4466: module => l_module || l_progress,
4467: message => 'range_low = ' || l_range_low ||

Line 4464: FND_LOG.string

4460: END IF;
4461:
4462: IF (g_fnd_debug = 'Y') THEN
4463: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4464: FND_LOG.string
4465: ( log_level => FND_LOG.LEVEL_STATEMENT,
4466: module => l_module || l_progress,
4467: message => 'range_low = ' || l_range_low ||
4468: ', range_high = ' || l_range_high

Line 4465: ( log_level => FND_LOG.LEVEL_STATEMENT,

4461:
4462: IF (g_fnd_debug = 'Y') THEN
4463: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4464: FND_LOG.string
4465: ( log_level => FND_LOG.LEVEL_STATEMENT,
4466: module => l_module || l_progress,
4467: message => 'range_low = ' || l_range_low ||
4468: ', range_high = ' || l_range_high
4469: );

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

4498: AND PPRL.requisition_header_id BETWEEN l_range_low
4499: AND l_range_high);
4500:
4501: IF (g_fnd_debug = 'Y') THEN
4502: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4503: FND_LOG.string
4504: ( log_level => FND_LOG.LEVEL_STATEMENT,
4505: module => l_module || l_progress,
4506: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from RH'

Line 4503: FND_LOG.string

4499: AND l_range_high);
4500:
4501: IF (g_fnd_debug = 'Y') THEN
4502: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4503: FND_LOG.string
4504: ( log_level => FND_LOG.LEVEL_STATEMENT,
4505: module => l_module || l_progress,
4506: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from RH'
4507: );

Line 4504: ( log_level => FND_LOG.LEVEL_STATEMENT,

4500:
4501: IF (g_fnd_debug = 'Y') THEN
4502: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4503: FND_LOG.string
4504: ( log_level => FND_LOG.LEVEL_STATEMENT,
4505: module => l_module || l_progress,
4506: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from RH'
4507: );
4508: END IF;

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

4525: AND PPRL.requisition_header_id BETWEEN l_range_low
4526: AND l_range_high);
4527:
4528: IF (g_fnd_debug = 'Y') THEN
4529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4530: FND_LOG.string
4531: ( log_level => FND_LOG.LEVEL_STATEMENT,
4532: module => l_module || l_progress,
4533: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from RD'

Line 4530: FND_LOG.string

4526: AND l_range_high);
4527:
4528: IF (g_fnd_debug = 'Y') THEN
4529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4530: FND_LOG.string
4531: ( log_level => FND_LOG.LEVEL_STATEMENT,
4532: module => l_module || l_progress,
4533: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from RD'
4534: );

Line 4531: ( log_level => FND_LOG.LEVEL_STATEMENT,

4527:
4528: IF (g_fnd_debug = 'Y') THEN
4529: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4530: FND_LOG.string
4531: ( log_level => FND_LOG.LEVEL_STATEMENT,
4532: module => l_module || l_progress,
4533: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from RD'
4534: );
4535: END IF;

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

4549: AND PPRL.requisition_header_id BETWEEN l_range_low
4550: AND l_range_high);
4551:
4552: IF (g_fnd_debug = 'Y') THEN
4553: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4554: FND_LOG.string
4555: ( log_level => FND_LOG.LEVEL_STATEMENT,
4556: module => l_module || l_progress,
4557: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from RL'

Line 4554: FND_LOG.string

4550: AND l_range_high);
4551:
4552: IF (g_fnd_debug = 'Y') THEN
4553: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4554: FND_LOG.string
4555: ( log_level => FND_LOG.LEVEL_STATEMENT,
4556: module => l_module || l_progress,
4557: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from RL'
4558: );

Line 4555: ( log_level => FND_LOG.LEVEL_STATEMENT,

4551:
4552: IF (g_fnd_debug = 'Y') THEN
4553: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4554: FND_LOG.string
4555: ( log_level => FND_LOG.LEVEL_STATEMENT,
4556: module => l_module || l_progress,
4557: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from RL'
4558: );
4559: END IF;

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

4572: AND PPRL.requisition_header_id BETWEEN l_range_low
4573: AND l_range_high);
4574:
4575: IF (g_fnd_debug = 'Y') THEN
4576: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4577: FND_LOG.string
4578: ( log_level => FND_LOG.LEVEL_STATEMENT,
4579: module => l_module || l_progress,
4580: message => 'Deleted ' || SQL%ROWCOUNT || ' rec frm act_history'

Line 4577: FND_LOG.string

4573: AND l_range_high);
4574:
4575: IF (g_fnd_debug = 'Y') THEN
4576: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4577: FND_LOG.string
4578: ( log_level => FND_LOG.LEVEL_STATEMENT,
4579: module => l_module || l_progress,
4580: message => 'Deleted ' || SQL%ROWCOUNT || ' rec frm act_history'
4581: );

Line 4578: ( log_level => FND_LOG.LEVEL_STATEMENT,

4574:
4575: IF (g_fnd_debug = 'Y') THEN
4576: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4577: FND_LOG.string
4578: ( log_level => FND_LOG.LEVEL_STATEMENT,
4579: module => l_module || l_progress,
4580: message => 'Deleted ' || SQL%ROWCOUNT || ' rec frm act_history'
4581: );
4582: END IF;

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

4594:
4595: END LOOP;
4596:
4597: IF (g_fnd_debug = 'Y') THEN
4598: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4599: FND_LOG.string
4600: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4601: module => l_module || l_progress,
4602: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 4599: FND_LOG.string

4595: END LOOP;
4596:
4597: IF (g_fnd_debug = 'Y') THEN
4598: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4599: FND_LOG.string
4600: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4601: module => l_module || l_progress,
4602: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
4603: );

Line 4600: ( log_level => FND_LOG.LEVEL_PROCEDURE,

4596:
4597: IF (g_fnd_debug = 'Y') THEN
4598: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4599: FND_LOG.string
4600: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4601: module => l_module || l_progress,
4602: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
4603: );
4604: END IF;

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

4661: --
4662:
4663: l_api_name VARCHAR2(50) := 'delete_pos';
4664: l_progress VARCHAR2(3);
4665: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
4666: G_MODULE_PREFIX || l_api_name || '.';
4667:
4668: -- bug3209532
4669: l_pos_dynamic_call VARCHAR2(2000);

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

4675:
4676: l_progress := '000';
4677:
4678: IF (g_fnd_debug = 'Y') THEN
4679: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4680: FND_LOG.string
4681: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4682: module => l_module || l_progress,
4683: message => 'Entering ' || g_pkg_name || '.' || l_api_name

Line 4680: FND_LOG.string

4676: l_progress := '000';
4677:
4678: IF (g_fnd_debug = 'Y') THEN
4679: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4680: FND_LOG.string
4681: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4682: module => l_module || l_progress,
4683: message => 'Entering ' || g_pkg_name || '.' || l_api_name
4684: );

Line 4681: ( log_level => FND_LOG.LEVEL_PROCEDURE,

4677:
4678: IF (g_fnd_debug = 'Y') THEN
4679: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
4680: FND_LOG.string
4681: ( log_level => FND_LOG.LEVEL_PROCEDURE,
4682: module => l_module || l_progress,
4683: message => 'Entering ' || g_pkg_name || '.' || l_api_name
4684: );
4685: END IF;

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

4720:
4721: l_progress := '015';
4722:
4723: IF (g_fnd_debug = 'Y') THEN
4724: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4725: FND_LOG.string
4726: ( log_level => FND_LOG.LEVEL_STATEMENT,
4727: module => l_module || l_progress,
4728: message => 'range_low = ' || l_range_low ||

Line 4725: FND_LOG.string

4721: l_progress := '015';
4722:
4723: IF (g_fnd_debug = 'Y') THEN
4724: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4725: FND_LOG.string
4726: ( log_level => FND_LOG.LEVEL_STATEMENT,
4727: module => l_module || l_progress,
4728: message => 'range_low = ' || l_range_low ||
4729: ', range_high = ' || l_range_high

Line 4726: ( log_level => FND_LOG.LEVEL_STATEMENT,

4722:
4723: IF (g_fnd_debug = 'Y') THEN
4724: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4725: FND_LOG.string
4726: ( log_level => FND_LOG.LEVEL_STATEMENT,
4727: module => l_module || l_progress,
4728: message => 'range_low = ' || l_range_low ||
4729: ', range_high = ' || l_range_high
4730: );

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

4760: BULK COLLECT INTO l_po_header_id_tbl, l_type_lookup_code_tbl;
4761: --
4762:
4763: IF (g_fnd_debug = 'Y') THEN
4764: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4765: FND_LOG.string
4766: ( log_level => FND_LOG.LEVEL_STATEMENT,
4767: module => l_module || l_progress,
4768: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PH'

Line 4765: FND_LOG.string

4761: --
4762:
4763: IF (g_fnd_debug = 'Y') THEN
4764: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4765: FND_LOG.string
4766: ( log_level => FND_LOG.LEVEL_STATEMENT,
4767: module => l_module || l_progress,
4768: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PH'
4769: );

Line 4766: ( log_level => FND_LOG.LEVEL_STATEMENT,

4762:
4763: IF (g_fnd_debug = 'Y') THEN
4764: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4765: FND_LOG.string
4766: ( log_level => FND_LOG.LEVEL_STATEMENT,
4767: module => l_module || l_progress,
4768: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PH'
4769: );
4770: END IF;

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

4783: AND PPL.po_header_id BETWEEN l_range_low
4784: AND l_range_high);
4785:
4786: IF (g_fnd_debug = 'Y') THEN
4787: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4788: FND_LOG.string
4789: ( log_level => FND_LOG.LEVEL_STATEMENT,
4790: module => l_module || l_progress,
4791: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PHA'

Line 4788: FND_LOG.string

4784: AND l_range_high);
4785:
4786: IF (g_fnd_debug = 'Y') THEN
4787: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4788: FND_LOG.string
4789: ( log_level => FND_LOG.LEVEL_STATEMENT,
4790: module => l_module || l_progress,
4791: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PHA'
4792: );

Line 4789: ( log_level => FND_LOG.LEVEL_STATEMENT,

4785:
4786: IF (g_fnd_debug = 'Y') THEN
4787: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4788: FND_LOG.string
4789: ( log_level => FND_LOG.LEVEL_STATEMENT,
4790: module => l_module || l_progress,
4791: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PHA'
4792: );
4793: END IF;

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

4806: AND PPL.po_header_id BETWEEN l_range_low
4807: AND l_range_high);
4808:
4809: IF (g_fnd_debug = 'Y') THEN
4810: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4811: FND_LOG.string
4812: ( log_level => FND_LOG.LEVEL_STATEMENT,
4813: module => l_module || l_progress,
4814: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PL'

Line 4811: FND_LOG.string

4807: AND l_range_high);
4808:
4809: IF (g_fnd_debug = 'Y') THEN
4810: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4811: FND_LOG.string
4812: ( log_level => FND_LOG.LEVEL_STATEMENT,
4813: module => l_module || l_progress,
4814: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PL'
4815: );

Line 4812: ( log_level => FND_LOG.LEVEL_STATEMENT,

4808:
4809: IF (g_fnd_debug = 'Y') THEN
4810: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4811: FND_LOG.string
4812: ( log_level => FND_LOG.LEVEL_STATEMENT,
4813: module => l_module || l_progress,
4814: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PL'
4815: );
4816: END IF;

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

4832: AND PPL.po_header_id BETWEEN l_range_low
4833: AND l_range_high);
4834:
4835: IF (g_fnd_debug = 'Y') THEN
4836: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4837: FND_LOG.string
4838: ( log_level => FND_LOG.LEVEL_STATEMENT,
4839: module => l_module || l_progress,
4840: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POATR'

Line 4837: FND_LOG.string

4833: AND l_range_high);
4834:
4835: IF (g_fnd_debug = 'Y') THEN
4836: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4837: FND_LOG.string
4838: ( log_level => FND_LOG.LEVEL_STATEMENT,
4839: module => l_module || l_progress,
4840: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POATR'
4841: );

Line 4838: ( log_level => FND_LOG.LEVEL_STATEMENT,

4834:
4835: IF (g_fnd_debug = 'Y') THEN
4836: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4837: FND_LOG.string
4838: ( log_level => FND_LOG.LEVEL_STATEMENT,
4839: module => l_module || l_progress,
4840: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POATR'
4841: );
4842: END IF;

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

4857: AND PPL.po_header_id BETWEEN l_range_low
4858: AND l_range_high);
4859:
4860: IF (g_fnd_debug = 'Y') THEN
4861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4862: FND_LOG.string
4863: ( log_level => FND_LOG.LEVEL_STATEMENT,
4864: module => l_module || l_progress,
4865: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POTLP'

Line 4862: FND_LOG.string

4858: AND l_range_high);
4859:
4860: IF (g_fnd_debug = 'Y') THEN
4861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4862: FND_LOG.string
4863: ( log_level => FND_LOG.LEVEL_STATEMENT,
4864: module => l_module || l_progress,
4865: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POTLP'
4866: );

Line 4863: ( log_level => FND_LOG.LEVEL_STATEMENT,

4859:
4860: IF (g_fnd_debug = 'Y') THEN
4861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4862: FND_LOG.string
4863: ( log_level => FND_LOG.LEVEL_STATEMENT,
4864: module => l_module || l_progress,
4865: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POTLP'
4866: );
4867: END IF;

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

4881: AND PPL.po_header_id BETWEEN l_range_low
4882: AND l_range_high);
4883:
4884: IF (g_fnd_debug = 'Y') THEN
4885: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4886: FND_LOG.string
4887: ( log_level => FND_LOG.LEVEL_STATEMENT,
4888: module => l_module || l_progress,
4889: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PLA'

Line 4886: FND_LOG.string

4882: AND l_range_high);
4883:
4884: IF (g_fnd_debug = 'Y') THEN
4885: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4886: FND_LOG.string
4887: ( log_level => FND_LOG.LEVEL_STATEMENT,
4888: module => l_module || l_progress,
4889: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PLA'
4890: );

Line 4887: ( log_level => FND_LOG.LEVEL_STATEMENT,

4883:
4884: IF (g_fnd_debug = 'Y') THEN
4885: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4886: FND_LOG.string
4887: ( log_level => FND_LOG.LEVEL_STATEMENT,
4888: module => l_module || l_progress,
4889: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PLA'
4890: );
4891: END IF;

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

4907: AND PPL.po_header_id BETWEEN l_range_low
4908: AND l_range_high);
4909:
4910: IF (g_fnd_debug = 'Y') THEN
4911: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4912: FND_LOG.string
4913: ( log_level => FND_LOG.LEVEL_STATEMENT,
4914: module => l_module || l_progress,
4915: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POATRA'

Line 4912: FND_LOG.string

4908: AND l_range_high);
4909:
4910: IF (g_fnd_debug = 'Y') THEN
4911: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4912: FND_LOG.string
4913: ( log_level => FND_LOG.LEVEL_STATEMENT,
4914: module => l_module || l_progress,
4915: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POATRA'
4916: );

Line 4913: ( log_level => FND_LOG.LEVEL_STATEMENT,

4909:
4910: IF (g_fnd_debug = 'Y') THEN
4911: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4912: FND_LOG.string
4913: ( log_level => FND_LOG.LEVEL_STATEMENT,
4914: module => l_module || l_progress,
4915: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POATRA'
4916: );
4917: END IF;

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

4932: AND PPL.po_header_id BETWEEN l_range_low
4933: AND l_range_high);
4934:
4935: IF (g_fnd_debug = 'Y') THEN
4936: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4937: FND_LOG.string
4938: ( log_level => FND_LOG.LEVEL_STATEMENT,
4939: module => l_module || l_progress,
4940: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POTLPA'

Line 4937: FND_LOG.string

4933: AND l_range_high);
4934:
4935: IF (g_fnd_debug = 'Y') THEN
4936: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4937: FND_LOG.string
4938: ( log_level => FND_LOG.LEVEL_STATEMENT,
4939: module => l_module || l_progress,
4940: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POTLPA'
4941: );

Line 4938: ( log_level => FND_LOG.LEVEL_STATEMENT,

4934:
4935: IF (g_fnd_debug = 'Y') THEN
4936: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4937: FND_LOG.string
4938: ( log_level => FND_LOG.LEVEL_STATEMENT,
4939: module => l_module || l_progress,
4940: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from POTLPA'
4941: );
4942: END IF;

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

4956: AND PPL.po_header_id BETWEEN l_range_low
4957: AND l_range_high);
4958:
4959: IF (g_fnd_debug = 'Y') THEN
4960: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4961: FND_LOG.string
4962: ( log_level => FND_LOG.LEVEL_STATEMENT,
4963: module => l_module || l_progress,
4964: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PLL'

Line 4961: FND_LOG.string

4957: AND l_range_high);
4958:
4959: IF (g_fnd_debug = 'Y') THEN
4960: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4961: FND_LOG.string
4962: ( log_level => FND_LOG.LEVEL_STATEMENT,
4963: module => l_module || l_progress,
4964: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PLL'
4965: );

Line 4962: ( log_level => FND_LOG.LEVEL_STATEMENT,

4958:
4959: IF (g_fnd_debug = 'Y') THEN
4960: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4961: FND_LOG.string
4962: ( log_level => FND_LOG.LEVEL_STATEMENT,
4963: module => l_module || l_progress,
4964: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PLL'
4965: );
4966: END IF;

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

4979: AND PPL.po_header_id BETWEEN l_range_low
4980: AND l_range_high);
4981:
4982: IF (g_fnd_debug = 'Y') THEN
4983: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4984: FND_LOG.string
4985: ( log_level => FND_LOG.LEVEL_STATEMENT,
4986: module => l_module || l_progress,
4987: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PLLA'

Line 4984: FND_LOG.string

4980: AND l_range_high);
4981:
4982: IF (g_fnd_debug = 'Y') THEN
4983: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4984: FND_LOG.string
4985: ( log_level => FND_LOG.LEVEL_STATEMENT,
4986: module => l_module || l_progress,
4987: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PLLA'
4988: );

Line 4985: ( log_level => FND_LOG.LEVEL_STATEMENT,

4981:
4982: IF (g_fnd_debug = 'Y') THEN
4983: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4984: FND_LOG.string
4985: ( log_level => FND_LOG.LEVEL_STATEMENT,
4986: module => l_module || l_progress,
4987: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PLLA'
4988: );
4989: END IF;

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

5002: AND PPL.po_header_id BETWEEN l_range_low
5003: AND l_range_high);
5004:
5005: IF (g_fnd_debug = 'Y') THEN
5006: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5007: FND_LOG.string
5008: ( log_level => FND_LOG.LEVEL_STATEMENT,
5009: module => l_module || l_progress,
5010: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PD'

Line 5007: FND_LOG.string

5003: AND l_range_high);
5004:
5005: IF (g_fnd_debug = 'Y') THEN
5006: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5007: FND_LOG.string
5008: ( log_level => FND_LOG.LEVEL_STATEMENT,
5009: module => l_module || l_progress,
5010: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PD'
5011: );

Line 5008: ( log_level => FND_LOG.LEVEL_STATEMENT,

5004:
5005: IF (g_fnd_debug = 'Y') THEN
5006: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5007: FND_LOG.string
5008: ( log_level => FND_LOG.LEVEL_STATEMENT,
5009: module => l_module || l_progress,
5010: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PD'
5011: );
5012: END IF;

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

5025: AND PPL.po_header_id BETWEEN l_range_low
5026: AND l_range_high);
5027:
5028: IF (g_fnd_debug = 'Y') THEN
5029: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5030: FND_LOG.string
5031: ( log_level => FND_LOG.LEVEL_STATEMENT,
5032: module => l_module || l_progress,
5033: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PDA'

Line 5030: FND_LOG.string

5026: AND l_range_high);
5027:
5028: IF (g_fnd_debug = 'Y') THEN
5029: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5030: FND_LOG.string
5031: ( log_level => FND_LOG.LEVEL_STATEMENT,
5032: module => l_module || l_progress,
5033: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PDA'
5034: );

Line 5031: ( log_level => FND_LOG.LEVEL_STATEMENT,

5027:
5028: IF (g_fnd_debug = 'Y') THEN
5029: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5030: FND_LOG.string
5031: ( log_level => FND_LOG.LEVEL_STATEMENT,
5032: module => l_module || l_progress,
5033: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PDA'
5034: );
5035: END IF;

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

5053: --
5054:
5055:
5056: IF (g_fnd_debug = 'Y') THEN
5057: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5058: FND_LOG.string
5059: ( log_level => FND_LOG.LEVEL_STATEMENT,
5060: module => l_module || l_progress,
5061: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PR'

Line 5058: FND_LOG.string

5054:
5055:
5056: IF (g_fnd_debug = 'Y') THEN
5057: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5058: FND_LOG.string
5059: ( log_level => FND_LOG.LEVEL_STATEMENT,
5060: module => l_module || l_progress,
5061: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PR'
5062: );

Line 5059: ( log_level => FND_LOG.LEVEL_STATEMENT,

5055:
5056: IF (g_fnd_debug = 'Y') THEN
5057: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5058: FND_LOG.string
5059: ( log_level => FND_LOG.LEVEL_STATEMENT,
5060: module => l_module || l_progress,
5061: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PR'
5062: );
5063: END IF;

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

5076: AND PPL.po_header_id BETWEEN l_range_low
5077: AND l_range_high);
5078:
5079: IF (g_fnd_debug = 'Y') THEN
5080: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5081: FND_LOG.string
5082: ( log_level => FND_LOG.LEVEL_STATEMENT,
5083: module => l_module || l_progress,
5084: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PRA'

Line 5081: FND_LOG.string

5077: AND l_range_high);
5078:
5079: IF (g_fnd_debug = 'Y') THEN
5080: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5081: FND_LOG.string
5082: ( log_level => FND_LOG.LEVEL_STATEMENT,
5083: module => l_module || l_progress,
5084: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PRA'
5085: );

Line 5082: ( log_level => FND_LOG.LEVEL_STATEMENT,

5078:
5079: IF (g_fnd_debug = 'Y') THEN
5080: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5081: FND_LOG.string
5082: ( log_level => FND_LOG.LEVEL_STATEMENT,
5083: module => l_module || l_progress,
5084: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from PRA'
5085: );
5086: END IF;

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

5099: AND PPL.po_header_id BETWEEN l_range_low
5100: AND l_range_high);
5101:
5102: IF (g_fnd_debug = 'Y') THEN
5103: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5104: FND_LOG.string
5105: ( log_level => FND_LOG.LEVEL_STATEMENT,
5106: module => l_module || l_progress,
5107: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from po_accept'

Line 5104: FND_LOG.string

5100: AND l_range_high);
5101:
5102: IF (g_fnd_debug = 'Y') THEN
5103: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5104: FND_LOG.string
5105: ( log_level => FND_LOG.LEVEL_STATEMENT,
5106: module => l_module || l_progress,
5107: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from po_accept'
5108: );

Line 5105: ( log_level => FND_LOG.LEVEL_STATEMENT,

5101:
5102: IF (g_fnd_debug = 'Y') THEN
5103: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5104: FND_LOG.string
5105: ( log_level => FND_LOG.LEVEL_STATEMENT,
5106: module => l_module || l_progress,
5107: message => 'Deleted ' || SQL%ROWCOUNT || ' rec from po_accept'
5108: );
5109: END IF;

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

5123: AND PPL.po_header_id BETWEEN l_range_low
5124: AND l_range_high);
5125:
5126: IF (g_fnd_debug = 'Y') THEN
5127: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5128: FND_LOG.string
5129: ( log_level => FND_LOG.LEVEL_STATEMENT,
5130: module => l_module || l_progress,
5131: message => 'Deleted ' || SQL%ROWCOUNT || ' rec frm act_history'

Line 5128: FND_LOG.string

5124: AND l_range_high);
5125:
5126: IF (g_fnd_debug = 'Y') THEN
5127: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5128: FND_LOG.string
5129: ( log_level => FND_LOG.LEVEL_STATEMENT,
5130: module => l_module || l_progress,
5131: message => 'Deleted ' || SQL%ROWCOUNT || ' rec frm act_history'
5132: );

Line 5129: ( log_level => FND_LOG.LEVEL_STATEMENT,

5125:
5126: IF (g_fnd_debug = 'Y') THEN
5127: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5128: FND_LOG.string
5129: ( log_level => FND_LOG.LEVEL_STATEMENT,
5130: module => l_module || l_progress,
5131: message => 'Deleted ' || SQL%ROWCOUNT || ' rec frm act_history'
5132: );
5133: END IF;

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

5151: AND PPL.po_header_id BETWEEN l_range_low
5152: AND l_range_high);
5153:
5154: IF (g_fnd_debug = 'Y') THEN
5155: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5156: FND_LOG.string
5157: ( log_level => FND_LOG.LEVEL_STATEMENT,
5158: module => l_module || l_progress,
5159: message => 'Null out DocRef on ' || SQL%ROWCOUNT || 'req lines'

Line 5156: FND_LOG.string

5152: AND l_range_high);
5153:
5154: IF (g_fnd_debug = 'Y') THEN
5155: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5156: FND_LOG.string
5157: ( log_level => FND_LOG.LEVEL_STATEMENT,
5158: module => l_module || l_progress,
5159: message => 'Null out DocRef on ' || SQL%ROWCOUNT || 'req lines'
5160: );

Line 5157: ( log_level => FND_LOG.LEVEL_STATEMENT,

5153:
5154: IF (g_fnd_debug = 'Y') THEN
5155: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5156: FND_LOG.string
5157: ( log_level => FND_LOG.LEVEL_STATEMENT,
5158: module => l_module || l_progress,
5159: message => 'Null out DocRef on ' || SQL%ROWCOUNT || 'req lines'
5160: );
5161: END IF;

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

5244: -- Do not hardcode schema name.
5245: -- GSCC checker parses POS as schema name even though it's text
5246: -- due to extra _. Modified message from _POS_. to POS API.
5247: IF (g_fnd_debug = 'Y') THEN
5248: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5249: FND_LOG.string
5250: ( log_level => FND_LOG.LEVEL_STATEMENT,
5251: module => l_module || l_progress,
5252: message => 'PO Code Level >= FPJ. Call POS API handle_purge only'

Line 5249: FND_LOG.string

5245: -- GSCC checker parses POS as schema name even though it's text
5246: -- due to extra _. Modified message from _POS_. to POS API.
5247: IF (g_fnd_debug = 'Y') THEN
5248: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5249: FND_LOG.string
5250: ( log_level => FND_LOG.LEVEL_STATEMENT,
5251: module => l_module || l_progress,
5252: message => 'PO Code Level >= FPJ. Call POS API handle_purge only'
5253: );

Line 5250: ( log_level => FND_LOG.LEVEL_STATEMENT,

5246: -- due to extra _. Modified message from _POS_. to POS API.
5247: IF (g_fnd_debug = 'Y') THEN
5248: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5249: FND_LOG.string
5250: ( log_level => FND_LOG.LEVEL_STATEMENT,
5251: module => l_module || l_progress,
5252: message => 'PO Code Level >= FPJ. Call POS API handle_purge only'
5253: );
5254: END IF;

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

5260: -- sql. If this dynamic sql is erroring out due to non-existence
5261: -- of the package, ignore the error.
5262:
5263: IF (g_fnd_debug = 'Y') THEN
5264: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5265: FND_LOG.string
5266: ( log_level => FND_LOG.LEVEL_STATEMENT,
5267: module => l_module || l_progress,
5268: message => 'Before calling POS Purge API'

Line 5265: FND_LOG.string

5261: -- of the package, ignore the error.
5262:
5263: IF (g_fnd_debug = 'Y') THEN
5264: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5265: FND_LOG.string
5266: ( log_level => FND_LOG.LEVEL_STATEMENT,
5267: module => l_module || l_progress,
5268: message => 'Before calling POS Purge API'
5269: );

Line 5266: ( log_level => FND_LOG.LEVEL_STATEMENT,

5262:
5263: IF (g_fnd_debug = 'Y') THEN
5264: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5265: FND_LOG.string
5266: ( log_level => FND_LOG.LEVEL_STATEMENT,
5267: module => l_module || l_progress,
5268: message => 'Before calling POS Purge API'
5269: );
5270: END IF;

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

5284: IF (SQLCODE = -6550) THEN
5285: l_return_status := FND_API.G_RET_STS_SUCCESS;
5286:
5287: IF (g_fnd_debug = 'Y') THEN
5288: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
5289: FND_LOG.string
5290: ( log_level => FND_LOG.LEVEL_PROCEDURE,
5291: module => l_module || l_progress,
5292: message => 'Ignore exception from POS call. SQLERRM: '||

Line 5289: FND_LOG.string

5285: l_return_status := FND_API.G_RET_STS_SUCCESS;
5286:
5287: IF (g_fnd_debug = 'Y') THEN
5288: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
5289: FND_LOG.string
5290: ( log_level => FND_LOG.LEVEL_PROCEDURE,
5291: module => l_module || l_progress,
5292: message => 'Ignore exception from POS call. SQLERRM: '||
5293: SQLERRM

Line 5290: ( log_level => FND_LOG.LEVEL_PROCEDURE,

5286:
5287: IF (g_fnd_debug = 'Y') THEN
5288: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
5289: FND_LOG.string
5290: ( log_level => FND_LOG.LEVEL_PROCEDURE,
5291: module => l_module || l_progress,
5292: message => 'Ignore exception from POS call. SQLERRM: '||
5293: SQLERRM
5294: );

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

5299: END IF;
5300: END;
5301:
5302: IF (g_fnd_debug = 'Y') THEN
5303: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5304: FND_LOG.string
5305: ( log_level => FND_LOG.LEVEL_STATEMENT,
5306: module => l_module || l_progress,
5307: message => 'After calling POS Purge API'

Line 5304: FND_LOG.string

5300: END;
5301:
5302: IF (g_fnd_debug = 'Y') THEN
5303: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5304: FND_LOG.string
5305: ( log_level => FND_LOG.LEVEL_STATEMENT,
5306: module => l_module || l_progress,
5307: message => 'After calling POS Purge API'
5308: );

Line 5305: ( log_level => FND_LOG.LEVEL_STATEMENT,

5301:
5302: IF (g_fnd_debug = 'Y') THEN
5303: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5304: FND_LOG.string
5305: ( log_level => FND_LOG.LEVEL_STATEMENT,
5306: module => l_module || l_progress,
5307: message => 'After calling POS Purge API'
5308: );
5309: END IF;

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

5317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5318: END IF;
5319:
5320: IF (g_fnd_debug = 'Y') THEN
5321: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
5322: FND_LOG.string
5323: ( log_level => FND_LOG.LEVEL_PROCEDURE,
5324: module => l_module || l_progress,
5325: message => 'Quitting ' || g_pkg_name || '.' || l_api_name

Line 5322: FND_LOG.string

5318: END IF;
5319:
5320: IF (g_fnd_debug = 'Y') THEN
5321: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
5322: FND_LOG.string
5323: ( log_level => FND_LOG.LEVEL_PROCEDURE,
5324: module => l_module || l_progress,
5325: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
5326: );

Line 5323: ( log_level => FND_LOG.LEVEL_PROCEDURE,

5319:
5320: IF (g_fnd_debug = 'Y') THEN
5321: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
5322: FND_LOG.string
5323: ( log_level => FND_LOG.LEVEL_PROCEDURE,
5324: module => l_module || l_progress,
5325: message => 'Quitting ' || g_pkg_name || '.' || l_api_name
5326: );
5327: END IF;

Line 5352: -- Dump all the messages from message stack to FND_LOG

5348: --Modifies:
5349: --Locks:
5350: -- None
5351: --Function:
5352: -- Dump all the messages from message stack to FND_LOG
5353: --Parameters:
5354: --IN:
5355: --p_module
5356: -- Place where this procedure is called

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

5369: IF (g_fnd_debug = 'Y') THEN
5370: FND_MSG_PUB.reset;
5371:
5372: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
5373: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5374: FND_LOG.string
5375: ( log_level => FND_LOG.LEVEL_STATEMENT,
5376: module => p_module,
5377: message => 'DUMPMSG: ' ||

Line 5374: FND_LOG.string

5370: FND_MSG_PUB.reset;
5371:
5372: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
5373: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5374: FND_LOG.string
5375: ( log_level => FND_LOG.LEVEL_STATEMENT,
5376: module => p_module,
5377: message => 'DUMPMSG: ' ||
5378: FND_MSG_PUB.get

Line 5375: ( log_level => FND_LOG.LEVEL_STATEMENT,

5371:
5372: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
5373: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5374: FND_LOG.string
5375: ( log_level => FND_LOG.LEVEL_STATEMENT,
5376: module => p_module,
5377: message => 'DUMPMSG: ' ||
5378: FND_MSG_PUB.get
5379: ( p_msg_index => i,