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.CSP_REPAIR_PO_PVT dependencies on FND_MSG_PUB

Line 20: If fnd_msg_pub.count_msg > 0 Then

16: l_msg_index_out NUMBER;
17: x_msg_data_temp Varchar2(2000);
18: x_msg_data Varchar2(4000);
19: Begin
20: If fnd_msg_pub.count_msg > 0 Then
21: FOR i IN REVERSE 1..fnd_msg_pub.count_msg
22: Loop
23: fnd_msg_pub.get(p_msg_index => i,
24: p_encoded => 'F',

Line 21: FOR i IN REVERSE 1..fnd_msg_pub.count_msg

17: x_msg_data_temp Varchar2(2000);
18: x_msg_data Varchar2(4000);
19: Begin
20: If fnd_msg_pub.count_msg > 0 Then
21: FOR i IN REVERSE 1..fnd_msg_pub.count_msg
22: Loop
23: fnd_msg_pub.get(p_msg_index => i,
24: p_encoded => 'F',
25: p_data => x_msg_data_temp,

Line 23: fnd_msg_pub.get(p_msg_index => i,

19: Begin
20: If fnd_msg_pub.count_msg > 0 Then
21: FOR i IN REVERSE 1..fnd_msg_pub.count_msg
22: Loop
23: fnd_msg_pub.get(p_msg_index => i,
24: p_encoded => 'F',
25: p_data => x_msg_data_temp,
26: p_msg_index_out => l_msg_index_out);
27: x_msg_data := x_msg_data || x_msg_data_temp;

Line 30: fnd_msg_pub.delete_msg;

26: p_msg_index_out => l_msg_index_out);
27: x_msg_data := x_msg_data || x_msg_data_temp;
28: End Loop;
29: FND_FILE.put_line(FND_FILE.log,x_msg_data);
30: fnd_msg_pub.delete_msg;
31: End if;
32: End;
33:
34: PROCEDURE RUN_REPAIR_EXECUTION

Line 223: FND_MSG_PUB.initialize;

219: END IF;
220:
221: /** Initialize message list **/
222: IF fnd_api.to_boolean(l_Init_Msg_List) THEN
223: FND_MSG_PUB.initialize;
224: END IF;
225:
226: /** Initialize return status **/
227: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 410: FND_MSG_PUB.ADD;

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;
414:

Line 493: FND_MSG_PUB.ADD;

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;
497:

Line 585: FND_MSG_PUB.ADD;

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;
589:

Line 618: FND_MSG_PUB.ADD;

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;
622:

Line 679: fnd_msg_pub.add;

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;
683:

Line 975: FND_MSG_PUB.ADD;

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;
979:

Line 1101: fnd_msg_pub.add;

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;
1105: --------------------- End comment on Nov-29-2005 -----------------

Line 1210: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1206: COMMIT WORK;
1207: END IF;
1208:
1209: /** Standard call to get message count and if count is 1, get message info. **/
1210: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1211: p_data => x_msg_data
1212: );
1213: /** Errbuf returns error messages and
1214: Retcode returns 0 = Success, 1 = Success with warnings, 2 = Error

Line 1229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1225:
1226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1227: P_API_NAME => L_API_NAME
1228: ,P_PKG_NAME => G_PKG_NAME
1229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1231: ,P_ROLLBACK_FLAG => l_Rollback
1232: ,X_MSG_COUNT => X_MSG_COUNT
1233: ,X_MSG_DATA => X_MSG_DATA

Line 1244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1240:
1241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1242: P_API_NAME => L_API_NAME
1243: ,P_PKG_NAME => G_PKG_NAME
1244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1246: ,P_ROLLBACK_FLAG => l_Rollback
1247: ,X_MSG_COUNT => X_MSG_COUNT
1248: ,X_MSG_DATA => X_MSG_DATA

Line 1264: fnd_msg_pub.add;

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(
1268: P_API_NAME => L_API_NAME

Line 1396: FND_MSG_PUB.initialize;

1392: END IF;
1393:
1394: /** Initialize message list **/
1395: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1396: FND_MSG_PUB.initialize;
1397: END IF;
1398:
1399: /** Initialize return status **/
1400: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1432: FND_MSG_PUB.ADD;

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:
1436: If nvl(L_SCRAP_ADJUST_QTY,0) > least(Balance_due_qty,Available_scrap_qty) then

Line 1439: FND_MSG_PUB.ADD;

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');
1443:

Line 1635: FND_MSG_PUB.ADD;

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: /*
1639: l_sqlcode := SQLCODE;

Line 1644: fnd_msg_pub.add;

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 --------
1648: */

Line 1707: FND_MSG_PUB.Count_And_Get

1703:
1704: x_return_status := l_return_status;
1705:
1706: /** Standard call to get message count and if count is 1, get message info */
1707: FND_MSG_PUB.Count_And_Get
1708: (p_count => x_msg_count,
1709: p_data => x_msg_data
1710: );
1711:

Line 1729: fnd_msg_pub.count_and_get

1725:
1726: /** This returns 'E' as status **/
1727: x_return_status := FND_API.G_RET_STS_ERROR;
1728:
1729: fnd_msg_pub.count_and_get
1730: (p_count => x_msg_count
1731: ,p_data => x_msg_data);
1732:
1733: WHEN FND_API.G_EXC_ERROR THEN

Line 1739: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1735:
1736: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1737: P_API_NAME => L_API_NAME
1738: ,P_PKG_NAME => G_PKG_NAME
1739: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1740: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1741: ,P_ROLLBACK_FLAG => l_Rollback
1742: ,X_MSG_COUNT => X_MSG_COUNT
1743: ,X_MSG_DATA => X_MSG_DATA

Line 1752: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1748:
1749: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1750: P_API_NAME => L_API_NAME
1751: ,P_PKG_NAME => G_PKG_NAME
1752: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1753: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1754: ,P_ROLLBACK_FLAG => l_Rollback
1755: ,X_MSG_COUNT => X_MSG_COUNT
1756: ,X_MSG_DATA => X_MSG_DATA

Line 1765: FND_MSG_PUB.ADD;

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
1769: (p_count => x_msg_count

Line 1766: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);

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
1769: (p_count => x_msg_count
1770: ,p_data => x_msg_data);

Line 1768: fnd_msg_pub.count_and_get

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
1769: (p_count => x_msg_count
1770: ,p_data => x_msg_data);
1771:
1772: /** This returns 'U' as status **/