DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on FND_LOG

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

328: x_return_status := FND_API.g_ret_sts_unexp_error;
329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
330: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
331: IF g_fnd_debug = 'Y' THEN
332: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
333: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
334: l_api_name || '.others_exception', sqlcode);
335: END IF;
336: END IF;

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

329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
330: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
331: IF g_fnd_debug = 'Y' THEN
332: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
333: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
334: l_api_name || '.others_exception', sqlcode);
335: END IF;
336: END IF;
337: END IF;

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

425: x_return_status := FND_API.g_ret_sts_unexp_error;
426: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
427: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
428: IF g_fnd_debug = 'Y' THEN
429: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
430: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
431: l_api_name || '.others_exception', sqlcode);
432: END IF;
433: END IF;

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

426: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
427: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
428: IF g_fnd_debug = 'Y' THEN
429: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
430: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
431: l_api_name || '.others_exception', sqlcode);
432: END IF;
433: END IF;
434: END IF;

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

527: x_return_status := FND_API.g_ret_sts_unexp_error;
528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
529: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
530: IF g_fnd_debug = 'Y' THEN
531: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
532: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
533: l_api_name || '.others_exception', sqlcode);
534: END IF;
535: END IF;

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

528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
529: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
530: IF g_fnd_debug = 'Y' THEN
531: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
532: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
533: l_api_name || '.others_exception', sqlcode);
534: END IF;
535: END IF;
536: END IF;

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

716:
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
718: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
719: IF g_fnd_debug = 'Y' THEN
720: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
721: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
722: l_api_name || '.others exception' ,sqlcode);
723: END IF;
724: END IF;

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

717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
718: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
719: IF g_fnd_debug = 'Y' THEN
720: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
721: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
722: l_api_name || '.others exception' ,sqlcode);
723: END IF;
724: END IF;
725: END IF;

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

814: l_last_upd_date := relRec.last_update_date;
815: if (REL_CSR%NOTFOUND) then
816: CLOSE REL_CSR;
817: IF (g_fnd_debug = 'Y') THEN
818: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
819: FND_LOG.string(FND_LOG.level_error, g_module_prefix || 'process_supplier_request ', ' Record dosent exist for po_release_id = ' || p_po_release_id);
820: END IF;
821: END IF;
822: end if;

Line 819: FND_LOG.string(FND_LOG.level_error, g_module_prefix || 'process_supplier_request ', ' Record dosent exist for po_release_id = ' || p_po_release_id);

815: if (REL_CSR%NOTFOUND) then
816: CLOSE REL_CSR;
817: IF (g_fnd_debug = 'Y') THEN
818: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
819: FND_LOG.string(FND_LOG.level_error, g_module_prefix || 'process_supplier_request ', ' Record dosent exist for po_release_id = ' || p_po_release_id);
820: END IF;
821: END IF;
822: end if;
823: CLOSE REL_CSR;

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

841: l_last_upd_date := poRec.last_update_date;
842: if (PO_CSR%NOTFOUND) then
843: CLOSE PO_CSR;
844: IF (g_fnd_debug = 'Y') THEN
845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
846: FND_LOG.string(FND_LOG.level_error, g_module_prefix || 'process_supplier_request', 'Record dosent exist for po_header_id = ' || p_po_header_id);
847: END IF;
848: END IF;
849: end if;

Line 846: FND_LOG.string(FND_LOG.level_error, g_module_prefix || 'process_supplier_request', 'Record dosent exist for po_header_id = ' || p_po_header_id);

842: if (PO_CSR%NOTFOUND) then
843: CLOSE PO_CSR;
844: IF (g_fnd_debug = 'Y') THEN
845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
846: FND_LOG.string(FND_LOG.level_error, g_module_prefix || 'process_supplier_request', 'Record dosent exist for po_header_id = ' || p_po_header_id);
847: END IF;
848: END IF;
849: end if;
850: CLOSE PO_CSR;

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

881: -- Copy the request into a local var
882: l_po_change_requests := p_po_change_requests;
883:
884: IF g_fnd_debug = 'Y' THEN
885: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
886: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
887: '.invoked', 'Type: ' ||
888: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
889: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));

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

882: l_po_change_requests := p_po_change_requests;
883:
884: IF g_fnd_debug = 'Y' THEN
885: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
886: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
887: '.invoked', 'Type: ' ||
888: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
889: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));
890: END IF;

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

906: x_return_status := FND_API.g_ret_sts_unexp_error;
907:
908: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
909: IF g_fnd_debug = 'Y' THEN
910: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
911: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
912: l_api_name || fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ'), sqlcode);
913: END IF;
914: END IF;

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

907:
908: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
909: IF g_fnd_debug = 'Y' THEN
910: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
911: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
912: l_api_name || fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ'), sqlcode);
913: END IF;
914: END IF;
915:

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

1070: x_return_status := FND_API.g_ret_sts_unexp_error;
1071: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1072: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1073: IF g_fnd_debug = 'Y' THEN
1074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1075: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1076: l_api_name || '.others_exception', sqlcode);
1077: END IF;
1078: END IF;

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

1071: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1072: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1073: IF g_fnd_debug = 'Y' THEN
1074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1075: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1076: l_api_name || '.others_exception', sqlcode);
1077: END IF;
1078: END IF;
1079: END IF;

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

1107: end if; -- end if accept reject
1108: END LOOP;
1109: if ((callDocCheck) AND l_po_change_requests.count() > 0 ) then
1110: IF g_fnd_debug = 'Y' THEN
1111: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1112: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1113: '.invoked', ' Change Count : ' || TO_CHAR(l_po_change_requests.count()));
1114: END IF;
1115: END IF;

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

1108: END LOOP;
1109: if ((callDocCheck) AND l_po_change_requests.count() > 0 ) then
1110: IF g_fnd_debug = 'Y' THEN
1111: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1112: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1113: '.invoked', ' Change Count : ' || TO_CHAR(l_po_change_requests.count()));
1114: END IF;
1115: END IF;
1116:

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

1137: end if;
1138:
1139: if (l_po_change_requests.count() > 0 AND x_return_status = FND_API.G_RET_STS_SUCCESS) then
1140: IF g_fnd_debug = 'Y' THEN
1141: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1142: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1143: '.invoked', 'Type: ' ||
1144: ', Save Count : ' || TO_CHAR(l_po_change_requests.count()));
1145: END IF;

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

1138:
1139: if (l_po_change_requests.count() > 0 AND x_return_status = FND_API.G_RET_STS_SUCCESS) then
1140: IF g_fnd_debug = 'Y' THEN
1141: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1142: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1143: '.invoked', 'Type: ' ||
1144: ', Save Count : ' || TO_CHAR(l_po_change_requests.count()));
1145: END IF;
1146: END IF;

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

1167: end if;
1168:
1169: if(updatePoAttr) then
1170: IF g_fnd_debug = 'Y' THEN
1171: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1172: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1173: '.invoked', 'Update PO ' ||
1174: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
1175: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));

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

1168:
1169: if(updatePoAttr) then
1170: IF g_fnd_debug = 'Y' THEN
1171: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1172: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1173: '.invoked', 'Update PO ' ||
1174: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
1175: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));
1176: END IF;

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

1195:
1196:
1197: if (callWf) then
1198: IF g_fnd_debug = 'Y' THEN
1199: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1200: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1201: '.invoked', 'Call Workflow ' || ', request group id ' || to_char(l_request_group_id));
1202: END IF;
1203: END IF;

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

1196:
1197: if (callWf) then
1198: IF g_fnd_debug = 'Y' THEN
1199: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1200: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1201: '.invoked', 'Call Workflow ' || ', request group id ' || to_char(l_request_group_id));
1202: END IF;
1203: END IF;
1204: --start multiple po change

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

1211: end if;
1212:
1213: if(x_return_status = FND_API.G_TRUE) then
1214: IF g_fnd_debug = 'Y' THEN
1215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1216: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1217: '.invoked', ' All shipments acked/changed ' );
1218: END IF;
1219: END IF;

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

1212:
1213: if(x_return_status = FND_API.G_TRUE) then
1214: IF g_fnd_debug = 'Y' THEN
1215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1216: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1217: '.invoked', ' All shipments acked/changed ' );
1218: END IF;
1219: END IF;
1220: else

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

1231:
1232: x_return_status := startSupplierWF( p_po_header_id,p_po_release_id,
1233: p_revision_num, l_request_group_id, x_accp_flag);
1234: IF g_fnd_debug = 'Y' THEN
1235: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1236: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1237: '.invoked', 'Call Workflow ' || ', Return Status ' || x_return_status);
1238: END IF;
1239: END IF;

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

1232: x_return_status := startSupplierWF( p_po_header_id,p_po_release_id,
1233: p_revision_num, l_request_group_id, x_accp_flag);
1234: IF g_fnd_debug = 'Y' THEN
1235: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1236: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1237: '.invoked', 'Call Workflow ' || ', Return Status ' || x_return_status);
1238: END IF;
1239: END IF;
1240: end if;

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

1279: x_return_status := FND_API.g_ret_sts_unexp_error;
1280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1282: IF g_fnd_debug = 'Y' THEN
1283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1284: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1285: l_api_name || '.others_exception', sqlcode);
1286: END IF;
1287: END IF;

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

1280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1282: IF g_fnd_debug = 'Y' THEN
1283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1284: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1285: l_api_name || '.others_exception', sqlcode);
1286: END IF;
1287: END IF;
1288: END IF;

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

1441: x_return_status := FND_API.g_ret_sts_unexp_error;
1442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1443: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1444: IF g_fnd_debug = 'Y' THEN
1445: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1446: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1447: l_api_name || '.others_exception', sqlcode);
1448: END IF;
1449: END IF;

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

1442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1443: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1444: IF g_fnd_debug = 'Y' THEN
1445: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1446: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1447: l_api_name || '.others_exception', sqlcode);
1448: END IF;
1449: END IF;
1450: END IF;

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

1594: END IF;
1595:
1596: x_return_status := FND_API.g_ret_sts_success;
1597: IF g_fnd_debug = 'Y' THEN
1598: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1600: '.invoked', 'Type: ' ||
1601: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
1602: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));

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

1595:
1596: x_return_status := FND_API.g_ret_sts_success;
1597: IF g_fnd_debug = 'Y' THEN
1598: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1600: '.invoked', 'Type: ' ||
1601: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
1602: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));
1603: END IF;

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

1827: amountTbl(lLine+1) := null;
1828:
1829:
1830: IF g_fnd_debug = 'Y' THEN
1831: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1832: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name
1833: , 'Calculating Price break for STD PO from GA: ' ||
1834: ', PO Line Id : ' || NVL(TO_CHAR(l_ga_lineId),'null') ||
1835: ', Total Quantity : ' || NVL(TO_CHAR(l_total_qty),'null') ||

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

1828:
1829:
1830: IF g_fnd_debug = 'Y' THEN
1831: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1832: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name
1833: , 'Calculating Price break for STD PO from GA: ' ||
1834: ', PO Line Id : ' || NVL(TO_CHAR(l_ga_lineId),'null') ||
1835: ', Total Quantity : ' || NVL(TO_CHAR(l_total_qty),'null') ||
1836: ', Price Break : ' || NVL(TO_CHAR(x_price),'null'));

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

1960: x_return_status := FND_API.g_ret_sts_unexp_error;
1961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1962: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1963: IF g_fnd_debug = 'Y' THEN
1964: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1965: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1966: l_api_name || '.others_exception', sqlcode);
1967: END IF;
1968: END IF;

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

1961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1962: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1963: IF g_fnd_debug = 'Y' THEN
1964: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1965: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1966: l_api_name || '.others_exception', sqlcode);
1967: END IF;
1968: END IF;
1969: END IF;

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

2147:
2148: -- Call this when logging is enabled
2149:
2150: IF g_fnd_debug = 'Y' THEN
2151: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2152: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2153: '.invoked', 'Type: ' ||
2154: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
2155: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));

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

2148: -- Call this when logging is enabled
2149:
2150: IF g_fnd_debug = 'Y' THEN
2151: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2152: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2153: '.invoked', 'Type: ' ||
2154: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
2155: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));
2156: END IF;

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

2265: x_return_status := FND_API.g_ret_sts_unexp_error;
2266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2267: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2268: IF g_fnd_debug = 'Y' THEN
2269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2270: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2271: l_api_name || '.others_exception', sqlcode);
2272: END IF;
2273: END IF;

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

2266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2267: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2268: IF g_fnd_debug = 'Y' THEN
2269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2270: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2271: l_api_name || '.others_exception', sqlcode);
2272: END IF;
2273: END IF;
2274: END IF;

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

2287: x_return_status := FND_API.g_ret_sts_unexp_error;
2288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2289: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2290: IF g_fnd_debug = 'Y' THEN
2291: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2292: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2293: l_api_name || '.others_exception', sqlcode);
2294: END IF;
2295: END IF;

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

2288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2289: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2290: IF g_fnd_debug = 'Y' THEN
2291: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2292: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2293: l_api_name || '.others_exception', sqlcode);
2294: END IF;
2295: END IF;
2296: END IF;

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

2534:
2535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2536: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2537: IF g_fnd_debug = 'Y' THEN
2538: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2539: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2540: l_api_name || '.others exception' ,sqlcode);
2541: END IF;
2542: END IF;

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

2535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2536: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2537: IF g_fnd_debug = 'Y' THEN
2538: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2539: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2540: l_api_name || '.others exception' ,sqlcode);
2541: END IF;
2542: END IF;
2543: END IF;

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

2858: po_sup_chg_request_wf_grp.Buyer_CancelDocWithChn(
2859: 1.0,l_return_status,p_po_header_id,p_po_release_id,xRevNum,xGrpId,l_msg_out);
2860: if (l_return_status <> 'S') then
2861: IF (g_fnd_debug = 'Y') THEN
2862: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2863: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2864: l_api_name || '.call buyer cancel workflow', l_msg_out);
2865: END IF;
2866: END IF;

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

2859: 1.0,l_return_status,p_po_header_id,p_po_release_id,xRevNum,xGrpId,l_msg_out);
2860: if (l_return_status <> 'S') then
2861: IF (g_fnd_debug = 'Y') THEN
2862: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2863: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2864: l_api_name || '.call buyer cancel workflow', l_msg_out);
2865: END IF;
2866: END IF;
2867: end if;

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

2879: x_return_status := FND_API.g_ret_sts_unexp_error;
2880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2881: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2882: IF (g_fnd_debug = 'Y') THEN
2883: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2884: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2885: l_api_name || '.others_exception', 'Exception');
2886: END IF;
2887: END IF;

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

2880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2881: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2882: IF (g_fnd_debug = 'Y') THEN
2883: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2884: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2885: l_api_name || '.others_exception', 'Exception');
2886: END IF;
2887: END IF;
2888: END IF;

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

3001: x_notification_id := getSigNotifId(l_item_type, l_item_key);
3002: if x_notification_id is null then
3003: RAISE sig_notif_notfound;
3004: end if;
3005: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3006: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
3007: l_item_key || '.Notification :' || to_char(x_notification_id) ,sqlcode);
3008: END IF;
3009:

Line 3006: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||

3002: if x_notification_id is null then
3003: RAISE sig_notif_notfound;
3004: end if;
3005: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3006: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
3007: l_item_key || '.Notification :' || to_char(x_notification_id) ,sqlcode);
3008: END IF;
3009:
3010: return;

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

3089: WHEN FND_API.g_exc_unexpected_error THEN
3090: x_return_status := FND_API.g_ret_sts_unexp_error;
3091: WHEN sig_notif_notfound THEN
3092: IF g_fnd_debug = 'Y' THEN
3093: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3094: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
3095: l_item_key || '.Notification not found exception' ,sqlcode);
3096: END IF;
3097: END IF;

Line 3094: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||

3090: x_return_status := FND_API.g_ret_sts_unexp_error;
3091: WHEN sig_notif_notfound THEN
3092: IF g_fnd_debug = 'Y' THEN
3093: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3094: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
3095: l_item_key || '.Notification not found exception' ,sqlcode);
3096: END IF;
3097: END IF;
3098: x_return_status := FND_API.g_ret_sts_error;

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

3100: x_return_status := FND_API.g_ret_sts_unexp_error;
3101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3102: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3103: IF g_fnd_debug = 'Y' THEN
3104: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3105: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3106: l_api_name || '.others exception' ,sqlcode);
3107: END IF;
3108: END IF;

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

3101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3102: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3103: IF g_fnd_debug = 'Y' THEN
3104: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3105: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3106: l_api_name || '.others exception' ,sqlcode);
3107: END IF;
3108: END IF;
3109: END IF;

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

3226: x_notification_id := getSigNotifId(l_item_type, l_item_key);
3227: if x_notification_id is null then
3228: RAISE sig_notif_notfound;
3229: end if;
3230: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3231: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
3232: l_item_key || '.Notification :' || to_char(x_notification_id) ,sqlcode);
3233: END IF;
3234:

Line 3231: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||

3227: if x_notification_id is null then
3228: RAISE sig_notif_notfound;
3229: end if;
3230: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3231: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
3232: l_item_key || '.Notification :' || to_char(x_notification_id) ,sqlcode);
3233: END IF;
3234:
3235: return;

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

3315: WHEN FND_API.g_exc_unexpected_error THEN
3316: x_return_status := FND_API.g_ret_sts_unexp_error;
3317: WHEN sig_notif_notfound THEN
3318: IF g_fnd_debug = 'Y' THEN
3319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3320: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
3321: l_item_key || '.Notification not found exception' ,sqlcode);
3322: END IF;
3323: END IF;

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

3316: x_return_status := FND_API.g_ret_sts_unexp_error;
3317: WHEN sig_notif_notfound THEN
3318: IF g_fnd_debug = 'Y' THEN
3319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3320: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
3321: l_item_key || '.Notification not found exception' ,sqlcode);
3322: END IF;
3323: END IF;
3324: x_return_status := FND_API.g_ret_sts_error;

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

3326: x_return_status := FND_API.g_ret_sts_unexp_error;
3327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3329: IF g_fnd_debug = 'Y' THEN
3330: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3331: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3332: l_api_name || '.others exception' ,sqlcode);
3333: END IF;
3334: END IF;

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

3327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3329: IF g_fnd_debug = 'Y' THEN
3330: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3331: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3332: l_api_name || '.others exception' ,sqlcode);
3333: END IF;
3334: END IF;
3335: END IF;

Line 3770: IF ( fnd_log.g_current_runtime_level <= fnd_log.level_procedure ) THEN

3766: x_pos_errors := Pos_err_type(l_err_msg_name_tbl, l_err_msg_text_tbl);
3767: x_ret_sts := 'N';
3768:
3769: IF g_fnd_debug = 'Y' THEN
3770: IF ( fnd_log.g_current_runtime_level <= fnd_log.level_procedure ) THEN
3771: fnd_log.String(fnd_log.level_procedure, g_module_prefix|| l_api_name|| '.invoked', 'Type: '
3772: || 'entered procedure'
3773: ||l_api_name
3774: ||', Header ID: '

Line 3771: fnd_log.String(fnd_log.level_procedure, g_module_prefix|| l_api_name|| '.invoked', 'Type: '

3767: x_ret_sts := 'N';
3768:
3769: IF g_fnd_debug = 'Y' THEN
3770: IF ( fnd_log.g_current_runtime_level <= fnd_log.level_procedure ) THEN
3771: fnd_log.String(fnd_log.level_procedure, g_module_prefix|| l_api_name|| '.invoked', 'Type: '
3772: || 'entered procedure'
3773: ||l_api_name
3774: ||', Header ID: '
3775: ||Nvl(To_char(p_po_header_id), 'null')

Line 3939: IF ( fnd_log.g_current_runtime_level <=fnd_log.level_unexpected ) THEN

3935: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3936: THEN
3937: fnd_msg_pub.Add_exc_msg(g_pkg_name, l_api_name);
3938: IF g_fnd_debug = 'Y' THEN
3939: IF ( fnd_log.g_current_runtime_level <=fnd_log.level_unexpected ) THEN
3940: fnd_log.String(fnd_log.level_unexpected, g_module_prefix|| l_api_name||'.others_exception', SQLCODE);
3941: END IF;
3942: END IF;
3943: END IF;

Line 3940: fnd_log.String(fnd_log.level_unexpected, g_module_prefix|| l_api_name||'.others_exception', SQLCODE);

3936: THEN
3937: fnd_msg_pub.Add_exc_msg(g_pkg_name, l_api_name);
3938: IF g_fnd_debug = 'Y' THEN
3939: IF ( fnd_log.g_current_runtime_level <=fnd_log.level_unexpected ) THEN
3940: fnd_log.String(fnd_log.level_unexpected, g_module_prefix|| l_api_name||'.others_exception', SQLCODE);
3941: END IF;
3942: END IF;
3943: END IF;
3944: END IS_ASN_EXIST;