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_DOCUMENT_CONTROL_PVT dependencies on FND_LOG

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

45: x_return_status := FND_API.g_ret_sts_success;
46: -- End standard API initialization
47:
48: IF (g_debug_stmt) THEN
49: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
50: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
51: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
52: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
53: END IF;

Line 50: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

46: -- End standard API initialization
47:
48: IF (g_debug_stmt) THEN
49: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
50: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
51: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
52: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
53: END IF;
54: END IF;

Line 80: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

76: -- This document type is not supported
77: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
78: FND_MESSAGE.set_token('TYPE',p_doc_type);
79: IF (g_debug_stmt) THEN
80: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
81: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name
82: || '.invalid_doc_type', FALSE);
83: END IF;
84: END IF;

Line 81: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name

77: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
78: FND_MESSAGE.set_token('TYPE',p_doc_type);
79: IF (g_debug_stmt) THEN
80: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
81: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name
82: || '.invalid_doc_type', FALSE);
83: END IF;
84: END IF;
85: FND_MSG_PUB.add;

Line 101: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

97: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
98: x_return_status := FND_API.g_ret_sts_error;
99: FND_MESSAGE.set_name('PO','PO_CONTROL_LOCK_FAILED');
100: IF (g_debug_stmt) THEN
101: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
102: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
103: '.lock_failed', FALSE);
104: END IF;
105: END IF;

Line 102: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

98: x_return_status := FND_API.g_ret_sts_error;
99: FND_MESSAGE.set_name('PO','PO_CONTROL_LOCK_FAILED');
100: IF (g_debug_stmt) THEN
101: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
102: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
103: '.lock_failed', FALSE);
104: END IF;
105: END IF;
106: FND_MSG_PUB.add;

Line 115: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

111: WHEN OTHERS THEN
112: x_return_status := FND_API.g_ret_sts_unexp_error;
113: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
114: IF (g_debug_unexp) THEN
115: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
116: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
117: l_api_name || '.others_exception', 'Exception');
118: END IF;
119: END IF;

Line 116: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

112: x_return_status := FND_API.g_ret_sts_unexp_error;
113: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
114: IF (g_debug_unexp) THEN
115: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
116: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
117: l_api_name || '.others_exception', 'Exception');
118: END IF;
119: END IF;
120: END lock_doc_row;

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

186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188:
189: IF g_debug_stmt THEN
190: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
191: PO_DEBUG.debug_begin(d_module);
192: PO_DEBUG.debug_var(d_module, l_progress, 'p_doc_type', p_doc_type);
193: PO_DEBUG.debug_var(d_module, l_progress, 'p_doc_subtype', p_doc_subtype);
194: PO_DEBUG.debug_var(d_module, l_progress, 'p_doc_id', p_doc_id);

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

206:
207: END IF ;
208:
209: IF g_debug_stmt THEN
210: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
211: PO_DEBUG.debug_var(d_module, l_progress, 'l_check_asl', l_check_asl);
212: END IF;
213: END IF;
214:

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

240: RAISE;
241: END;
242:
243: IF g_debug_stmt THEN
244: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
245: PO_DEBUG.debug_var(d_module, l_progress, 'l_auth_status', l_auth_status);
246: END IF;
247: END IF;
248:

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

269: RAISE FND_API.g_exc_unexpected_error;
270: END IF;
271:
272: IF g_debug_stmt THEN
273: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
274: PO_DEBUG.debug_var(d_module, l_progress, 'l_online_report_id', l_online_report_id);
275: PO_DEBUG.debug_var(d_module, l_progress, 'l_sub_check_status', l_sub_check_status);
276: PO_DEBUG.debug_var(d_module, l_progress, 'x_exception_msg', x_exception_msg);
277: END IF;

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

469: RAISE FND_API.g_exc_unexpected_error;
470: END IF;
471:
472: IF g_debug_stmt THEN
473: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
474: PO_DEBUG.debug_begin(d_module);
475: PO_DEBUG.debug_var(d_module, l_progress, 'p_commit', p_commit);
476: PO_DEBUG.debug_var(d_module, l_progress, 'p_doc_type', p_doc_type);
477: PO_DEBUG.debug_var(d_module, l_progress, 'p_doc_subtype', p_doc_subtype);

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

534: RAISE;
535: END;
536:
537: IF g_debug_stmt THEN
538: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
539: PO_DEBUG.debug_var(d_module, l_progress, 'l_old_auth_status', l_old_auth_status);
540: END IF;
541: END IF;
542:

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

585:
586:
587:
588: IF g_debug_stmt THEN
589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
590: PO_DEBUG.debug_var(d_module,l_progress,'l_return_code',l_return_code);
591: PO_DEBUG.debug_var(d_module,l_progress,'x_return_status',x_return_status);
592: PO_DEBUG.debug_var(d_module,l_progress,'p_online_report_id',p_online_report_id);
593: END IF;

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

674: FND_MESSAGE.set_name('PO','PO_CONTROL_INVALID_ACTION');
675: FND_MESSAGE.set_token('ACTION',p_action);
676:
677: IF g_debug_stmt THEN
678: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
679: PO_DEBUG.debug_stmt(d_module,l_progress,'invalid_action');
680: END IF;
681: END IF;
682:

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

685:
686: END IF; --
687:
688: IF g_debug_stmt THEN
689: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
690: PO_DEBUG.debug_stmt(d_module,l_progress,'Before PO_DELREC_PVT.create_update_delrec Call');
691: END IF;
692: END IF;
693:

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

705: p_line_id => p_doc_line_id,
706: p_line_location_id => p_doc_line_loc_id);
707:
708: IF g_debug_stmt THEN
709: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
710: PO_DEBUG.debug_stmt(d_module,l_progress,'After PO_DELREC_PVT.create_update_delrec Call');
711: PO_DEBUG.debug_var(d_module,l_progress,'x_return_status',x_return_status);
712: END IF;
713:

Line 738: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

734: ROLLBACK TO control_document_PVT;
735: x_return_status := FND_API.g_ret_sts_unexp_error;
736: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
737: IF (g_debug_unexp) THEN
738: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
739: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
740: l_api_name || '.others_exception', 'Exception');
741: END IF;
742: END IF;

Line 739: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

735: x_return_status := FND_API.g_ret_sts_unexp_error;
736: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
737: IF (g_debug_unexp) THEN
738: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
739: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
740: l_api_name || '.others_exception', 'Exception');
741: END IF;
742: END IF;
743: END control_document;

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

787: x_return_status := FND_API.g_ret_sts_success;
788: -- End standard API initialization
789:
790: IF (g_debug_stmt) THEN
791: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
792: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
793: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
794: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
795: END IF;

Line 792: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

788: -- End standard API initialization
789:
790: IF (g_debug_stmt) THEN
791: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
792: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
793: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
794: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
795: END IF;
796: END IF;

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

810: RAISE FND_API.g_exc_unexpected_error;
811: END IF;
812:
813: IF (g_debug_stmt) THEN
814: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
815: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix || l_api_name ||
816: '.is_cbc_enabled', 'Is CBC enabled: ' ||
817: NVL(x_cbc_enabled,'N'));
818: END IF;

Line 815: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix || l_api_name ||

811: END IF;
812:
813: IF (g_debug_stmt) THEN
814: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
815: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix || l_api_name ||
816: '.is_cbc_enabled', 'Is CBC enabled: ' ||
817: NVL(x_cbc_enabled,'N'));
818: END IF;
819: END IF;

Line 853: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

849: WHEN OTHERS THEN
850: x_return_status := FND_API.g_ret_sts_unexp_error;
851: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
852: IF (g_debug_unexp) THEN
853: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
854: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
855: l_api_name || '.others_exception', 'Exception');
856: END IF;
857: END IF;

Line 854: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

850: x_return_status := FND_API.g_ret_sts_unexp_error;
851: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
852: IF (g_debug_unexp) THEN
853: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
854: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
855: l_api_name || '.others_exception', 'Exception');
856: END IF;
857: END IF;
858: END init_action_date;

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

901: x_return_status := FND_API.g_ret_sts_success;
902: -- End standard API initialization
903:
904: IF (g_debug_stmt) THEN
905: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
906: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
907: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
908: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
909: END IF;

Line 906: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

902: -- End standard API initialization
903:
904: IF (g_debug_stmt) THEN
905: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
906: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
907: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
908: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
909: END IF;
910: END IF;

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

914:
915: IF (p_cbc_enabled = 'Y') THEN
916:
917: IF (g_debug_stmt) THEN
918: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix||l_api_name
920: ||'.get_cbc_date', 'IGC_CBC_PO_GRP.get_cbc_acct_date');
921: END IF;
922: END IF;

Line 919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix||l_api_name

915: IF (p_cbc_enabled = 'Y') THEN
916:
917: IF (g_debug_stmt) THEN
918: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix||l_api_name
920: ||'.get_cbc_date', 'IGC_CBC_PO_GRP.get_cbc_acct_date');
921: END IF;
922: END IF;
923:

Line 962: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

958: WHEN OTHERS THEN
959: x_return_status := FND_API.g_ret_sts_unexp_error;
960: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
961: IF (g_debug_unexp) THEN
962: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
963: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
964: l_api_name || '.others_exception', 'Exception');
965: END IF;
966: END IF;

Line 963: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

959: x_return_status := FND_API.g_ret_sts_unexp_error;
960: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
961: IF (g_debug_unexp) THEN
962: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
963: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
964: l_api_name || '.others_exception', 'Exception');
965: END IF;
966: END IF;
967: END get_action_date;

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

1013: x_return_status := FND_API.g_ret_sts_success;
1014: -- End standard API initialization
1015:
1016: IF (g_debug_stmt) THEN
1017: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1018: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1019: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
1020: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null') ||
1021: ', Date: ' || NVL(TO_CHAR(p_action_date,'DD-MON-RR'),'null'));

Line 1018: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

1014: -- End standard API initialization
1015:
1016: IF (g_debug_stmt) THEN
1017: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1018: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1019: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
1020: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null') ||
1021: ', Date: ' || NVL(TO_CHAR(p_action_date,'DD-MON-RR'),'null'));
1022: END IF;

Line 1045: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

1041: FND_MESSAGE.set_name('PO','PO_INV_CR_INVALID_GL_PERIOD');
1042: FND_MESSAGE.set_token('GL_DATE',
1043: TO_CHAR(p_action_date,'DD-MON-YYYY'));
1044: IF (g_debug_stmt) THEN
1045: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1046: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
1047: l_api_name || '.gl_period', FALSE);
1048: END IF;
1049: END IF;

Line 1046: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||

1042: FND_MESSAGE.set_token('GL_DATE',
1043: TO_CHAR(p_action_date,'DD-MON-YYYY'));
1044: IF (g_debug_stmt) THEN
1045: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1046: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
1047: l_api_name || '.gl_period', FALSE);
1048: END IF;
1049: END IF;
1050: FND_MSG_PUB.add;

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

1066: -- Validate with CBC accounting date if enabled for cancel or finally close
1067: IF (p_cbc_enabled = 'Y') AND (p_action IN ('CANCEL','FINALLY CLOSE')) THEN
1068:
1069: IF (g_debug_stmt) THEN
1070: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1071: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix||l_api_name
1072: || '.val_cbc_date', 'IGC_CBC_PO_GRP.valid_cbc_acct_date');
1073: END IF;
1074: END IF;

Line 1071: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix||l_api_name

1067: IF (p_cbc_enabled = 'Y') AND (p_action IN ('CANCEL','FINALLY CLOSE')) THEN
1068:
1069: IF (g_debug_stmt) THEN
1070: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1071: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix||l_api_name
1072: || '.val_cbc_date', 'IGC_CBC_PO_GRP.valid_cbc_acct_date');
1073: END IF;
1074: END IF;
1075:

Line 1106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1102: WHEN OTHERS THEN
1103: x_return_status := FND_API.g_ret_sts_unexp_error;
1104: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1105: IF (g_debug_unexp) THEN
1106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1107: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1108: l_api_name || '.others_exception', 'Exception');
1109: END IF;
1110: END IF;

Line 1107: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

1103: x_return_status := FND_API.g_ret_sts_unexp_error;
1104: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1105: IF (g_debug_unexp) THEN
1106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1107: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1108: l_api_name || '.others_exception', 'Exception');
1109: END IF;
1110: END IF;
1111: END val_action_date;

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

1288: --< Bug 3194665 > Removed unnecessary std api work
1289: x_return_status := FND_API.g_ret_sts_success;
1290:
1291: IF (g_debug_stmt) THEN
1292: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1293: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1294: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
1295: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
1296: END IF;

Line 1293: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

1289: x_return_status := FND_API.g_ret_sts_success;
1290:
1291: IF (g_debug_stmt) THEN
1292: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1293: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1294: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
1295: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
1296: END IF;
1297: END IF;

Line 1308: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

1304:
1305: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1306: -- No data found, so just return error status without a msg
1307: IF (g_debug_stmt) THEN
1308: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1309: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1310: '.no_data_found', FALSE);
1311: END IF;
1312: END IF;

Line 1309: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

1305: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1306: -- No data found, so just return error status without a msg
1307: IF (g_debug_stmt) THEN
1308: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1309: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1310: '.no_data_found', FALSE);
1311: END IF;
1312: END IF;
1313: x_return_status := FND_API.g_ret_sts_error;

Line 1327: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1323: CLOSE l_get_actions_csr;
1324: END IF;
1325: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1326: IF (g_debug_unexp) THEN
1327: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1328: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1329: l_api_name || '.others_exception', 'Exception');
1330: END IF;
1331: END IF;

Line 1328: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

1324: END IF;
1325: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1326: IF (g_debug_unexp) THEN
1327: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1328: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1329: l_api_name || '.others_exception', 'Exception');
1330: END IF;
1331: END IF;
1332: END get_header_actions;

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

1486: --< Bug 3194665 > Removed unnecessary std api work
1487: x_return_status := FND_API.g_ret_sts_success;
1488:
1489: IF (g_debug_stmt) THEN
1490: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1491: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1492: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
1493: ', Line ID: ' || NVL(TO_CHAR(p_doc_line_id),'null'));
1494: END IF;

Line 1491: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

1487: x_return_status := FND_API.g_ret_sts_success;
1488:
1489: IF (g_debug_stmt) THEN
1490: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1491: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1492: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
1493: ', Line ID: ' || NVL(TO_CHAR(p_doc_line_id),'null'));
1494: END IF;
1495: END IF;

Line 1506: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

1502:
1503: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1504: -- No data found, so just return error status without a msg
1505: IF (g_debug_stmt) THEN
1506: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1507: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1508: '.get_failed', FALSE);
1509: END IF;
1510: END IF;

Line 1507: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

1503: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1504: -- No data found, so just return error status without a msg
1505: IF (g_debug_stmt) THEN
1506: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1507: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1508: '.get_failed', FALSE);
1509: END IF;
1510: END IF;
1511: x_return_status := FND_API.g_ret_sts_error;

Line 1526: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1522: CLOSE l_get_actions_csr;
1523: END IF;
1524: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1525: IF (g_debug_unexp) THEN
1526: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1527: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1528: l_api_name || '.others_exception', 'Exception');
1529: END IF;
1530: END IF;

Line 1527: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

1523: END IF;
1524: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1525: IF (g_debug_unexp) THEN
1526: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1527: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1528: l_api_name || '.others_exception', 'Exception');
1529: END IF;
1530: END IF;
1531: END get_line_actions;

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

1707: --< Bug 3194665 > Removed unnecessary std api work
1708: x_return_status := FND_API.g_ret_sts_success;
1709:
1710: IF (g_debug_stmt) THEN
1711: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1712: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1713: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
1714: ', Subtype: ' || NVL(p_doc_subtype,'null') ||
1715: ', Line Loc ID: ' || NVL(TO_CHAR(p_doc_line_loc_id),'null'));

Line 1712: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

1708: x_return_status := FND_API.g_ret_sts_success;
1709:
1710: IF (g_debug_stmt) THEN
1711: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1712: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1713: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
1714: ', Subtype: ' || NVL(p_doc_subtype,'null') ||
1715: ', Line Loc ID: ' || NVL(TO_CHAR(p_doc_line_loc_id),'null'));
1716: END IF;

Line 1728: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

1724:
1725: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1726: -- No data found, so just return error status without a msg
1727: IF (g_debug_stmt) THEN
1728: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1729: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1730: '.get_failed', FALSE);
1731: END IF;
1732: END IF;

Line 1729: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

1725: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1726: -- No data found, so just return error status without a msg
1727: IF (g_debug_stmt) THEN
1728: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1729: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1730: '.get_failed', FALSE);
1731: END IF;
1732: END IF;
1733: x_return_status := FND_API.g_ret_sts_error;

Line 1747: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1743: CLOSE l_get_actions_csr;
1744: END IF;
1745: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1746: IF (g_debug_unexp) THEN
1747: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1748: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1749: l_api_name || '.others_exception', 'Exception');
1750: END IF;
1751: END IF;

Line 1748: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

1744: END IF;
1745: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1746: IF (g_debug_unexp) THEN
1747: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1748: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1749: l_api_name || '.others_exception', 'Exception');
1750: END IF;
1751: END IF;
1752: END get_shipment_actions;

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

1908: --< Bug 3194665 > Removed unnecessary std api work
1909: x_return_status := FND_API.g_ret_sts_success;
1910:
1911: IF (g_debug_stmt) THEN
1912: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1913: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1914: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
1915: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
1916: END IF;

Line 1913: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

1909: x_return_status := FND_API.g_ret_sts_success;
1910:
1911: IF (g_debug_stmt) THEN
1912: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1913: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1914: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
1915: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
1916: END IF;
1917: END IF;

Line 1928: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

1924:
1925: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1926: -- No data found, so just return error status without a msg
1927: IF (g_debug_stmt) THEN
1928: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1929: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1930: '.get_failed', FALSE);
1931: END IF;
1932: END IF;

Line 1929: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

1925: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1926: -- No data found, so just return error status without a msg
1927: IF (g_debug_stmt) THEN
1928: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1929: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1930: '.get_failed', FALSE);
1931: END IF;
1932: END IF;
1933: x_return_status := FND_API.g_ret_sts_error;

Line 1947: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1943: CLOSE l_get_actions_csr;
1944: END IF;
1945: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1946: IF (g_debug_unexp) THEN
1947: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1948: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1949: l_api_name || '.others_exception', 'Exception');
1950: END IF;
1951: END IF;

Line 1948: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

1944: END IF;
1945: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1946: IF (g_debug_unexp) THEN
1947: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1948: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1949: l_api_name || '.others_exception', 'Exception');
1950: END IF;
1951: END IF;
1952: END get_rel_header_actions;

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

2078: --< Bug 3194665 > Removed unnecessary std api work
2079: x_return_status := FND_API.g_ret_sts_success;
2080:
2081: IF (g_debug_stmt) THEN
2082: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2083: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2084: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
2085: ', Line Loc ID: ' || NVL(TO_CHAR(p_doc_line_loc_id),'null'));
2086: END IF;

Line 2083: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

2079: x_return_status := FND_API.g_ret_sts_success;
2080:
2081: IF (g_debug_stmt) THEN
2082: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2083: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2084: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
2085: ', Line Loc ID: ' || NVL(TO_CHAR(p_doc_line_loc_id),'null'));
2086: END IF;
2087: END IF;

Line 2098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

2094:
2095: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
2096: -- No data found, so just return error status without a msg
2097: IF (g_debug_stmt) THEN
2098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2099: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2100: '.get_failed', FALSE);
2101: END IF;
2102: END IF;

Line 2099: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

2095: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
2096: -- No data found, so just return error status without a msg
2097: IF (g_debug_stmt) THEN
2098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2099: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2100: '.get_failed', FALSE);
2101: END IF;
2102: END IF;
2103: x_return_status := FND_API.g_ret_sts_error;

Line 2117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

2113: CLOSE l_get_actions_csr;
2114: END IF;
2115: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2116: IF (g_debug_unexp) THEN
2117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2118: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2119: l_api_name || '.others_exception', 'Exception');
2120: END IF;
2121: END IF;

Line 2118: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

2114: END IF;
2115: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2116: IF (g_debug_unexp) THEN
2117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2118: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2119: l_api_name || '.others_exception', 'Exception');
2120: END IF;
2121: END IF;
2122: END get_rel_shipment_actions;

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

2185: x_return_status := FND_API.g_ret_sts_success;
2186: -- End standard API initialization
2187:
2188: IF (g_debug_stmt) THEN
2189: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2191: '.invoked', 'Action: ' || NVL(p_action,'null') ||
2192: ', Type: ' || NVL(p_doc_type,'null') ||
2193: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));

Line 2190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

2186: -- End standard API initialization
2187:
2188: IF (g_debug_stmt) THEN
2189: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2191: '.invoked', 'Action: ' || NVL(p_action,'null') ||
2192: ', Type: ' || NVL(p_doc_type,'null') ||
2193: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
2194: END IF;

Line 2257: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

2253: --< Bug 3194665 End >
2254: ELSE
2255: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2256: IF (g_debug_stmt) THEN
2257: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2258: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
2259: l_api_name || '.invalid_doc_ids', FALSE);
2260: END IF;
2261: END IF;

Line 2258: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||

2254: ELSE
2255: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2256: IF (g_debug_stmt) THEN
2257: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2258: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
2259: l_api_name || '.invalid_doc_ids', FALSE);
2260: END IF;
2261: END IF;
2262: FND_MSG_PUB.add;

Line 2317: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

2313: --< Bug 3194665 End >
2314: ELSE
2315: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2316: IF (g_debug_stmt) THEN
2317: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2318: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
2319: l_api_name || '.invalid_doc_ids', FALSE);
2320: END IF;
2321: END IF;

Line 2318: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||

2314: ELSE
2315: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2316: IF (g_debug_stmt) THEN
2317: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2318: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
2319: l_api_name || '.invalid_doc_ids', FALSE);
2320: END IF;
2321: END IF;
2322: FND_MSG_PUB.add;

Line 2331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

2327: -- This document type is not supported
2328: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
2329: FND_MESSAGE.set_token('TYPE',p_doc_type);
2330: IF (g_debug_stmt) THEN
2331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2332: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2333: '.invalid_doc_type', FALSE);
2334: END IF;
2335: END IF;

Line 2332: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

2328: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
2329: FND_MESSAGE.set_token('TYPE',p_doc_type);
2330: IF (g_debug_stmt) THEN
2331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2332: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2333: '.invalid_doc_type', FALSE);
2334: END IF;
2335: END IF;
2336: FND_MSG_PUB.add;

Line 2345: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

2341: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2342: FND_MESSAGE.set_name('PO','PO_CONTROL_INVALID_ACTION');
2343: FND_MESSAGE.set_token('ACTION',p_action);
2344: IF (g_debug_stmt) THEN
2345: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2346: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2347: '.get_action_failed', FALSE);
2348: END IF;
2349: END IF;

Line 2346: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

2342: FND_MESSAGE.set_name('PO','PO_CONTROL_INVALID_ACTION');
2343: FND_MESSAGE.set_token('ACTION',p_action);
2344: IF (g_debug_stmt) THEN
2345: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2346: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2347: '.get_action_failed', FALSE);
2348: END IF;
2349: END IF;
2350: FND_MSG_PUB.add;

Line 2371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

2367: IF NOT l_action_ok THEN
2368: FND_MESSAGE.set_name('PO','PO_CONTROL_INVALID_ACTION');
2369: FND_MESSAGE.set_token('ACTION',p_action);
2370: IF (g_debug_stmt) THEN
2371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2372: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2373: '.status_failed', FALSE);
2374: END IF;
2375: END IF;

Line 2372: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

2368: FND_MESSAGE.set_name('PO','PO_CONTROL_INVALID_ACTION');
2369: FND_MESSAGE.set_token('ACTION',p_action);
2370: IF (g_debug_stmt) THEN
2371: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2372: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2373: '.status_failed', FALSE);
2374: END IF;
2375: END IF;
2376: FND_MSG_PUB.add;

Line 2427: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

2423: WHEN OTHERS THEN
2424: x_return_status := FND_API.g_ret_sts_unexp_error;
2425: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2426: IF (g_debug_unexp) THEN
2427: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2428: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2429: l_api_name || '.others_exception', 'Exception');
2430: END IF;
2431: END IF;

Line 2428: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

2424: x_return_status := FND_API.g_ret_sts_unexp_error;
2425: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2426: IF (g_debug_unexp) THEN
2427: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2428: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2429: l_api_name || '.others_exception', 'Exception');
2430: END IF;
2431: END IF;
2432: END val_control_action;

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

2505: x_return_status := FND_API.g_ret_sts_success;
2506: -- End standard API initialization
2507:
2508: IF (g_debug_stmt) THEN
2509: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2511: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
2512: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
2513: END IF;

Line 2510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

2506: -- End standard API initialization
2507:
2508: IF (g_debug_stmt) THEN
2509: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2511: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
2512: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
2513: END IF;
2514: END IF;

Line 2521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

2517: FETCH l_po_wf_csr INTO l_wf_item_type, l_wf_item_key;
2518: IF l_po_wf_csr%NOTFOUND THEN
2519: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2520: IF (g_debug_stmt) THEN
2521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2522: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2523: '.invalid_doc_ids', FALSE);
2524: END IF;
2525: END IF;

Line 2522: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

2518: IF l_po_wf_csr%NOTFOUND THEN
2519: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2520: IF (g_debug_stmt) THEN
2521: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2522: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2523: '.invalid_doc_ids', FALSE);
2524: END IF;
2525: END IF;
2526: FND_MSG_PUB.add;

Line 2601: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

2597: CLOSE l_unapproved_releases_csr;
2598: END IF;
2599: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2600: IF (g_debug_unexp) THEN
2601: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2602: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2603: l_api_name || '.others_exception', 'Exception');
2604: END IF;
2605: END IF;

Line 2602: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

2598: END IF;
2599: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2600: IF (g_debug_unexp) THEN
2601: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2602: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2603: l_api_name || '.others_exception', 'Exception');
2604: END IF;
2605: END IF;
2606: END po_stop_wf_process;

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

2648: x_return_status := FND_API.g_ret_sts_success;
2649: -- End standard API initialization
2650:
2651: IF (g_debug_stmt) THEN
2652: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2653: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2654: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
2655: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
2656: END IF;

Line 2653: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

2649: -- End standard API initialization
2650:
2651: IF (g_debug_stmt) THEN
2652: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2653: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2654: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
2655: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
2656: END IF;
2657: END IF;

Line 2664: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

2660: FETCH l_rel_wf_csr INTO l_wf_item_type, l_wf_item_key;
2661: IF l_rel_wf_csr%NOTFOUND THEN
2662: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2663: IF (g_debug_stmt) THEN
2664: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2665: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2666: '.invalid_doc_ids', FALSE);
2667: END IF;
2668: END IF;

Line 2665: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

2661: IF l_rel_wf_csr%NOTFOUND THEN
2662: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2663: IF (g_debug_stmt) THEN
2664: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2665: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2666: '.invalid_doc_ids', FALSE);
2667: END IF;
2668: END IF;
2669: FND_MSG_PUB.add;

Line 2700: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

2696: CLOSE l_rel_wf_csr;
2697: END IF;
2698: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2699: IF (g_debug_unexp) THEN
2700: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2701: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2702: l_api_name || '.others_exception', 'Exception');
2703: END IF;
2704: END IF;

Line 2701: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

2697: END IF;
2698: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2699: IF (g_debug_unexp) THEN
2700: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2701: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2702: l_api_name || '.others_exception', 'Exception');
2703: END IF;
2704: END IF;
2705: END rel_stop_wf_process;

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

2740: x_return_status := FND_API.g_ret_sts_success;
2741: -- End standard API initialization
2742:
2743: IF (g_debug_stmt) THEN
2744: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2745: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2746: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null'));
2747: END IF;
2748: END IF;

Line 2745: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

2741: -- End standard API initialization
2742:
2743: IF (g_debug_stmt) THEN
2744: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2745: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2746: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null'));
2747: END IF;
2748: END IF;
2749:

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

2785:
2786: IF (x_request_id = 0) THEN
2787: -- The call to FND_REQUEST sets a message name on error
2788: IF (g_debug_stmt) THEN
2789: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2790: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2791: '.request_failed', FALSE);
2792: END IF;
2793: END IF;

Line 2790: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

2786: IF (x_request_id = 0) THEN
2787: -- The call to FND_REQUEST sets a message name on error
2788: IF (g_debug_stmt) THEN
2789: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2790: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2791: '.request_failed', FALSE);
2792: END IF;
2793: END IF;
2794: FND_MSG_PUB.add;

Line 2807: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

2803: WHEN OTHERS THEN
2804: x_return_status := FND_API.g_ret_sts_unexp_error;
2805: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2806: IF (g_debug_unexp) THEN
2807: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2808: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2809: l_api_name || '.others_exception', 'Exception');
2810: END IF;
2811: END IF;

Line 2808: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

2804: x_return_status := FND_API.g_ret_sts_unexp_error;
2805: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2806: IF (g_debug_unexp) THEN
2807: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2808: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2809: l_api_name || '.others_exception', 'Exception');
2810: END IF;
2811: END IF;
2812: END submit_po_print_request;

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

2848: x_return_status := FND_API.g_ret_sts_success;
2849: -- End standard API initialization
2850:
2851: IF (g_debug_stmt) THEN
2852: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2853: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2854: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null') ||
2855: ', Rel num: ' || NVL(p_rel_doc_num,'null'));
2856: END IF;

Line 2853: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

2849: -- End standard API initialization
2850:
2851: IF (g_debug_stmt) THEN
2852: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2853: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2854: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null') ||
2855: ', Rel num: ' || NVL(p_rel_doc_num,'null'));
2856: END IF;
2857: END IF;

Line 2899: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

2895:
2896: IF (x_request_id = 0) THEN
2897: -- The call to FND_REQUEST sets a message name on error
2898: IF (g_debug_stmt) THEN
2899: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2900: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2901: '.request_failed', FALSE);
2902: END IF;
2903: END IF;

Line 2900: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

2896: IF (x_request_id = 0) THEN
2897: -- The call to FND_REQUEST sets a message name on error
2898: IF (g_debug_stmt) THEN
2899: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2900: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2901: '.request_failed', FALSE);
2902: END IF;
2903: END IF;
2904: FND_MSG_PUB.add;

Line 2917: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

2913: WHEN OTHERS THEN
2914: x_return_status := FND_API.g_ret_sts_unexp_error;
2915: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2916: IF (g_debug_unexp) THEN
2917: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2918: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2919: l_api_name || '.others_exception', 'Exception');
2920: END IF;
2921: END IF;

Line 2918: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

2914: x_return_status := FND_API.g_ret_sts_unexp_error;
2915: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2916: IF (g_debug_unexp) THEN
2917: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2918: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2919: l_api_name || '.others_exception', 'Exception');
2920: END IF;
2921: END IF;
2922: END submit_rel_print_request;

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

2956: x_return_status := FND_API.g_ret_sts_success;
2957: -- End standard API initialization
2958:
2959: IF (g_debug_stmt) THEN
2960: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2961: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2962: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null'));
2963: END IF;
2964: END IF;

Line 2961: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

2957: -- End standard API initialization
2958:
2959: IF (g_debug_stmt) THEN
2960: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2961: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2962: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null'));
2963: END IF;
2964: END IF;
2965:

Line 3003: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

2999:
3000: IF (x_request_id = 0) THEN
3001: -- The call to FND_REQUEST sets a message name on error
3002: IF (g_debug_stmt) THEN
3003: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3004: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3005: '.request_failed', FALSE);
3006: END IF;
3007: END IF;

Line 3004: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

3000: IF (x_request_id = 0) THEN
3001: -- The call to FND_REQUEST sets a message name on error
3002: IF (g_debug_stmt) THEN
3003: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3004: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3005: '.request_failed', FALSE);
3006: END IF;
3007: END IF;
3008: FND_MSG_PUB.add;

Line 3021: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3017: WHEN OTHERS THEN
3018: x_return_status := FND_API.g_ret_sts_unexp_error;
3019: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3020: IF (g_debug_unexp) THEN
3021: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3022: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3023: l_api_name || '.others_exception', 'Exception');
3024: END IF;
3025: END IF;

Line 3022: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

3018: x_return_status := FND_API.g_ret_sts_unexp_error;
3019: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3020: IF (g_debug_unexp) THEN
3021: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3022: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3023: l_api_name || '.others_exception', 'Exception');
3024: END IF;
3025: END IF;
3026: END submit_req_print_request;

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

3066: x_return_status := FND_API.g_ret_sts_success;
3067: -- End standard API initialization
3068:
3069: IF (g_debug_stmt) THEN
3070: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3071: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3072: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3073: ', Doc num: ' || NVL(p_doc_num,'null') ||
3074: ', Rel num: ' || NVL(p_rel_doc_num,'null'));

Line 3071: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

3067: -- End standard API initialization
3068:
3069: IF (g_debug_stmt) THEN
3070: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3071: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3072: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3073: ', Doc num: ' || NVL(p_doc_num,'null') ||
3074: ', Rel num: ' || NVL(p_rel_doc_num,'null'));
3075: END IF;

Line 3114: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

3110: -- This document type is not supported
3111: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
3112: FND_MESSAGE.set_token('TYPE',p_doc_type);
3113: IF (g_debug_stmt) THEN
3114: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3115: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3116: '.invalid_doc_type', FALSE);
3117: END IF;
3118: END IF;

Line 3115: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

3111: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
3112: FND_MESSAGE.set_token('TYPE',p_doc_type);
3113: IF (g_debug_stmt) THEN
3114: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3115: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3116: '.invalid_doc_type', FALSE);
3117: END IF;
3118: END IF;
3119: FND_MSG_PUB.add;

Line 3132: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3128: WHEN OTHERS THEN
3129: x_return_status := FND_API.g_ret_sts_unexp_error;
3130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3131: IF (g_debug_unexp) THEN
3132: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3133: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3134: l_api_name || '.others_exception', 'Exception');
3135: END IF;
3136: END IF;

Line 3133: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

3129: x_return_status := FND_API.g_ret_sts_unexp_error;
3130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3131: IF (g_debug_unexp) THEN
3132: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3133: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3134: l_api_name || '.others_exception', 'Exception');
3135: END IF;
3136: END IF;
3137: END create_print_request;

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

3180: x_return_status := FND_API.g_ret_sts_success;
3181: -- End standard API initialization
3182:
3183: IF (g_debug_stmt) THEN
3184: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3185: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3186: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3187: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3188: END IF;

Line 3185: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

3181: -- End standard API initialization
3182:
3183: IF (g_debug_stmt) THEN
3184: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3185: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3186: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3187: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3188: END IF;
3189: END IF;

Line 3205: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

3201: -- Return error if no update was made.
3202: IF SQL%NOTFOUND THEN
3203: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3204: IF (g_debug_stmt) THEN
3205: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3206: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3207: '.invalid_document', FALSE);
3208: END IF;
3209: END IF;

Line 3206: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

3202: IF SQL%NOTFOUND THEN
3203: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3204: IF (g_debug_stmt) THEN
3205: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3206: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3207: '.invalid_document', FALSE);
3208: END IF;
3209: END IF;
3210: FND_MSG_PUB.add;

Line 3237: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

3233: -- Return error if no update was made.
3234: IF SQL%NOTFOUND THEN
3235: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3236: IF (g_debug_stmt) THEN
3237: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3238: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3239: '.invalid_document', FALSE);
3240: END IF;
3241: END IF;

Line 3238: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

3234: IF SQL%NOTFOUND THEN
3235: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3236: IF (g_debug_stmt) THEN
3237: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3238: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3239: '.invalid_document', FALSE);
3240: END IF;
3241: END IF;
3242: FND_MSG_PUB.add;

Line 3269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

3265: -- Return error if no update was made.
3266: IF SQL%NOTFOUND THEN
3267: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3268: IF (g_debug_stmt) THEN
3269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3270: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3271: '.invalid_document', FALSE);
3272: END IF;
3273: END IF;

Line 3270: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

3266: IF SQL%NOTFOUND THEN
3267: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3268: IF (g_debug_stmt) THEN
3269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3270: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3271: '.invalid_document', FALSE);
3272: END IF;
3273: END IF;
3274: FND_MSG_PUB.add;

Line 3293: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

3289: -- This document type is not supported
3290: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
3291: FND_MESSAGE.set_token('TYPE',p_doc_type);
3292: IF (g_debug_stmt) THEN
3293: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3294: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3295: '.invalid_doc_type', FALSE);
3296: END IF;
3297: END IF;

Line 3294: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||

3290: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
3291: FND_MESSAGE.set_token('TYPE',p_doc_type);
3292: IF (g_debug_stmt) THEN
3293: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3294: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3295: '.invalid_doc_type', FALSE);
3296: END IF;
3297: END IF;
3298: FND_MSG_PUB.add;

Line 3319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3315: ROLLBACK TO update_note_to_vendor_PVT;
3316: x_return_status := FND_API.g_ret_sts_unexp_error;
3317: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3318: IF (g_debug_unexp) THEN
3319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3320: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3321: l_api_name || '.others_exception', 'Exception');
3322: END IF;
3323: END IF;

Line 3320: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

3316: x_return_status := FND_API.g_ret_sts_unexp_error;
3317: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3318: IF (g_debug_unexp) THEN
3319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3320: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3321: l_api_name || '.others_exception', 'Exception');
3322: END IF;
3323: END IF;
3324: END update_note_to_vendor;

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

3365: x_return_status := FND_API.g_ret_sts_success;
3366: -- End standard API initialization
3367:
3368: IF (g_debug_stmt) THEN
3369: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3370: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3371: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3372: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null') ||
3373: ', Agent: ' || NVL(TO_CHAR(p_agent_id),'null'));

Line 3370: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

3366: -- End standard API initialization
3367:
3368: IF (g_debug_stmt) THEN
3369: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3370: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3371: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3372: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null') ||
3373: ', Agent: ' || NVL(TO_CHAR(p_agent_id),'null'));
3374: END IF;

Line 3408: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3404: WHEN OTHERS THEN
3405: x_return_status := FND_API.g_ret_sts_unexp_error;
3406: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3407: IF (g_debug_unexp) THEN
3408: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3409: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3410: l_api_name || '.others_exception', 'Exception');
3411: END IF;
3412: END IF;

Line 3409: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

3405: x_return_status := FND_API.g_ret_sts_unexp_error;
3406: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3407: IF (g_debug_unexp) THEN
3408: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3409: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3410: l_api_name || '.others_exception', 'Exception');
3411: END IF;
3412: END IF;
3413: RETURN FALSE;

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

3474: x_return_status := FND_API.g_ret_sts_success;
3475: -- End standard API initialization
3476:
3477: IF (g_debug_stmt) THEN
3478: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3479: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3480: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3481: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3482: END IF;

Line 3479: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

3475: -- End standard API initialization
3476:
3477: IF (g_debug_stmt) THEN
3478: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3479: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3480: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3481: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3482: END IF;
3483: END IF;

Line 3524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3520: CLOSE l_has_rel_ship_csr;
3521: END IF;
3522: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3523: IF (g_debug_unexp) THEN
3524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3525: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3526: l_api_name || '.others_exception', 'Exception');
3527: END IF;
3528: END IF;

Line 3525: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

3521: END IF;
3522: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3523: IF (g_debug_unexp) THEN
3524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3525: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3526: l_api_name || '.others_exception', 'Exception');
3527: END IF;
3528: END IF;
3529: RETURN FALSE;

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

3570: x_return_status := FND_API.g_ret_sts_success;
3571: -- End standard API initialization
3572:
3573: IF (g_debug_stmt) THEN
3574: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3575: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3576: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3577: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3578: END IF;

Line 3575: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

3571: -- End standard API initialization
3572:
3573: IF (g_debug_stmt) THEN
3574: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3575: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3576: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3577: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3578: END IF;
3579: END IF;

Line 3606: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3602: WHEN OTHERS THEN
3603: x_return_status := FND_API.g_ret_sts_unexp_error;
3604: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3605: IF (g_debug_unexp) THEN
3606: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3607: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3608: l_api_name || '.others_exception', 'Exception');
3609: END IF;
3610: END IF;

Line 3607: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

3603: x_return_status := FND_API.g_ret_sts_unexp_error;
3604: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3605: IF (g_debug_unexp) THEN
3606: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3607: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3608: l_api_name || '.others_exception', 'Exception');
3609: END IF;
3610: END IF;
3611: RETURN FALSE;

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

3678: x_return_status := FND_API.g_ret_sts_success;
3679: -- End standard API initialization
3680:
3681: IF (g_debug_stmt) THEN
3682: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3683: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3684: '.invoked', 'Date: ' ||
3685: NVL(TO_CHAR(p_date,'DD-MON-RR'),'null'));
3686: END IF;

Line 3683: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

3679: -- End standard API initialization
3680:
3681: IF (g_debug_stmt) THEN
3682: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3683: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3684: '.invoked', 'Date: ' ||
3685: NVL(TO_CHAR(p_date,'DD-MON-RR'),'null'));
3686: END IF;
3687: END IF;

Line 3716: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3712: CLOSE l_gl_period_csr;
3713: END IF;
3714: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3715: IF (g_debug_unexp) THEN
3716: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3717: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3718: l_api_name || '.others_exception', 'Exception');
3719: END IF;
3720: END IF;

Line 3717: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

3713: END IF;
3714: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3715: IF (g_debug_unexp) THEN
3716: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3717: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3718: l_api_name || '.others_exception', 'Exception');
3719: END IF;
3720: END IF;
3721: RETURN FALSE;

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

3764: x_return_status := FND_API.g_ret_sts_success;
3765: -- End standard API initialization
3766:
3767: IF (g_debug_stmt) THEN
3768: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3769: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3770: '.invoked', 'Online report ID: ' ||
3771: NVL(TO_CHAR(p_online_report_id),'null'));
3772: END IF;

Line 3769: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

3765: -- End standard API initialization
3766:
3767: IF (g_debug_stmt) THEN
3768: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3769: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3770: '.invoked', 'Online report ID: ' ||
3771: NVL(TO_CHAR(p_online_report_id),'null'));
3772: END IF;
3773: END IF;

Line 3784: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

3780: -- The text_line column contains translated messages
3781: FND_MESSAGE.set_name('PO','PO_CUSTOM_MSG');
3782: FND_MESSAGE.set_token('TRANSLATED_TOKEN', l_text_line_tbl(i));
3783: IF (g_debug_stmt) THEN
3784: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3785: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
3786: l_api_name || '.msg', FALSE);
3787: END IF;
3788: END IF;

Line 3785: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||

3781: FND_MESSAGE.set_name('PO','PO_CUSTOM_MSG');
3782: FND_MESSAGE.set_token('TRANSLATED_TOKEN', l_text_line_tbl(i));
3783: IF (g_debug_stmt) THEN
3784: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3785: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
3786: l_api_name || '.msg', FALSE);
3787: END IF;
3788: END IF;
3789: FND_MSG_PUB.add;

Line 3807: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3803: WHEN OTHERS THEN
3804: x_return_status := FND_API.g_ret_sts_unexp_error;
3805: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3806: IF (g_debug_unexp) THEN
3807: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3808: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3809: l_api_name || '.others_exception', 'Exception');
3810: END IF;
3811: END IF;

Line 3808: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

3804: x_return_status := FND_API.g_ret_sts_unexp_error;
3805: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3806: IF (g_debug_unexp) THEN
3807: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3808: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3809: l_api_name || '.others_exception', 'Exception');
3810: END IF;
3811: END IF;
3812: END add_online_report_msgs;

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

5236: x_return_status := FND_API.G_RET_STS_SUCCESS;
5237:
5238:
5239: IF g_debug_stmt THEN
5240: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
5241: PO_DEBUG.debug_begin(d_module);
5242: PO_DEBUG.debug_var(d_module, l_progress, 'p_doc_type', p_doc_type);
5243: PO_DEBUG.debug_var(d_module, l_progress, 'p_doc_subtype', p_doc_subtype);
5244: PO_DEBUG.debug_var(d_module, l_progress, 'p_doc_id', p_doc_id);

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

5281:
5282: END IF;
5283:
5284: IF g_debug_stmt THEN
5285: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
5286: PO_DEBUG.debug_var(d_module,l_progress,'l_conterms_exist_flag',l_conterms_exist_flag);
5287: PO_DEBUG.debug_var(d_module,l_progress,'l_auth_status',l_auth_status);
5288: PO_DEBUG.debug_var(d_module,l_progress,'l_revision_num',l_revision_num);
5289: PO_DEBUG.debug_var(d_module,l_progress,'l_doc_type',l_doc_type);

Line 5344: AND (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

5340: p_email_address =>p_communication_method_value,
5341: p_request_id =>l_request_id);
5342:
5343: IF g_debug_stmt
5344: AND (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
5345: PO_DEBUG.debug_var(d_module,l_progress,'l_request_id',l_request_id);
5346: END IF;
5347: END IF;
5348: