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

613:
614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
616: IF g_fnd_debug = 'Y' THEN
617: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
618: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
619: l_api_name || '.others exception' ,sqlcode);
620: END IF;
621: END IF;

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

614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
616: IF g_fnd_debug = 'Y' THEN
617: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
618: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
619: l_api_name || '.others exception' ,sqlcode);
620: END IF;
621: END IF;
622: END IF;

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

711: l_last_upd_date := relRec.last_update_date;
712: if (REL_CSR%NOTFOUND) then
713: CLOSE REL_CSR;
714: IF (g_fnd_debug = 'Y') THEN
715: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
716: FND_LOG.string(FND_LOG.level_error, g_module_prefix || 'process_supplier_request ', ' Record dosent exist for po_release_id = ' || p_po_release_id);
717: END IF;
718: END IF;
719: end if;

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

712: if (REL_CSR%NOTFOUND) then
713: CLOSE REL_CSR;
714: IF (g_fnd_debug = 'Y') THEN
715: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
716: FND_LOG.string(FND_LOG.level_error, g_module_prefix || 'process_supplier_request ', ' Record dosent exist for po_release_id = ' || p_po_release_id);
717: END IF;
718: END IF;
719: end if;
720: CLOSE REL_CSR;

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

738: l_last_upd_date := poRec.last_update_date;
739: if (PO_CSR%NOTFOUND) then
740: CLOSE PO_CSR;
741: IF (g_fnd_debug = 'Y') THEN
742: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
743: FND_LOG.string(FND_LOG.level_error, g_module_prefix || 'process_supplier_request', 'Record dosent exist for po_header_id = ' || p_po_header_id);
744: END IF;
745: END IF;
746: end if;

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

739: if (PO_CSR%NOTFOUND) then
740: CLOSE PO_CSR;
741: IF (g_fnd_debug = 'Y') THEN
742: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
743: FND_LOG.string(FND_LOG.level_error, g_module_prefix || 'process_supplier_request', 'Record dosent exist for po_header_id = ' || p_po_header_id);
744: END IF;
745: END IF;
746: end if;
747: CLOSE PO_CSR;

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

778: -- Copy the request into a local var
779: l_po_change_requests := p_po_change_requests;
780:
781: IF g_fnd_debug = 'Y' THEN
782: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
783: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
784: '.invoked', 'Type: ' ||
785: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
786: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));

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

779: l_po_change_requests := p_po_change_requests;
780:
781: IF g_fnd_debug = 'Y' THEN
782: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
783: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
784: '.invoked', 'Type: ' ||
785: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
786: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));
787: END IF;

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

802: x_return_status := FND_API.g_ret_sts_unexp_error;
803:
804: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
805: IF g_fnd_debug = 'Y' THEN
806: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
807: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
808: l_api_name || fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ'), sqlcode);
809: END IF;
810: END IF;

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

803:
804: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
805: IF g_fnd_debug = 'Y' THEN
806: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
807: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
808: l_api_name || fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ'), sqlcode);
809: END IF;
810: END IF;
811:

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

966: x_return_status := FND_API.g_ret_sts_unexp_error;
967: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
968: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
969: IF g_fnd_debug = 'Y' THEN
970: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
971: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
972: l_api_name || '.others_exception', sqlcode);
973: END IF;
974: END IF;

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

967: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
968: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
969: IF g_fnd_debug = 'Y' THEN
970: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
971: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
972: l_api_name || '.others_exception', sqlcode);
973: END IF;
974: END IF;
975: END IF;

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

1003: end if; -- end if accept reject
1004: END LOOP;
1005: if ((callDocCheck) AND l_po_change_requests.count() > 0 ) then
1006: IF g_fnd_debug = 'Y' THEN
1007: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1008: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1009: '.invoked', ' Change Count : ' || TO_CHAR(l_po_change_requests.count()));
1010: END IF;
1011: END IF;

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

1004: END LOOP;
1005: if ((callDocCheck) AND l_po_change_requests.count() > 0 ) then
1006: IF g_fnd_debug = 'Y' THEN
1007: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1008: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1009: '.invoked', ' Change Count : ' || TO_CHAR(l_po_change_requests.count()));
1010: END IF;
1011: END IF;
1012: validate_change_request (

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

1024: end if;
1025:
1026: if (l_po_change_requests.count() > 0 AND x_return_status = FND_API.G_RET_STS_SUCCESS) then
1027: IF g_fnd_debug = 'Y' THEN
1028: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1029: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1030: '.invoked', 'Type: ' ||
1031: ', Save Count : ' || TO_CHAR(l_po_change_requests.count()));
1032: END IF;

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

1025:
1026: if (l_po_change_requests.count() > 0 AND x_return_status = FND_API.G_RET_STS_SUCCESS) then
1027: IF g_fnd_debug = 'Y' THEN
1028: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1029: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1030: '.invoked', 'Type: ' ||
1031: ', Save Count : ' || TO_CHAR(l_po_change_requests.count()));
1032: END IF;
1033: END IF;

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

1054: end if;
1055:
1056: if(updatePoAttr) then
1057: IF g_fnd_debug = 'Y' THEN
1058: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1059: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1060: '.invoked', 'Update PO ' ||
1061: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
1062: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));

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

1055:
1056: if(updatePoAttr) then
1057: IF g_fnd_debug = 'Y' THEN
1058: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1059: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1060: '.invoked', 'Update PO ' ||
1061: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
1062: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));
1063: END IF;

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

1082:
1083:
1084: if (callWf) then
1085: IF g_fnd_debug = 'Y' THEN
1086: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1087: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1088: '.invoked', 'Call Workflow ' || ', request group id ' || to_char(l_request_group_id));
1089: END IF;
1090: END IF;

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

1083:
1084: if (callWf) then
1085: IF g_fnd_debug = 'Y' THEN
1086: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1087: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1088: '.invoked', 'Call Workflow ' || ', request group id ' || to_char(l_request_group_id));
1089: END IF;
1090: END IF;
1091: --start multiple po change

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

1098: end if;
1099:
1100: if(x_return_status = FND_API.G_TRUE) then
1101: IF g_fnd_debug = 'Y' THEN
1102: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1103: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1104: '.invoked', ' All shipments acked/changed ' );
1105: END IF;
1106: END IF;

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

1099:
1100: if(x_return_status = FND_API.G_TRUE) then
1101: IF g_fnd_debug = 'Y' THEN
1102: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1103: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1104: '.invoked', ' All shipments acked/changed ' );
1105: END IF;
1106: END IF;
1107: else

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

1118:
1119: x_return_status := startSupplierWF( p_po_header_id,p_po_release_id,
1120: p_revision_num, l_request_group_id, x_accp_flag);
1121: IF g_fnd_debug = 'Y' THEN
1122: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1123: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1124: '.invoked', 'Call Workflow ' || ', Return Status ' || x_return_status);
1125: END IF;
1126: END IF;

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

1119: x_return_status := startSupplierWF( p_po_header_id,p_po_release_id,
1120: p_revision_num, l_request_group_id, x_accp_flag);
1121: IF g_fnd_debug = 'Y' THEN
1122: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1123: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1124: '.invoked', 'Call Workflow ' || ', Return Status ' || x_return_status);
1125: END IF;
1126: END IF;
1127: end if;

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

1166: x_return_status := FND_API.g_ret_sts_unexp_error;
1167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1168: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1169: IF g_fnd_debug = 'Y' THEN
1170: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1171: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1172: l_api_name || '.others_exception', sqlcode);
1173: END IF;
1174: END IF;

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

1167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1168: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1169: IF g_fnd_debug = 'Y' THEN
1170: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1171: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1172: l_api_name || '.others_exception', sqlcode);
1173: END IF;
1174: END IF;
1175: END IF;

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

1327: x_return_status := FND_API.g_ret_sts_unexp_error;
1328: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1329: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1330: IF g_fnd_debug = 'Y' THEN
1331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1332: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1333: l_api_name || '.others_exception', sqlcode);
1334: END IF;
1335: END IF;

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

1328: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1329: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1330: IF g_fnd_debug = 'Y' THEN
1331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1332: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1333: l_api_name || '.others_exception', sqlcode);
1334: END IF;
1335: END IF;
1336: END IF;

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

1467: END IF;
1468:
1469: x_return_status := FND_API.g_ret_sts_success;
1470: IF g_fnd_debug = 'Y' THEN
1471: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1472: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1473: '.invoked', 'Type: ' ||
1474: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
1475: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));

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

1468:
1469: x_return_status := FND_API.g_ret_sts_success;
1470: IF g_fnd_debug = 'Y' THEN
1471: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1472: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1473: '.invoked', 'Type: ' ||
1474: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
1475: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));
1476: END IF;

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

1680: amountTbl(lLine+1) := null;
1681:
1682:
1683: IF g_fnd_debug = 'Y' THEN
1684: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1685: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name
1686: , 'Calculating Price break for STD PO from GA: ' ||
1687: ', PO Line Id : ' || NVL(TO_CHAR(l_ga_lineId),'null') ||
1688: ', Total Quantity : ' || NVL(TO_CHAR(l_total_qty),'null') ||

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

1681:
1682:
1683: IF g_fnd_debug = 'Y' THEN
1684: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1685: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name
1686: , 'Calculating Price break for STD PO from GA: ' ||
1687: ', PO Line Id : ' || NVL(TO_CHAR(l_ga_lineId),'null') ||
1688: ', Total Quantity : ' || NVL(TO_CHAR(l_total_qty),'null') ||
1689: ', Price Break : ' || NVL(TO_CHAR(x_price),'null'));

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

1813: x_return_status := FND_API.g_ret_sts_unexp_error;
1814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1815: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1816: IF g_fnd_debug = 'Y' THEN
1817: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1818: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1819: l_api_name || '.others_exception', sqlcode);
1820: END IF;
1821: END IF;

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

1814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1815: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1816: IF g_fnd_debug = 'Y' THEN
1817: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1818: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1819: l_api_name || '.others_exception', sqlcode);
1820: END IF;
1821: END IF;
1822: END IF;

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

2000:
2001: -- Call this when logging is enabled
2002:
2003: IF g_fnd_debug = 'Y' THEN
2004: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2005: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2006: '.invoked', 'Type: ' ||
2007: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
2008: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));

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

2001: -- Call this when logging is enabled
2002:
2003: IF g_fnd_debug = 'Y' THEN
2004: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2005: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
2006: '.invoked', 'Type: ' ||
2007: ', Header ID: ' || NVL(TO_CHAR(p_po_header_id),'null') ||
2008: ', Release ID: ' || NVL(TO_CHAR(p_po_release_id),'null'));
2009: END IF;

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

2118: x_return_status := FND_API.g_ret_sts_unexp_error;
2119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2120: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2121: IF g_fnd_debug = 'Y' THEN
2122: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2123: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2124: l_api_name || '.others_exception', sqlcode);
2125: END IF;
2126: END IF;

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

2119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2120: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2121: IF g_fnd_debug = 'Y' THEN
2122: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2123: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2124: l_api_name || '.others_exception', sqlcode);
2125: END IF;
2126: END IF;
2127: END IF;

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

2140: x_return_status := FND_API.g_ret_sts_unexp_error;
2141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2142: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2143: IF g_fnd_debug = 'Y' THEN
2144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2145: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2146: l_api_name || '.others_exception', sqlcode);
2147: END IF;
2148: END IF;

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

2141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2142: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2143: IF g_fnd_debug = 'Y' THEN
2144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2145: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2146: l_api_name || '.others_exception', sqlcode);
2147: END IF;
2148: END IF;
2149: END IF;

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

2387:
2388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2389: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2390: IF g_fnd_debug = 'Y' THEN
2391: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2392: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2393: l_api_name || '.others exception' ,sqlcode);
2394: END IF;
2395: END IF;

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

2388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2389: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2390: IF g_fnd_debug = 'Y' THEN
2391: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2392: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2393: l_api_name || '.others exception' ,sqlcode);
2394: END IF;
2395: END IF;
2396: END IF;

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

2711: po_sup_chg_request_wf_grp.Buyer_CancelDocWithChn(
2712: 1.0,l_return_status,p_po_header_id,p_po_release_id,xRevNum,xGrpId,l_msg_out);
2713: if (l_return_status <> 'S') then
2714: IF (g_fnd_debug = 'Y') THEN
2715: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2716: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2717: l_api_name || '.call buyer cancel workflow', l_msg_out);
2718: END IF;
2719: END IF;

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

2712: 1.0,l_return_status,p_po_header_id,p_po_release_id,xRevNum,xGrpId,l_msg_out);
2713: if (l_return_status <> 'S') then
2714: IF (g_fnd_debug = 'Y') THEN
2715: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2716: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2717: l_api_name || '.call buyer cancel workflow', l_msg_out);
2718: END IF;
2719: END IF;
2720: end if;

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

2732: x_return_status := FND_API.g_ret_sts_unexp_error;
2733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2734: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2735: IF (g_fnd_debug = 'Y') THEN
2736: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2737: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2738: l_api_name || '.others_exception', 'Exception');
2739: END IF;
2740: END IF;

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

2733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2734: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2735: IF (g_fnd_debug = 'Y') THEN
2736: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2737: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2738: l_api_name || '.others_exception', 'Exception');
2739: END IF;
2740: END IF;
2741: END IF;

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

2854: x_notification_id := getSigNotifId(l_item_type, l_item_key);
2855: if x_notification_id is null then
2856: RAISE sig_notif_notfound;
2857: end if;
2858: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2859: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
2860: l_item_key || '.Notification :' || to_char(x_notification_id) ,sqlcode);
2861: END IF;
2862:

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

2855: if x_notification_id is null then
2856: RAISE sig_notif_notfound;
2857: end if;
2858: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2859: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
2860: l_item_key || '.Notification :' || to_char(x_notification_id) ,sqlcode);
2861: END IF;
2862:
2863: return;

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

2942: WHEN FND_API.g_exc_unexpected_error THEN
2943: x_return_status := FND_API.g_ret_sts_unexp_error;
2944: WHEN sig_notif_notfound THEN
2945: IF g_fnd_debug = 'Y' THEN
2946: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2947: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
2948: l_item_key || '.Notification not found exception' ,sqlcode);
2949: END IF;
2950: END IF;

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

2943: x_return_status := FND_API.g_ret_sts_unexp_error;
2944: WHEN sig_notif_notfound THEN
2945: IF g_fnd_debug = 'Y' THEN
2946: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2947: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
2948: l_item_key || '.Notification not found exception' ,sqlcode);
2949: END IF;
2950: END IF;
2951: x_return_status := FND_API.g_ret_sts_error;

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

2953: x_return_status := FND_API.g_ret_sts_unexp_error;
2954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2955: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2956: IF g_fnd_debug = 'Y' THEN
2957: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2958: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2959: l_api_name || '.others exception' ,sqlcode);
2960: END IF;
2961: END IF;

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

2954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2955: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2956: IF g_fnd_debug = 'Y' THEN
2957: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2958: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2959: l_api_name || '.others exception' ,sqlcode);
2960: END IF;
2961: END IF;
2962: END IF;