DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_PVT dependencies on FND_MESSAGE

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

404: );
405:
406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
407: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_RESERVED_LINES_rec.defective_organization_id);
408: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');
409: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_ORG_NAME,TRUE);
410: FND_MSG_PUB.ADD;
411: Add_Err_Msg;
412: g_retcode := 1;

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

405:
406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
407: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_RESERVED_LINES_rec.defective_organization_id);
408: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');
409: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_ORG_NAME,TRUE);
410: FND_MSG_PUB.ADD;
411: Add_Err_Msg;
412: g_retcode := 1;
413: END IF;

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

487: End if;
488:
489: If l_ship_to_location_id is null then
490: L_ORGANIZATION_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(l_dest_organization_id);
491: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');
492: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_ORGANIZATION_NAME, TRUE);
493: FND_MSG_PUB.ADD;
494: Add_Err_Msg;
495: g_retcode := 1;

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

488:
489: If l_ship_to_location_id is null then
490: L_ORGANIZATION_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(l_dest_organization_id);
491: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');
492: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_ORGANIZATION_NAME, TRUE);
493: FND_MSG_PUB.ADD;
494: Add_Err_Msg;
495: g_retcode := 1;
496: End if;

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

579: );
580:
581: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
582: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
583: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
584: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
585: FND_MSG_PUB.ADD;
586: Add_Err_Msg;
587: g_retcode := 1;

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

580:
581: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
582: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
583: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
584: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
585: FND_MSG_PUB.ADD;
586: Add_Err_Msg;
587: g_retcode := 1;
588: END IF;

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

612: End;
613:
614: If L_CLASS_CODE is null then
615: L_ORGANIZATION_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
616: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_WIP_CLASS_CODE');
617: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_ORGANIZATION_NAME, TRUE);
618: FND_MSG_PUB.ADD;
619: Add_Err_Msg;
620: g_retcode := 1;

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

613:
614: If L_CLASS_CODE is null then
615: L_ORGANIZATION_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
616: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_WIP_CLASS_CODE');
617: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_ORGANIZATION_NAME, TRUE);
618: FND_MSG_PUB.ADD;
619: Add_Err_Msg;
620: g_retcode := 1;
621: End if;

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

672: l_sqlcode := SQLCODE;
673: l_sqlerrm := SQLERRM;
674: g_retcode := 1;
675: errbuf := SQLERRM;
676: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
677: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
678: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
679: fnd_msg_pub.add;
680: Add_Err_Msg;

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

673: l_sqlerrm := SQLERRM;
674: g_retcode := 1;
675: errbuf := SQLERRM;
676: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
677: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
678: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
679: fnd_msg_pub.add;
680: Add_Err_Msg;
681: Rollback to RUN_REPAIR_EXECUTION_PVT;

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

674: g_retcode := 1;
675: errbuf := SQLERRM;
676: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
677: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
678: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
679: fnd_msg_pub.add;
680: Add_Err_Msg;
681: Rollback to RUN_REPAIR_EXECUTION_PVT;
682: End;

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

969: );
970:
971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
972: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
973: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');
974: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
975: FND_MSG_PUB.ADD;
976: Add_Err_Msg;
977: g_retcode := 1;

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

970:
971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
972: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
973: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');
974: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
975: FND_MSG_PUB.ADD;
976: Add_Err_Msg;
977: g_retcode := 1;
978: END IF;

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

1094: l_sqlcode := SQLCODE;
1095: l_sqlerrm := SQLERRM;
1096: g_retcode := 1;
1097: errbuf := SQLERRM;
1098: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1099: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1100: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1101: fnd_msg_pub.add;
1102: Add_Err_Msg;

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

1095: l_sqlerrm := SQLERRM;
1096: g_retcode := 1;
1097: errbuf := SQLERRM;
1098: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1099: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1100: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1101: fnd_msg_pub.add;
1102: Add_Err_Msg;
1103: Rollback to RUN_REPAIR_EXECUTION_PVT;

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

1096: g_retcode := 1;
1097: errbuf := SQLERRM;
1098: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1099: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1100: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1101: fnd_msg_pub.add;
1102: Add_Err_Msg;
1103: Rollback to RUN_REPAIR_EXECUTION_PVT;
1104: End;

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

1257: l_sqlerrm := SQLERRM;
1258: retcode := 2;
1259: errbuf := SQLERRM;
1260:
1261: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1262: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1263: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1264: fnd_msg_pub.add;
1265: Add_Err_Msg;

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

1258: retcode := 2;
1259: errbuf := SQLERRM;
1260:
1261: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1262: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1263: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1264: fnd_msg_pub.add;
1265: Add_Err_Msg;
1266:

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

1259: errbuf := SQLERRM;
1260:
1261: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1262: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1263: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1264: fnd_msg_pub.add;
1265: Add_Err_Msg;
1266:
1267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

1426: ,x_msg_count
1427: );
1428: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1429: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_SCRAP_rec.repair_supplier_org_id);
1430: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
1431: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
1432: FND_MSG_PUB.ADD;
1433: RAISE EXCP_USER_DEFINED;
1434: END IF;

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

1427: );
1428: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1429: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_SCRAP_rec.repair_supplier_org_id);
1430: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
1431: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
1432: FND_MSG_PUB.ADD;
1433: RAISE EXCP_USER_DEFINED;
1434: END IF;
1435:

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

1433: RAISE EXCP_USER_DEFINED;
1434: END IF;
1435:
1436: If nvl(L_SCRAP_ADJUST_QTY,0) > least(Balance_due_qty,Available_scrap_qty) then
1437: FND_MESSAGE.SET_NAME ('CSP','CSP_NOAVAIL_QTY_TO_SCRAP_ADJUST'); /* Not enough quantity to do scrap or adjustment transaction from WIP job*/
1438: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', X_ITEM_NUMBER,TRUE);
1439: FND_MSG_PUB.ADD;
1440: RAISE EXCP_USER_DEFINED;
1441: Else

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

1434: END IF;
1435:
1436: If nvl(L_SCRAP_ADJUST_QTY,0) > least(Balance_due_qty,Available_scrap_qty) then
1437: FND_MESSAGE.SET_NAME ('CSP','CSP_NOAVAIL_QTY_TO_SCRAP_ADJUST'); /* Not enough quantity to do scrap or adjustment transaction from WIP job*/
1438: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', X_ITEM_NUMBER,TRUE);
1439: FND_MSG_PUB.ADD;
1440: RAISE EXCP_USER_DEFINED;
1441: Else
1442: l_defective_subinv := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_DEFECT_SUBINV');

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

1629: WHERE WIP_ENTITY_ID = CSP_REPAIR_PO_SCRAP_rec.WIP_ID;
1630: Exception
1631: When others then
1632: /*
1633: FND_MESSAGE.SET_NAME ('CSP','CSP_INSERT_WIPJOB_ERROR');
1634: FND_MESSAGE.SET_TOKEN ('WIP_ID',CSP_REPAIR_PO_SCRAP_rec.WIP_ID ,TRUE);
1635: FND_MSG_PUB.ADD;
1636: RAISE EXCP_USER_DEFINED;
1637: */

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

1630: Exception
1631: When others then
1632: /*
1633: FND_MESSAGE.SET_NAME ('CSP','CSP_INSERT_WIPJOB_ERROR');
1634: FND_MESSAGE.SET_TOKEN ('WIP_ID',CSP_REPAIR_PO_SCRAP_rec.WIP_ID ,TRUE);
1635: FND_MSG_PUB.ADD;
1636: RAISE EXCP_USER_DEFINED;
1637: */
1638: /*

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

1637: */
1638: /*
1639: l_sqlcode := SQLCODE;
1640: l_sqlerrm := SQLERRM;
1641: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1642: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1643: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1644: fnd_msg_pub.add;
1645: RAISE EXCP_USER_DEFINED;

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

1638: /*
1639: l_sqlcode := SQLCODE;
1640: l_sqlerrm := SQLERRM;
1641: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1642: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1643: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1644: fnd_msg_pub.add;
1645: RAISE EXCP_USER_DEFINED;
1646: End;

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

1639: l_sqlcode := SQLCODE;
1640: l_sqlerrm := SQLERRM;
1641: fnd_message.set_name ('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1642: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1643: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1644: fnd_msg_pub.add;
1645: RAISE EXCP_USER_DEFINED;
1646: End;
1647: ---------------End comment on NOV-29-2005 --------

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

1758:
1759: WHEN OTHERS THEN
1760: Rollback to REPAIR_PO_SCRAP_PVT;
1761:
1762: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1763: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1764: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1765: FND_MSG_PUB.ADD;
1766: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);

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

1759: WHEN OTHERS THEN
1760: Rollback to REPAIR_PO_SCRAP_PVT;
1761:
1762: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1763: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1764: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1765: FND_MSG_PUB.ADD;
1766: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
1767:

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

1760: Rollback to REPAIR_PO_SCRAP_PVT;
1761:
1762: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1763: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1764: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1765: FND_MSG_PUB.ADD;
1766: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
1767:
1768: fnd_msg_pub.count_and_get