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 274: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

270: g_cancel_flag_reset_flag := FALSE;
271: g_approval_initiated_flag := FALSE;
272: --
273: IF (g_debug_stmt) THEN
274: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
275: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
276: '.invoked', 'Source: ' || NVL(p_source,'null') ||
277: ', Action: ' || NVL(p_action,'null') ||
278: ', Type: ' || NVL(p_doc_type,'null') ||

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

271: g_approval_initiated_flag := FALSE;
272: --
273: IF (g_debug_stmt) THEN
274: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
275: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
276: '.invoked', 'Source: ' || NVL(p_source,'null') ||
277: ', Action: ' || NVL(p_action,'null') ||
278: ', Type: ' || NVL(p_doc_type,'null') ||
279: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));

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

299: THEN
300: FND_MESSAGE.set_name('PO','PO_CONTROL_SECURITY_FAILED');
301: FND_MESSAGE.set_token('DOCUMENT','document');
302: IF (g_debug_stmt) THEN
303: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
304: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
305: '.security_check_failed', FALSE);
306: END IF;
307: END IF;

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

300: FND_MESSAGE.set_name('PO','PO_CONTROL_SECURITY_FAILED');
301: FND_MESSAGE.set_token('DOCUMENT','document');
302: IF (g_debug_stmt) THEN
303: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
304: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
305: '.security_check_failed', FALSE);
306: END IF;
307: END IF;
308: FND_MSG_PUB.add;

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

587: -- Need to stop change request processes if there are any
588: IF (l_fetch_req_line_status = FND_API.g_ret_sts_success) THEN
589:
590: IF (g_debug_stmt) THEN
591: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
593: l_api_name || '.req_lines_fetched',
594: 'Num req lines fetched to process: ' ||
595: TO_CHAR(l_req_line_id_tbl.count));

Line 592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||

588: IF (l_fetch_req_line_status = FND_API.g_ret_sts_success) THEN
589:
590: IF (g_debug_stmt) THEN
591: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
593: l_api_name || '.req_lines_fetched',
594: 'Num req lines fetched to process: ' ||
595: TO_CHAR(l_req_line_id_tbl.count));
596: END IF;

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

621:
622: IF (p_doc_subtype <> 'CONTRACT') THEN
623:
624: IF (g_debug_stmt) THEN
625: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
626: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
627: l_api_name || '.cancel_change_request', 'Call');
628: END IF;
629: END IF;

Line 626: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||

622: IF (p_doc_subtype <> 'CONTRACT') THEN
623:
624: IF (g_debug_stmt) THEN
625: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
626: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
627: l_api_name || '.cancel_change_request', 'Call');
628: END IF;
629: END IF;
630:

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

797:
798: FND_MESSAGE.set_name('PO','PO_CONTROL_INVALID_ACTION');
799: FND_MESSAGE.set_token('ACTION',p_action);
800: IF (g_debug_stmt) THEN
801: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
802: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
803: '.invalid_action', FALSE);
804: END IF;
805: END IF;

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

798: FND_MESSAGE.set_name('PO','PO_CONTROL_INVALID_ACTION');
799: FND_MESSAGE.set_token('ACTION',p_action);
800: IF (g_debug_stmt) THEN
801: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
802: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
803: '.invalid_action', FALSE);
804: END IF;
805: END IF;
806: FND_MSG_PUB.add;

Line 848: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT) THEN

844:
845: FND_MESSAGE.set_name('PO','PO_APP_REQUEST_ID');
846: FND_MESSAGE.set_token('REQUEST_ID',TO_CHAR(l_request_id));
847: IF (g_debug_stmt) THEN
848: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT) THEN
849: FND_LOG.message(FND_LOG.level_event, g_module_prefix || l_api_name ||
850: '.print_request', FALSE);
851: END IF;
852: END IF;

Line 849: FND_LOG.message(FND_LOG.level_event, g_module_prefix || l_api_name ||

845: FND_MESSAGE.set_name('PO','PO_APP_REQUEST_ID');
846: FND_MESSAGE.set_token('REQUEST_ID',TO_CHAR(l_request_id));
847: IF (g_debug_stmt) THEN
848: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT) THEN
849: FND_LOG.message(FND_LOG.level_event, g_module_prefix || l_api_name ||
850: '.print_request', FALSE);
851: END IF;
852: END IF;
853: FND_MSG_PUB.add;

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

852: END IF;
853: FND_MSG_PUB.add;
854:
855: END IF; --
856: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
857: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
858: l_api_name, 'Before PO_DELREC_PVT.create_update_delrec Call');
859: END IF;
860: PO_DELREC_PVT.create_update_delrec(p_api_version => 1.0

Line 857: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||

853: FND_MSG_PUB.add;
854:
855: END IF; --
856: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
857: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
858: l_api_name, 'Before PO_DELREC_PVT.create_update_delrec Call');
859: END IF;
860: PO_DELREC_PVT.create_update_delrec(p_api_version => 1.0
861: ,x_return_status => x_return_status

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

867: ,p_doc_id => p_doc_id
868: ,p_line_id => p_doc_line_id
869: ,p_line_location_id => p_doc_line_loc_id);
870:
871: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
872: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
873: l_api_name, 'After PO_DELREC_PVT.create_update_delrec Call');
874: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
875: l_api_name, 'x_return_status'||x_return_status);

Line 872: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||

868: ,p_line_id => p_doc_line_id
869: ,p_line_location_id => p_doc_line_loc_id);
870:
871: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
872: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
873: l_api_name, 'After PO_DELREC_PVT.create_update_delrec Call');
874: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
875: l_api_name, 'x_return_status'||x_return_status);
876: END IF;

Line 874: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||

870:
871: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
872: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
873: l_api_name, 'After PO_DELREC_PVT.create_update_delrec Call');
874: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix ||
875: l_api_name, 'x_return_status'||x_return_status);
876: END IF;
877:
878: IF (x_return_status = FND_API.g_ret_sts_error) THEN

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

896: ROLLBACK TO control_document_PVT;
897: x_return_status := FND_API.g_ret_sts_unexp_error;
898: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
899: IF (g_debug_unexp) THEN
900: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
901: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
902: l_api_name || '.others_exception', 'Exception');
903: END IF;
904: END IF;

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

897: x_return_status := FND_API.g_ret_sts_unexp_error;
898: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
899: IF (g_debug_unexp) THEN
900: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
901: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
902: l_api_name || '.others_exception', 'Exception');
903: END IF;
904: END IF;
905: END control_document;

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

949: x_return_status := FND_API.g_ret_sts_success;
950: -- End standard API initialization
951:
952: IF (g_debug_stmt) THEN
953: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
954: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
955: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
956: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
957: END IF;

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

950: -- End standard API initialization
951:
952: IF (g_debug_stmt) THEN
953: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
954: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
955: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
956: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
957: END IF;
958: END IF;

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

972: RAISE FND_API.g_exc_unexpected_error;
973: END IF;
974:
975: IF (g_debug_stmt) THEN
976: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
977: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix || l_api_name ||
978: '.is_cbc_enabled', 'Is CBC enabled: ' ||
979: NVL(x_cbc_enabled,'N'));
980: END IF;

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

973: END IF;
974:
975: IF (g_debug_stmt) THEN
976: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
977: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_module_prefix || l_api_name ||
978: '.is_cbc_enabled', 'Is CBC enabled: ' ||
979: NVL(x_cbc_enabled,'N'));
980: END IF;
981: END IF;

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

1011: WHEN OTHERS THEN
1012: x_return_status := FND_API.g_ret_sts_unexp_error;
1013: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1014: IF (g_debug_unexp) THEN
1015: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1016: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1017: l_api_name || '.others_exception', 'Exception');
1018: END IF;
1019: END IF;

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

1012: x_return_status := FND_API.g_ret_sts_unexp_error;
1013: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1014: IF (g_debug_unexp) THEN
1015: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1016: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1017: l_api_name || '.others_exception', 'Exception');
1018: END IF;
1019: END IF;
1020: END init_action_date;

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

1063: x_return_status := FND_API.g_ret_sts_success;
1064: -- End standard API initialization
1065:
1066: IF (g_debug_stmt) THEN
1067: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1068: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1069: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
1070: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
1071: END IF;

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

1064: -- End standard API initialization
1065:
1066: IF (g_debug_stmt) THEN
1067: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1068: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1069: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
1070: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
1071: END IF;
1072: END IF;

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

1076:
1077: IF (p_cbc_enabled = 'Y') THEN
1078:
1079: IF (g_debug_stmt) THEN
1080: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1081: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix||l_api_name
1082: ||'.get_cbc_date', 'IGC_CBC_PO_GRP.get_cbc_acct_date');
1083: END IF;
1084: END IF;

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

1077: IF (p_cbc_enabled = 'Y') THEN
1078:
1079: IF (g_debug_stmt) THEN
1080: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1081: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix||l_api_name
1082: ||'.get_cbc_date', 'IGC_CBC_PO_GRP.get_cbc_acct_date');
1083: END IF;
1084: END IF;
1085:

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

1120: WHEN OTHERS THEN
1121: x_return_status := FND_API.g_ret_sts_unexp_error;
1122: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1123: IF (g_debug_unexp) THEN
1124: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1125: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1126: l_api_name || '.others_exception', 'Exception');
1127: END IF;
1128: END IF;

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

1121: x_return_status := FND_API.g_ret_sts_unexp_error;
1122: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1123: IF (g_debug_unexp) THEN
1124: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1125: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1126: l_api_name || '.others_exception', 'Exception');
1127: END IF;
1128: END IF;
1129: END get_action_date;

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

1175: x_return_status := FND_API.g_ret_sts_success;
1176: -- End standard API initialization
1177:
1178: IF (g_debug_stmt) THEN
1179: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1180: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1181: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
1182: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null') ||
1183: ', Date: ' || NVL(TO_CHAR(p_action_date,'DD-MON-RR'),'null'));

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

1176: -- End standard API initialization
1177:
1178: IF (g_debug_stmt) THEN
1179: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1180: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1181: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
1182: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null') ||
1183: ', Date: ' || NVL(TO_CHAR(p_action_date,'DD-MON-RR'),'null'));
1184: END IF;

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

1203: FND_MESSAGE.set_name('PO','PO_INV_CR_INVALID_GL_PERIOD');
1204: FND_MESSAGE.set_token('GL_DATE',
1205: TO_CHAR(p_action_date,'DD-MON-YYYY'));
1206: IF (g_debug_stmt) THEN
1207: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1208: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
1209: l_api_name || '.gl_period', FALSE);
1210: END IF;
1211: END IF;

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

1204: FND_MESSAGE.set_token('GL_DATE',
1205: TO_CHAR(p_action_date,'DD-MON-YYYY'));
1206: IF (g_debug_stmt) THEN
1207: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1208: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
1209: l_api_name || '.gl_period', FALSE);
1210: END IF;
1211: END IF;
1212: FND_MSG_PUB.add;

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

1228: -- Validate with CBC accounting date if enabled for cancel or finally close
1229: IF (p_cbc_enabled = 'Y') AND (p_action IN ('CANCEL','FINALLY CLOSE')) THEN
1230:
1231: IF (g_debug_stmt) THEN
1232: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1233: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix||l_api_name
1234: || '.val_cbc_date', 'IGC_CBC_PO_GRP.valid_cbc_acct_date');
1235: END IF;
1236: END IF;

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

1229: IF (p_cbc_enabled = 'Y') AND (p_action IN ('CANCEL','FINALLY CLOSE')) THEN
1230:
1231: IF (g_debug_stmt) THEN
1232: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1233: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix||l_api_name
1234: || '.val_cbc_date', 'IGC_CBC_PO_GRP.valid_cbc_acct_date');
1235: END IF;
1236: END IF;
1237:

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

1264: WHEN OTHERS THEN
1265: x_return_status := FND_API.g_ret_sts_unexp_error;
1266: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1267: IF (g_debug_unexp) THEN
1268: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1269: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1270: l_api_name || '.others_exception', 'Exception');
1271: END IF;
1272: END IF;

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

1265: x_return_status := FND_API.g_ret_sts_unexp_error;
1266: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1267: IF (g_debug_unexp) THEN
1268: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1269: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1270: l_api_name || '.others_exception', 'Exception');
1271: END IF;
1272: END IF;
1273: END val_action_date;

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

1449: --< Bug 3194665 > Removed unnecessary std api work
1450: x_return_status := FND_API.g_ret_sts_success;
1451:
1452: IF (g_debug_stmt) THEN
1453: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1454: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1455: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
1456: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
1457: END IF;

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

1450: x_return_status := FND_API.g_ret_sts_success;
1451:
1452: IF (g_debug_stmt) THEN
1453: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1454: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1455: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
1456: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
1457: END IF;
1458: END IF;

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

1465:
1466: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1467: -- No data found, so just return error status without a msg
1468: IF (g_debug_stmt) THEN
1469: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1470: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1471: '.no_data_found', FALSE);
1472: END IF;
1473: END IF;

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

1466: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1467: -- No data found, so just return error status without a msg
1468: IF (g_debug_stmt) THEN
1469: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1470: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1471: '.no_data_found', FALSE);
1472: END IF;
1473: END IF;
1474: x_return_status := FND_API.g_ret_sts_error;

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

1484: CLOSE l_get_actions_csr;
1485: END IF;
1486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1487: IF (g_debug_unexp) THEN
1488: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1489: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1490: l_api_name || '.others_exception', 'Exception');
1491: END IF;
1492: END IF;

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

1485: END IF;
1486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1487: IF (g_debug_unexp) THEN
1488: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1489: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1490: l_api_name || '.others_exception', 'Exception');
1491: END IF;
1492: END IF;
1493: END get_header_actions;

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

1646: --< Bug 3194665 > Removed unnecessary std api work
1647: x_return_status := FND_API.g_ret_sts_success;
1648:
1649: IF (g_debug_stmt) THEN
1650: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1651: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1652: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
1653: ', Line ID: ' || NVL(TO_CHAR(p_doc_line_id),'null'));
1654: END IF;

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

1647: x_return_status := FND_API.g_ret_sts_success;
1648:
1649: IF (g_debug_stmt) THEN
1650: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1651: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1652: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
1653: ', Line ID: ' || NVL(TO_CHAR(p_doc_line_id),'null'));
1654: END IF;
1655: END IF;

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

1662:
1663: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1664: -- No data found, so just return error status without a msg
1665: IF (g_debug_stmt) THEN
1666: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1667: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1668: '.get_failed', FALSE);
1669: END IF;
1670: END IF;

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

1663: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1664: -- No data found, so just return error status without a msg
1665: IF (g_debug_stmt) THEN
1666: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1667: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1668: '.get_failed', FALSE);
1669: END IF;
1670: END IF;
1671: x_return_status := FND_API.g_ret_sts_error;

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

1682: CLOSE l_get_actions_csr;
1683: END IF;
1684: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1685: IF (g_debug_unexp) THEN
1686: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1687: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1688: l_api_name || '.others_exception', 'Exception');
1689: END IF;
1690: END IF;

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

1683: END IF;
1684: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1685: IF (g_debug_unexp) THEN
1686: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1687: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1688: l_api_name || '.others_exception', 'Exception');
1689: END IF;
1690: END IF;
1691: END get_line_actions;

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

1856: --< Bug 3194665 > Removed unnecessary std api work
1857: x_return_status := FND_API.g_ret_sts_success;
1858:
1859: IF (g_debug_stmt) THEN
1860: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1861: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1862: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
1863: ', Subtype: ' || NVL(p_doc_subtype,'null') ||
1864: ', Line Loc ID: ' || NVL(TO_CHAR(p_doc_line_loc_id),'null'));

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

1857: x_return_status := FND_API.g_ret_sts_success;
1858:
1859: IF (g_debug_stmt) THEN
1860: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1861: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1862: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
1863: ', Subtype: ' || NVL(p_doc_subtype,'null') ||
1864: ', Line Loc ID: ' || NVL(TO_CHAR(p_doc_line_loc_id),'null'));
1865: END IF;

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

1873:
1874: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1875: -- No data found, so just return error status without a msg
1876: IF (g_debug_stmt) THEN
1877: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1878: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1879: '.get_failed', FALSE);
1880: END IF;
1881: END IF;

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

1874: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
1875: -- No data found, so just return error status without a msg
1876: IF (g_debug_stmt) THEN
1877: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1878: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
1879: '.get_failed', FALSE);
1880: END IF;
1881: END IF;
1882: x_return_status := FND_API.g_ret_sts_error;

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

1892: CLOSE l_get_actions_csr;
1893: END IF;
1894: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1895: IF (g_debug_unexp) THEN
1896: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1897: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1898: l_api_name || '.others_exception', 'Exception');
1899: END IF;
1900: END IF;

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

1893: END IF;
1894: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1895: IF (g_debug_unexp) THEN
1896: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1897: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1898: l_api_name || '.others_exception', 'Exception');
1899: END IF;
1900: END IF;
1901: END get_shipment_actions;

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

2056: --< Bug 3194665 > Removed unnecessary std api work
2057: x_return_status := FND_API.g_ret_sts_success;
2058:
2059: IF (g_debug_stmt) THEN
2060: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2061: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2062: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
2063: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
2064: END IF;

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

2057: x_return_status := FND_API.g_ret_sts_success;
2058:
2059: IF (g_debug_stmt) THEN
2060: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2061: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2062: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
2063: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
2064: END IF;
2065: END IF;

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

2072:
2073: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
2074: -- No data found, so just return error status without a msg
2075: IF (g_debug_stmt) THEN
2076: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2077: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2078: '.get_failed', FALSE);
2079: END IF;
2080: END IF;

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

2073: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
2074: -- No data found, so just return error status without a msg
2075: IF (g_debug_stmt) THEN
2076: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2077: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2078: '.get_failed', FALSE);
2079: END IF;
2080: END IF;
2081: x_return_status := FND_API.g_ret_sts_error;

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

2091: CLOSE l_get_actions_csr;
2092: END IF;
2093: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2094: IF (g_debug_unexp) THEN
2095: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2096: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2097: l_api_name || '.others_exception', 'Exception');
2098: END IF;
2099: END IF;

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

2092: END IF;
2093: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2094: IF (g_debug_unexp) THEN
2095: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2096: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2097: l_api_name || '.others_exception', 'Exception');
2098: END IF;
2099: END IF;
2100: END get_rel_header_actions;

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

2225: --< Bug 3194665 > Removed unnecessary std api work
2226: x_return_status := FND_API.g_ret_sts_success;
2227:
2228: IF (g_debug_stmt) THEN
2229: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2230: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2231: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
2232: ', Line Loc ID: ' || NVL(TO_CHAR(p_doc_line_loc_id),'null'));
2233: END IF;

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

2226: x_return_status := FND_API.g_ret_sts_success;
2227:
2228: IF (g_debug_stmt) THEN
2229: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2230: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2231: '.invoked', 'Subtype: ' || NVL(p_doc_subtype,'null') ||
2232: ', Line Loc ID: ' || NVL(TO_CHAR(p_doc_line_loc_id),'null'));
2233: END IF;
2234: END IF;

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

2241:
2242: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
2243: -- No data found, so just return error status without a msg
2244: IF (g_debug_stmt) THEN
2245: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2246: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2247: '.get_failed', FALSE);
2248: END IF;
2249: END IF;

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

2242: IF (l_get_actions_csr%ROWCOUNT = 0) THEN
2243: -- No data found, so just return error status without a msg
2244: IF (g_debug_stmt) THEN
2245: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2246: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2247: '.get_failed', FALSE);
2248: END IF;
2249: END IF;
2250: x_return_status := FND_API.g_ret_sts_error;

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

2260: CLOSE l_get_actions_csr;
2261: END IF;
2262: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2263: IF (g_debug_unexp) THEN
2264: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2265: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2266: l_api_name || '.others_exception', 'Exception');
2267: END IF;
2268: END IF;

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

2261: END IF;
2262: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2263: IF (g_debug_unexp) THEN
2264: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2265: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2266: l_api_name || '.others_exception', 'Exception');
2267: END IF;
2268: END IF;
2269: END get_rel_shipment_actions;

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

2332: x_return_status := FND_API.g_ret_sts_success;
2333: -- End standard API initialization
2334:
2335: IF (g_debug_stmt) THEN
2336: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2337: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2338: '.invoked', 'Action: ' || NVL(p_action,'null') ||
2339: ', Type: ' || NVL(p_doc_type,'null') ||
2340: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));

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

2333: -- End standard API initialization
2334:
2335: IF (g_debug_stmt) THEN
2336: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2337: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2338: '.invoked', 'Action: ' || NVL(p_action,'null') ||
2339: ', Type: ' || NVL(p_doc_type,'null') ||
2340: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
2341: END IF;

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

2400: --< Bug 3194665 End >
2401: ELSE
2402: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2403: IF (g_debug_stmt) THEN
2404: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2405: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
2406: l_api_name || '.invalid_doc_ids', FALSE);
2407: END IF;
2408: END IF;

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

2401: ELSE
2402: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2403: IF (g_debug_stmt) THEN
2404: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2405: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
2406: l_api_name || '.invalid_doc_ids', FALSE);
2407: END IF;
2408: END IF;
2409: FND_MSG_PUB.add;

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

2460: --< Bug 3194665 End >
2461: ELSE
2462: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2463: IF (g_debug_stmt) THEN
2464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2465: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
2466: l_api_name || '.invalid_doc_ids', FALSE);
2467: END IF;
2468: END IF;

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

2461: ELSE
2462: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2463: IF (g_debug_stmt) THEN
2464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2465: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
2466: l_api_name || '.invalid_doc_ids', FALSE);
2467: END IF;
2468: END IF;
2469: FND_MSG_PUB.add;

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

2474: -- This document type is not supported
2475: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
2476: FND_MESSAGE.set_token('TYPE',p_doc_type);
2477: IF (g_debug_stmt) THEN
2478: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2479: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2480: '.invalid_doc_type', FALSE);
2481: END IF;
2482: END IF;

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

2475: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
2476: FND_MESSAGE.set_token('TYPE',p_doc_type);
2477: IF (g_debug_stmt) THEN
2478: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2479: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2480: '.invalid_doc_type', FALSE);
2481: END IF;
2482: END IF;
2483: FND_MSG_PUB.add;

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

2488: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2489: FND_MESSAGE.set_name('PO','PO_CONTROL_INVALID_ACTION');
2490: FND_MESSAGE.set_token('ACTION',p_action);
2491: IF (g_debug_stmt) THEN
2492: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2493: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2494: '.get_action_failed', FALSE);
2495: END IF;
2496: END IF;

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

2489: FND_MESSAGE.set_name('PO','PO_CONTROL_INVALID_ACTION');
2490: FND_MESSAGE.set_token('ACTION',p_action);
2491: IF (g_debug_stmt) THEN
2492: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2493: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2494: '.get_action_failed', FALSE);
2495: END IF;
2496: END IF;
2497: FND_MSG_PUB.add;

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

2514: IF NOT l_action_ok THEN
2515: FND_MESSAGE.set_name('PO','PO_CONTROL_INVALID_ACTION');
2516: FND_MESSAGE.set_token('ACTION',p_action);
2517: IF (g_debug_stmt) THEN
2518: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2519: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2520: '.status_failed', FALSE);
2521: END IF;
2522: END IF;

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

2515: FND_MESSAGE.set_name('PO','PO_CONTROL_INVALID_ACTION');
2516: FND_MESSAGE.set_token('ACTION',p_action);
2517: IF (g_debug_stmt) THEN
2518: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2519: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2520: '.status_failed', FALSE);
2521: END IF;
2522: END IF;
2523: FND_MSG_PUB.add;

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

2570: WHEN OTHERS THEN
2571: x_return_status := FND_API.g_ret_sts_unexp_error;
2572: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2573: IF (g_debug_unexp) THEN
2574: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2575: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2576: l_api_name || '.others_exception', 'Exception');
2577: END IF;
2578: END IF;

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

2571: x_return_status := FND_API.g_ret_sts_unexp_error;
2572: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2573: IF (g_debug_unexp) THEN
2574: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2575: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2576: l_api_name || '.others_exception', 'Exception');
2577: END IF;
2578: END IF;
2579: END val_control_action;

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

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

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

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

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

2664: FETCH l_po_wf_csr INTO l_wf_item_type, l_wf_item_key;
2665: IF l_po_wf_csr%NOTFOUND THEN
2666: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2667: IF (g_debug_stmt) THEN
2668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2669: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2670: '.invalid_doc_ids', FALSE);
2671: END IF;
2672: END IF;

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

2665: IF l_po_wf_csr%NOTFOUND THEN
2666: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2667: IF (g_debug_stmt) THEN
2668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2669: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2670: '.invalid_doc_ids', FALSE);
2671: END IF;
2672: END IF;
2673: FND_MSG_PUB.add;

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

2744: CLOSE l_unapproved_releases_csr;
2745: END IF;
2746: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2747: IF (g_debug_unexp) THEN
2748: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2749: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2750: l_api_name || '.others_exception', 'Exception');
2751: END IF;
2752: END IF;

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

2745: END IF;
2746: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2747: IF (g_debug_unexp) THEN
2748: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2749: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2750: l_api_name || '.others_exception', 'Exception');
2751: END IF;
2752: END IF;
2753: END po_stop_wf_process;

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

2795: x_return_status := FND_API.g_ret_sts_success;
2796: -- End standard API initialization
2797:
2798: IF (g_debug_stmt) THEN
2799: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2800: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2801: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
2802: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
2803: END IF;

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

2796: -- End standard API initialization
2797:
2798: IF (g_debug_stmt) THEN
2799: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2800: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2801: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
2802: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
2803: END IF;
2804: END IF;

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

2807: FETCH l_rel_wf_csr INTO l_wf_item_type, l_wf_item_key;
2808: IF l_rel_wf_csr%NOTFOUND THEN
2809: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2810: IF (g_debug_stmt) THEN
2811: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2812: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2813: '.invalid_doc_ids', FALSE);
2814: END IF;
2815: END IF;

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

2808: IF l_rel_wf_csr%NOTFOUND THEN
2809: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
2810: IF (g_debug_stmt) THEN
2811: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2812: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2813: '.invalid_doc_ids', FALSE);
2814: END IF;
2815: END IF;
2816: FND_MSG_PUB.add;

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

2843: CLOSE l_rel_wf_csr;
2844: END IF;
2845: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2846: IF (g_debug_unexp) THEN
2847: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2848: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2849: l_api_name || '.others_exception', 'Exception');
2850: END IF;
2851: END IF;

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

2844: END IF;
2845: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2846: IF (g_debug_unexp) THEN
2847: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2848: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2849: l_api_name || '.others_exception', 'Exception');
2850: END IF;
2851: END IF;
2852: END rel_stop_wf_process;

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

2886: x_return_status := FND_API.g_ret_sts_success;
2887: -- End standard API initialization
2888:
2889: IF (g_debug_stmt) THEN
2890: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2891: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2892: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null'));
2893: END IF;
2894: END IF;

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

2887: -- End standard API initialization
2888:
2889: IF (g_debug_stmt) THEN
2890: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2891: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2892: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null'));
2893: END IF;
2894: END IF;
2895:

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

2931:
2932: IF (x_request_id = 0) THEN
2933: -- The call to FND_REQUEST sets a message name on error
2934: IF (g_debug_stmt) THEN
2935: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2936: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2937: '.request_failed', FALSE);
2938: END IF;
2939: END IF;

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

2932: IF (x_request_id = 0) THEN
2933: -- The call to FND_REQUEST sets a message name on error
2934: IF (g_debug_stmt) THEN
2935: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
2936: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2937: '.request_failed', FALSE);
2938: END IF;
2939: END IF;
2940: FND_MSG_PUB.add;

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

2949: WHEN OTHERS THEN
2950: x_return_status := FND_API.g_ret_sts_unexp_error;
2951: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2952: IF (g_debug_unexp) THEN
2953: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2954: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2955: l_api_name || '.others_exception', 'Exception');
2956: END IF;
2957: END IF;

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

2950: x_return_status := FND_API.g_ret_sts_unexp_error;
2951: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2952: IF (g_debug_unexp) THEN
2953: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2954: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2955: l_api_name || '.others_exception', 'Exception');
2956: END IF;
2957: END IF;
2958: END submit_po_print_request;

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

2993: x_return_status := FND_API.g_ret_sts_success;
2994: -- End standard API initialization
2995:
2996: IF (g_debug_stmt) THEN
2997: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2998: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2999: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null') ||
3000: ', Rel num: ' || NVL(p_rel_doc_num,'null'));
3001: END IF;

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

2994: -- End standard API initialization
2995:
2996: IF (g_debug_stmt) THEN
2997: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2998: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2999: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null') ||
3000: ', Rel num: ' || NVL(p_rel_doc_num,'null'));
3001: END IF;
3002: END IF;

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

3040:
3041: IF (x_request_id = 0) THEN
3042: -- The call to FND_REQUEST sets a message name on error
3043: IF (g_debug_stmt) THEN
3044: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3045: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3046: '.request_failed', FALSE);
3047: END IF;
3048: END IF;

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

3041: IF (x_request_id = 0) THEN
3042: -- The call to FND_REQUEST sets a message name on error
3043: IF (g_debug_stmt) THEN
3044: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3045: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3046: '.request_failed', FALSE);
3047: END IF;
3048: END IF;
3049: FND_MSG_PUB.add;

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

3058: WHEN OTHERS THEN
3059: x_return_status := FND_API.g_ret_sts_unexp_error;
3060: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3061: IF (g_debug_unexp) THEN
3062: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3063: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3064: l_api_name || '.others_exception', 'Exception');
3065: END IF;
3066: END IF;

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

3059: x_return_status := FND_API.g_ret_sts_unexp_error;
3060: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3061: IF (g_debug_unexp) THEN
3062: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3063: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3064: l_api_name || '.others_exception', 'Exception');
3065: END IF;
3066: END IF;
3067: END submit_rel_print_request;

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

3101: x_return_status := FND_API.g_ret_sts_success;
3102: -- End standard API initialization
3103:
3104: IF (g_debug_stmt) THEN
3105: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3106: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3107: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null'));
3108: END IF;
3109: END IF;

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

3102: -- End standard API initialization
3103:
3104: IF (g_debug_stmt) THEN
3105: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3106: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3107: '.invoked', 'Doc num: ' || NVL(p_doc_num,'null'));
3108: END IF;
3109: END IF;
3110:

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

3144:
3145: IF (x_request_id = 0) THEN
3146: -- The call to FND_REQUEST sets a message name on error
3147: IF (g_debug_stmt) THEN
3148: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3149: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3150: '.request_failed', FALSE);
3151: END IF;
3152: END IF;

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

3145: IF (x_request_id = 0) THEN
3146: -- The call to FND_REQUEST sets a message name on error
3147: IF (g_debug_stmt) THEN
3148: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3149: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3150: '.request_failed', FALSE);
3151: END IF;
3152: END IF;
3153: FND_MSG_PUB.add;

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

3162: WHEN OTHERS THEN
3163: x_return_status := FND_API.g_ret_sts_unexp_error;
3164: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3165: IF (g_debug_unexp) THEN
3166: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3167: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3168: l_api_name || '.others_exception', 'Exception');
3169: END IF;
3170: END IF;

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

3163: x_return_status := FND_API.g_ret_sts_unexp_error;
3164: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3165: IF (g_debug_unexp) THEN
3166: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3167: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3168: l_api_name || '.others_exception', 'Exception');
3169: END IF;
3170: END IF;
3171: END submit_req_print_request;

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

3211: x_return_status := FND_API.g_ret_sts_success;
3212: -- End standard API initialization
3213:
3214: IF (g_debug_stmt) THEN
3215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3216: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3217: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3218: ', Doc num: ' || NVL(p_doc_num,'null') ||
3219: ', Rel num: ' || NVL(p_rel_doc_num,'null'));

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

3212: -- End standard API initialization
3213:
3214: IF (g_debug_stmt) THEN
3215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3216: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3217: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3218: ', Doc num: ' || NVL(p_doc_num,'null') ||
3219: ', Rel num: ' || NVL(p_rel_doc_num,'null'));
3220: END IF;

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

3255: -- This document type is not supported
3256: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
3257: FND_MESSAGE.set_token('TYPE',p_doc_type);
3258: IF (g_debug_stmt) THEN
3259: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3260: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3261: '.invalid_doc_type', FALSE);
3262: END IF;
3263: END IF;

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

3256: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
3257: FND_MESSAGE.set_token('TYPE',p_doc_type);
3258: IF (g_debug_stmt) THEN
3259: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3260: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3261: '.invalid_doc_type', FALSE);
3262: END IF;
3263: END IF;
3264: FND_MSG_PUB.add;

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

3273: WHEN OTHERS THEN
3274: x_return_status := FND_API.g_ret_sts_unexp_error;
3275: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3276: IF (g_debug_unexp) THEN
3277: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3278: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3279: l_api_name || '.others_exception', 'Exception');
3280: END IF;
3281: END IF;

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

3274: x_return_status := FND_API.g_ret_sts_unexp_error;
3275: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3276: IF (g_debug_unexp) THEN
3277: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3278: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3279: l_api_name || '.others_exception', 'Exception');
3280: END IF;
3281: END IF;
3282: END create_print_request;

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

3325: x_return_status := FND_API.g_ret_sts_success;
3326: -- End standard API initialization
3327:
3328: IF (g_debug_stmt) THEN
3329: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3330: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3331: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3332: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3333: END IF;

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

3326: -- End standard API initialization
3327:
3328: IF (g_debug_stmt) THEN
3329: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3330: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3331: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3332: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3333: END IF;
3334: END IF;

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

3346: -- Return error if no update was made.
3347: IF SQL%NOTFOUND THEN
3348: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3349: IF (g_debug_stmt) THEN
3350: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3351: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3352: '.invalid_document', FALSE);
3353: END IF;
3354: END IF;

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

3347: IF SQL%NOTFOUND THEN
3348: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3349: IF (g_debug_stmt) THEN
3350: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3351: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3352: '.invalid_document', FALSE);
3353: END IF;
3354: END IF;
3355: FND_MSG_PUB.add;

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

3378: -- Return error if no update was made.
3379: IF SQL%NOTFOUND THEN
3380: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3381: IF (g_debug_stmt) THEN
3382: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3383: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3384: '.invalid_document', FALSE);
3385: END IF;
3386: END IF;

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

3379: IF SQL%NOTFOUND THEN
3380: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3381: IF (g_debug_stmt) THEN
3382: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3383: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3384: '.invalid_document', FALSE);
3385: END IF;
3386: END IF;
3387: FND_MSG_PUB.add;

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

3410: -- Return error if no update was made.
3411: IF SQL%NOTFOUND THEN
3412: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3413: IF (g_debug_stmt) THEN
3414: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3415: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3416: '.invalid_document', FALSE);
3417: END IF;
3418: END IF;

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

3411: IF SQL%NOTFOUND THEN
3412: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
3413: IF (g_debug_stmt) THEN
3414: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3415: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3416: '.invalid_document', FALSE);
3417: END IF;
3418: END IF;
3419: FND_MSG_PUB.add;

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

3434: -- This document type is not supported
3435: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
3436: FND_MESSAGE.set_token('TYPE',p_doc_type);
3437: IF (g_debug_stmt) THEN
3438: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3439: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3440: '.invalid_doc_type', FALSE);
3441: END IF;
3442: END IF;

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

3435: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');
3436: FND_MESSAGE.set_token('TYPE',p_doc_type);
3437: IF (g_debug_stmt) THEN
3438: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3439: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3440: '.invalid_doc_type', FALSE);
3441: END IF;
3442: END IF;
3443: FND_MSG_PUB.add;

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

3460: ROLLBACK TO update_note_to_vendor_PVT;
3461: x_return_status := FND_API.g_ret_sts_unexp_error;
3462: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3463: IF (g_debug_unexp) THEN
3464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3465: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3466: l_api_name || '.others_exception', 'Exception');
3467: END IF;
3468: END IF;

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

3461: x_return_status := FND_API.g_ret_sts_unexp_error;
3462: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3463: IF (g_debug_unexp) THEN
3464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3465: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3466: l_api_name || '.others_exception', 'Exception');
3467: END IF;
3468: END IF;
3469: END update_note_to_vendor;

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

3510: x_return_status := FND_API.g_ret_sts_success;
3511: -- End standard API initialization
3512:
3513: IF (g_debug_stmt) THEN
3514: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3515: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3516: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3517: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null') ||
3518: ', Agent: ' || NVL(TO_CHAR(p_agent_id),'null'));

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

3511: -- End standard API initialization
3512:
3513: IF (g_debug_stmt) THEN
3514: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3515: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3516: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3517: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null') ||
3518: ', Agent: ' || NVL(TO_CHAR(p_agent_id),'null'));
3519: END IF;

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

3549: WHEN OTHERS THEN
3550: x_return_status := FND_API.g_ret_sts_unexp_error;
3551: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3552: IF (g_debug_unexp) THEN
3553: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3554: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3555: l_api_name || '.others_exception', 'Exception');
3556: END IF;
3557: END IF;

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

3550: x_return_status := FND_API.g_ret_sts_unexp_error;
3551: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3552: IF (g_debug_unexp) THEN
3553: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3554: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3555: l_api_name || '.others_exception', 'Exception');
3556: END IF;
3557: END IF;
3558: RETURN FALSE;

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

3619: x_return_status := FND_API.g_ret_sts_success;
3620: -- End standard API initialization
3621:
3622: IF (g_debug_stmt) THEN
3623: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3624: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3625: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3626: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3627: END IF;

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

3620: -- End standard API initialization
3621:
3622: IF (g_debug_stmt) THEN
3623: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3624: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3625: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3626: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3627: END IF;
3628: END IF;

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

3665: CLOSE l_has_rel_ship_csr;
3666: END IF;
3667: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3668: IF (g_debug_unexp) THEN
3669: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3670: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3671: l_api_name || '.others_exception', 'Exception');
3672: END IF;
3673: END IF;

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

3666: END IF;
3667: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3668: IF (g_debug_unexp) THEN
3669: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3670: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3671: l_api_name || '.others_exception', 'Exception');
3672: END IF;
3673: END IF;
3674: RETURN FALSE;

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

3715: x_return_status := FND_API.g_ret_sts_success;
3716: -- End standard API initialization
3717:
3718: IF (g_debug_stmt) THEN
3719: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3720: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3721: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3722: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3723: END IF;

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

3716: -- End standard API initialization
3717:
3718: IF (g_debug_stmt) THEN
3719: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3720: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3721: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
3722: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
3723: END IF;
3724: END IF;

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

3747: WHEN OTHERS THEN
3748: x_return_status := FND_API.g_ret_sts_unexp_error;
3749: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3750: IF (g_debug_unexp) THEN
3751: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3752: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3753: l_api_name || '.others_exception', 'Exception');
3754: END IF;
3755: END IF;

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

3748: x_return_status := FND_API.g_ret_sts_unexp_error;
3749: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3750: IF (g_debug_unexp) THEN
3751: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3752: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3753: l_api_name || '.others_exception', 'Exception');
3754: END IF;
3755: END IF;
3756: RETURN FALSE;

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

3814: x_return_status := FND_API.g_ret_sts_success;
3815: -- End standard API initialization
3816:
3817: IF (g_debug_stmt) THEN
3818: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3819: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3820: '.invoked', 'Date: ' ||
3821: NVL(TO_CHAR(p_date,'DD-MON-RR'),'null'));
3822: END IF;

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

3815: -- End standard API initialization
3816:
3817: IF (g_debug_stmt) THEN
3818: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3819: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3820: '.invoked', 'Date: ' ||
3821: NVL(TO_CHAR(p_date,'DD-MON-RR'),'null'));
3822: END IF;
3823: END IF;

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

3845: CLOSE l_gl_period_csr;
3846: END IF;
3847: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3848: IF (g_debug_unexp) THEN
3849: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3850: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3851: l_api_name || '.others_exception', 'Exception');
3852: END IF;
3853: END IF;

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

3846: END IF;
3847: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3848: IF (g_debug_unexp) THEN
3849: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3850: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3851: l_api_name || '.others_exception', 'Exception');
3852: END IF;
3853: END IF;
3854: RETURN FALSE;

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

3897: x_return_status := FND_API.g_ret_sts_success;
3898: -- End standard API initialization
3899:
3900: IF (g_debug_stmt) THEN
3901: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3902: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3903: '.invoked', 'Online report ID: ' ||
3904: NVL(TO_CHAR(p_online_report_id),'null'));
3905: END IF;

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

3898: -- End standard API initialization
3899:
3900: IF (g_debug_stmt) THEN
3901: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
3902: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
3903: '.invoked', 'Online report ID: ' ||
3904: NVL(TO_CHAR(p_online_report_id),'null'));
3905: END IF;
3906: END IF;

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

3913: -- The text_line column contains translated messages
3914: FND_MESSAGE.set_name('PO','PO_CUSTOM_MSG');
3915: FND_MESSAGE.set_token('TRANSLATED_TOKEN', l_text_line_tbl(i));
3916: IF (g_debug_stmt) THEN
3917: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3918: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
3919: l_api_name || '.msg', FALSE);
3920: END IF;
3921: END IF;

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

3914: FND_MESSAGE.set_name('PO','PO_CUSTOM_MSG');
3915: FND_MESSAGE.set_token('TRANSLATED_TOKEN', l_text_line_tbl(i));
3916: IF (g_debug_stmt) THEN
3917: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
3918: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
3919: l_api_name || '.msg', FALSE);
3920: END IF;
3921: END IF;
3922: FND_MSG_PUB.add;

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

3936: WHEN OTHERS THEN
3937: x_return_status := FND_API.g_ret_sts_unexp_error;
3938: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3939: IF (g_debug_unexp) THEN
3940: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3941: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3942: l_api_name || '.others_exception', 'Exception');
3943: END IF;
3944: END IF;

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

3937: x_return_status := FND_API.g_ret_sts_unexp_error;
3938: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3939: IF (g_debug_unexp) THEN
3940: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3941: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3942: l_api_name || '.others_exception', 'Exception');
3943: END IF;
3944: END IF;
3945: END add_online_report_msgs;