DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_PVT dependencies on FND_MESSAGE

Line 447: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');

443: );
444:
445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
446: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_RESERVED_LINES_rec.defective_organization_id);
447: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');
448: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_ORG_NAME,TRUE);
449: FND_MSG_PUB.ADD;
450: Add_Err_Msg;
451: g_retcode := 1;

Line 448: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_ORG_NAME,TRUE);

444:
445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
446: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_RESERVED_LINES_rec.defective_organization_id);
447: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');
448: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_ORG_NAME,TRUE);
449: FND_MSG_PUB.ADD;
450: Add_Err_Msg;
451: g_retcode := 1;
452: END IF;

Line 530: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');

526: End if;
527:
528: If l_ship_to_location_id is null then
529: L_ORGANIZATION_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(l_dest_organization_id);
530: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');
531: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_ORGANIZATION_NAME, TRUE);
532: FND_MSG_PUB.ADD;
533: Add_Err_Msg;
534: g_retcode := 1;

Line 531: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_ORGANIZATION_NAME, TRUE);

527:
528: If l_ship_to_location_id is null then
529: L_ORGANIZATION_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(l_dest_organization_id);
530: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');
531: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_ORGANIZATION_NAME, TRUE);
532: FND_MSG_PUB.ADD;
533: Add_Err_Msg;
534: g_retcode := 1;
535: End if;

Line 622: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');

618: );
619:
620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
621: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
622: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
623: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
624: FND_MSG_PUB.ADD;
625: Add_Err_Msg;
626: g_retcode := 1;

Line 623: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);

619:
620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
621: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
622: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
623: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
624: FND_MSG_PUB.ADD;
625: Add_Err_Msg;
626: g_retcode := 1;
627: END IF;

Line 757: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_WIP_CLASS_CODE');

753: End;
754:
755: If L_CLASS_CODE is null then
756: L_ORGANIZATION_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
757: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_WIP_CLASS_CODE');
758: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_ORGANIZATION_NAME, TRUE);
759: FND_MSG_PUB.ADD;
760: Add_Err_Msg;
761: g_retcode := 1;

Line 758: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_ORGANIZATION_NAME, TRUE);

754:
755: If L_CLASS_CODE is null then
756: L_ORGANIZATION_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
757: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_WIP_CLASS_CODE');
758: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_ORGANIZATION_NAME, TRUE);
759: FND_MSG_PUB.ADD;
760: Add_Err_Msg;
761: g_retcode := 1;
762: End if;

Line 819: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

815: l_sqlcode := SQLCODE;
816: l_sqlerrm := SQLERRM;
817: g_retcode := 1;
818: errbuf := SQLERRM;
819: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
820: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
821: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
822: fnd_msg_pub.add;
823: Add_Err_Msg;

Line 820: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

816: l_sqlerrm := SQLERRM;
817: g_retcode := 1;
818: errbuf := SQLERRM;
819: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
820: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
821: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
822: fnd_msg_pub.add;
823: Add_Err_Msg;
824: Rollback to RUN_REPAIR_EXECUTION_PVT;

Line 821: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);

817: g_retcode := 1;
818: errbuf := SQLERRM;
819: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
820: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
821: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
822: fnd_msg_pub.add;
823: Add_Err_Msg;
824: Rollback to RUN_REPAIR_EXECUTION_PVT;
825: End;

Line 1222: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');

1218: );
1219:
1220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1221: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
1222: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');
1223: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
1224: FND_MSG_PUB.ADD;
1225: Add_Err_Msg;
1226: g_retcode := 1;

Line 1223: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);

1219:
1220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1221: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
1222: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');
1223: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
1224: FND_MSG_PUB.ADD;
1225: Add_Err_Msg;
1226: g_retcode := 1;
1227: END IF;

Line 1355: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1351: l_sqlcode := SQLCODE;
1352: l_sqlerrm := SQLERRM;
1353: g_retcode := 1;
1354: errbuf := SQLERRM;
1355: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1356: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1357: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1358: fnd_msg_pub.add;
1359: Add_Err_Msg;

Line 1356: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

1352: l_sqlerrm := SQLERRM;
1353: g_retcode := 1;
1354: errbuf := SQLERRM;
1355: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1356: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1357: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1358: fnd_msg_pub.add;
1359: Add_Err_Msg;
1360: Rollback to RUN_REPAIR_EXECUTION_PVT;

Line 1357: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);

1353: g_retcode := 1;
1354: errbuf := SQLERRM;
1355: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1356: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1357: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1358: fnd_msg_pub.add;
1359: Add_Err_Msg;
1360: Rollback to RUN_REPAIR_EXECUTION_PVT;
1361: End;

Line 1519: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1515: l_sqlerrm := SQLERRM;
1516: retcode := 2;
1517: errbuf := SQLERRM;
1518:
1519: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1520: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1521: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1522: fnd_msg_pub.add;
1523: Add_Err_Msg;

Line 1520: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

1516: retcode := 2;
1517: errbuf := SQLERRM;
1518:
1519: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1520: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1521: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1522: fnd_msg_pub.add;
1523: Add_Err_Msg;
1524:

Line 1521: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);

1517: errbuf := SQLERRM;
1518:
1519: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1520: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1521: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1522: fnd_msg_pub.add;
1523: Add_Err_Msg;
1524:
1525: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 1728: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');

1724: ,x_msg_count
1725: );
1726: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1727: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_SCRAP_rec.repair_supplier_org_id);
1728: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
1729: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
1730: FND_MSG_PUB.ADD;
1731: RAISE EXCP_USER_DEFINED;
1732: END IF;

Line 1729: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);

1725: );
1726: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1727: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_SCRAP_rec.repair_supplier_org_id);
1728: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
1729: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
1730: FND_MSG_PUB.ADD;
1731: RAISE EXCP_USER_DEFINED;
1732: END IF;
1733:

Line 1735: FND_MESSAGE.SET_NAME ('CSP','CSP_NOAVAIL_QTY_TO_SCRAP_ADJUST'); /* Not enough quantity to do scrap or adjustment transaction from WIP job*/

1731: RAISE EXCP_USER_DEFINED;
1732: END IF;
1733:
1734: If nvl(L_SCRAP_ADJUST_QTY,0) > least(Balance_due_qty,Available_scrap_qty) then
1735: FND_MESSAGE.SET_NAME ('CSP','CSP_NOAVAIL_QTY_TO_SCRAP_ADJUST'); /* Not enough quantity to do scrap or adjustment transaction from WIP job*/
1736: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', X_ITEM_NUMBER,TRUE);
1737: FND_MSG_PUB.ADD;
1738: RAISE EXCP_USER_DEFINED;
1739: Else

Line 1736: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', X_ITEM_NUMBER,TRUE);

1732: END IF;
1733:
1734: If nvl(L_SCRAP_ADJUST_QTY,0) > least(Balance_due_qty,Available_scrap_qty) then
1735: FND_MESSAGE.SET_NAME ('CSP','CSP_NOAVAIL_QTY_TO_SCRAP_ADJUST'); /* Not enough quantity to do scrap or adjustment transaction from WIP job*/
1736: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', X_ITEM_NUMBER,TRUE);
1737: FND_MSG_PUB.ADD;
1738: RAISE EXCP_USER_DEFINED;
1739: Else
1740: l_defective_subinv := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_DEFECT_SUBINV');

Line 1938: FND_MESSAGE.SET_NAME ('CSP','CSP_INSERT_WIPJOB_ERROR');

1934: WHERE WIP_ENTITY_ID = CSP_REPAIR_PO_SCRAP_rec.WIP_ID;
1935: Exception
1936: When others then
1937: /*
1938: FND_MESSAGE.SET_NAME ('CSP','CSP_INSERT_WIPJOB_ERROR');
1939: FND_MESSAGE.SET_TOKEN ('WIP_ID',CSP_REPAIR_PO_SCRAP_rec.WIP_ID ,TRUE);
1940: FND_MSG_PUB.ADD;
1941: RAISE EXCP_USER_DEFINED;
1942: */

Line 1939: FND_MESSAGE.SET_TOKEN ('WIP_ID',CSP_REPAIR_PO_SCRAP_rec.WIP_ID ,TRUE);

1935: Exception
1936: When others then
1937: /*
1938: FND_MESSAGE.SET_NAME ('CSP','CSP_INSERT_WIPJOB_ERROR');
1939: FND_MESSAGE.SET_TOKEN ('WIP_ID',CSP_REPAIR_PO_SCRAP_rec.WIP_ID ,TRUE);
1940: FND_MSG_PUB.ADD;
1941: RAISE EXCP_USER_DEFINED;
1942: */
1943: /*

Line 1946: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1942: */
1943: /*
1944: l_sqlcode := SQLCODE;
1945: l_sqlerrm := SQLERRM;
1946: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1947: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1948: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1949: fnd_msg_pub.add;
1950: RAISE EXCP_USER_DEFINED;

Line 1947: fnd_message.set_token('ROUTINE', l_api_name, TRUE);

1943: /*
1944: l_sqlcode := SQLCODE;
1945: l_sqlerrm := SQLERRM;
1946: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1947: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1948: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1949: fnd_msg_pub.add;
1950: RAISE EXCP_USER_DEFINED;
1951: End;

Line 1948: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);

1944: l_sqlcode := SQLCODE;
1945: l_sqlerrm := SQLERRM;
1946: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1947: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1948: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1949: fnd_msg_pub.add;
1950: RAISE EXCP_USER_DEFINED;
1951: End;
1952: ---------------End comment on NOV-29-2005 --------

Line 2188: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2184:
2185: WHEN OTHERS THEN
2186: Rollback to REPAIR_PO_SCRAP_PVT;
2187:
2188: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2189: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2190: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2191: FND_MSG_PUB.ADD;
2192: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);

Line 2189: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

2185: WHEN OTHERS THEN
2186: Rollback to REPAIR_PO_SCRAP_PVT;
2187:
2188: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2189: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2190: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2191: FND_MSG_PUB.ADD;
2192: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
2193:

Line 2190: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

2186: Rollback to REPAIR_PO_SCRAP_PVT;
2187:
2188: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2189: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2190: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2191: FND_MSG_PUB.ADD;
2192: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
2193:
2194: fnd_msg_pub.count_and_get