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 262: FND_MSG_PUB.initialize;

258: END IF;
259:
260: /** Initialize message list **/
261: IF fnd_api.to_boolean(l_Init_Msg_List) THEN
262: FND_MSG_PUB.initialize;
263: END IF;
264:
265: /** Initialize return status **/
266: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 449: FND_MSG_PUB.ADD;

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

Line 532: FND_MSG_PUB.ADD;

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

Line 624: FND_MSG_PUB.ADD;

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

Line 759: FND_MSG_PUB.ADD;

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

Line 822: fnd_msg_pub.add;

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

Line 1224: FND_MSG_PUB.ADD;

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

Line 1358: fnd_msg_pub.add;

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

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

1464: COMMIT WORK;
1465: END IF;
1466:
1467: /** Standard call to get message count and if count is 1, get message info. **/
1468: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1469: p_data => x_msg_data
1470: );
1471: /** Errbuf returns error messages and
1472: Retcode returns 0 = Success, 1 = Success with warnings, 2 = Error

Line 1487: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1483:
1484: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1485: P_API_NAME => L_API_NAME
1486: ,P_PKG_NAME => G_PKG_NAME
1487: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1488: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1489: ,P_ROLLBACK_FLAG => l_Rollback
1490: ,X_MSG_COUNT => X_MSG_COUNT
1491: ,X_MSG_DATA => X_MSG_DATA

Line 1502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1498:
1499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1500: P_API_NAME => L_API_NAME
1501: ,P_PKG_NAME => G_PKG_NAME
1502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1504: ,P_ROLLBACK_FLAG => l_Rollback
1505: ,X_MSG_COUNT => X_MSG_COUNT
1506: ,X_MSG_DATA => X_MSG_DATA

Line 1522: fnd_msg_pub.add;

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

Line 1694: FND_MSG_PUB.initialize;

1690: END IF;
1691:
1692: /** Initialize message list **/
1693: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1694: FND_MSG_PUB.initialize;
1695: END IF;
1696:
1697: /** Initialize return status **/
1698: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1730: FND_MSG_PUB.ADD;

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

Line 1737: FND_MSG_PUB.ADD;

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

Line 1940: FND_MSG_PUB.ADD;

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

Line 1949: fnd_msg_pub.add;

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

Line 2133: FND_MSG_PUB.Count_And_Get

2129:
2130: x_return_status := l_return_status;
2131:
2132: /** Standard call to get message count and if count is 1, get message info */
2133: FND_MSG_PUB.Count_And_Get
2134: (p_count => x_msg_count,
2135: p_data => x_msg_data
2136: );
2137:

Line 2155: fnd_msg_pub.count_and_get

2151:
2152: /** This returns 'E' as status **/
2153: x_return_status := FND_API.G_RET_STS_ERROR;
2154:
2155: fnd_msg_pub.count_and_get
2156: (p_count => x_msg_count
2157: ,p_data => x_msg_data);
2158:
2159: WHEN FND_API.G_EXC_ERROR THEN

Line 2165: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2161:
2162: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2163: P_API_NAME => L_API_NAME
2164: ,P_PKG_NAME => G_PKG_NAME
2165: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2166: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2167: ,P_ROLLBACK_FLAG => l_Rollback
2168: ,X_MSG_COUNT => X_MSG_COUNT
2169: ,X_MSG_DATA => X_MSG_DATA

Line 2178: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2174:
2175: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2176: P_API_NAME => L_API_NAME
2177: ,P_PKG_NAME => G_PKG_NAME
2178: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2179: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2180: ,P_ROLLBACK_FLAG => l_Rollback
2181: ,X_MSG_COUNT => X_MSG_COUNT
2182: ,X_MSG_DATA => X_MSG_DATA

Line 2191: FND_MSG_PUB.ADD;

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

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

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

Line 2194: fnd_msg_pub.count_and_get

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
2195: (p_count => x_msg_count
2196: ,p_data => x_msg_data);
2197:
2198: /** This returns 'U' as status **/