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_AUTO_ASLMSL_PVT dependencies on FND_MSG_PUB

Line 137: FND_MSG_PUB.Count_And_Get

133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134:
135:
136: -- Standard call to get message count and if count is 1, get message info.
137: FND_MSG_PUB.Count_And_Get
138: ( p_count => x_msg_count,
139: p_data => x_msg_data
140: );
141:

Line 147: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

143: WHEN FND_API.G_EXC_ERROR THEN
144: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
145: P_API_NAME => L_API_NAME
146: ,P_PKG_NAME => G_PKG_NAME
147: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
148: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
149: ,P_ROLLBACK_FLAG => l_Rollback
150: ,X_MSG_COUNT => X_MSG_COUNT
151: ,X_MSG_DATA => X_MSG_DATA

Line 157: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
155: P_API_NAME => L_API_NAME
156: ,P_PKG_NAME => G_PKG_NAME
157: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
158: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
159: ,P_ROLLBACK_FLAG => l_Rollback
160: ,X_MSG_COUNT => X_MSG_COUNT
161: ,X_MSG_DATA => X_MSG_DATA

Line 184: If fnd_msg_pub.count_msg > 0 Then

180: l_msg_index_out NUMBER;
181: x_msg_data_temp Varchar2(2000);
182: x_msg_data Varchar2(4000);
183: Begin
184: If fnd_msg_pub.count_msg > 0 Then
185: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop
186: fnd_msg_pub.get(p_msg_index => i,
187: p_encoded => 'F',
188: p_data => x_msg_data_temp,

Line 185: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop

181: x_msg_data_temp Varchar2(2000);
182: x_msg_data Varchar2(4000);
183: Begin
184: If fnd_msg_pub.count_msg > 0 Then
185: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop
186: fnd_msg_pub.get(p_msg_index => i,
187: p_encoded => 'F',
188: p_data => x_msg_data_temp,
189: p_msg_index_out => l_msg_index_out);

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

182: x_msg_data Varchar2(4000);
183: Begin
184: If fnd_msg_pub.count_msg > 0 Then
185: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop
186: fnd_msg_pub.get(p_msg_index => i,
187: p_encoded => 'F',
188: p_data => x_msg_data_temp,
189: p_msg_index_out => l_msg_index_out);
190: x_msg_data := x_msg_data || x_msg_data_temp;

Line 193: fnd_msg_pub.delete_msg;

189: p_msg_index_out => l_msg_index_out);
190: x_msg_data := x_msg_data || x_msg_data_temp;
191: End Loop;
192: FND_FILE.put_line(FND_FILE.log,x_msg_data);
193: fnd_msg_pub.delete_msg;
194: End if;
195: End;
196:
197: PROCEDURE Generate_Recommendations (

Line 293: FND_MSG_PUB.initialize;

289:
290: -- Initialize message list if p_init_msg_list is set to TRUE.
291: IF FND_API.to_Boolean( l_init_msg_list )
292: THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295:
296:
297: -- Initialize API return status to SUCCESS

Line 331: fnd_msg_pub.add;

327: End If;
328: -- End If;
329: fnd_message.set_name('CSP','CSP_ASL_MSG');
330: fnd_message.set_token('VALUE','calculate_forecast');
331: fnd_msg_pub.add;
332: Add_Err_Msg;
333: -- Calculate New Product Planning
334: -- Re-establish Savepoint
335: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;

Line 350: fnd_msg_pub.add;

346: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
347: End If;
348: fnd_message.set_name('CSP','CSP_ASL_MSG');
349: fnd_message.set_token('VALUE','calculate_new_product_planning');
350: fnd_msg_pub.add;
351: Add_Err_Msg;
352: -- Calculate Product Norm
353: If l_pnorm_count > 0 Then
354: -- Re-establish Savepoint

Line 371: fnd_msg_pub.add;

367: End If;
368: End If;
369: fnd_message.set_name('CSP','CSP_ASL_MSG');
370: fnd_message.set_token('VALUE','calculate_product_norm');
371: fnd_msg_pub.add;
372: Add_Err_Msg;
373: -- Calculate Territory Norm
374: If l_tnorm_count > 0 Then
375: -- Re-establish Savepoint

Line 392: fnd_msg_pub.add;

388: End If;
389: End If;
390: fnd_message.set_name('CSP','CSP_ASL_MSG');
391: fnd_message.set_token('VALUE','calculate_territory_norm');
392: fnd_msg_pub.add;
393: Add_Err_Msg;
394: -- Re-establish Savepoint
395: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;
396: --- Create header records for Stock list items at Subinventory Level

Line 448: fnd_msg_pub.add;

444:
445: COMMIT;
446: fnd_message.set_name('CSP','CSP_ASL_MSG');
447: fnd_message.set_token('VALUE','Stock List Update');
448: fnd_msg_pub.add;
449: Add_Err_Msg;
450:
451: -- Re-establish Savepoint
452: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;

Line 506: fnd_msg_pub.add;

502: COMMIT;
503:
504: fnd_message.set_name('CSP','CSP_ASL_MSG');
505: fnd_message.set_token('VALUE','Insert Usage Headers Update');
506: fnd_msg_pub.add;
507: Add_Err_Msg;
508: -- Re-establish Savepoint
509: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;
510: INSERT INTO CSP_USAGE_HEADERS

Line 620: fnd_msg_pub.add;

616:
617: COMMIT;
618: fnd_message.set_name('CSP','CSP_ASL_MSG');
619: fnd_message.set_token('VALUE','Insert Usage Headers Update2');
620: fnd_msg_pub.add;
621: Add_Err_Msg;
622:
623: -- Re-establish Savepoint
624: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;

Line 640: fnd_msg_pub.add;

636:
637: COMMIT;
638: fnd_message.set_name('CSP','CSP_ASL_MSG');
639: fnd_message.set_token('VALUE','Excluded Items');
640: fnd_msg_pub.add;
641: Add_Err_Msg;
642:
643: -- Re-establish Savepoint
644: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;

Line 678: fnd_msg_pub.add;

674:
675: COMMIT;
676: fnd_message.set_name('CSP','CSP_ASL_MSG');
677: fnd_message.set_token('VALUE','Min Max');
678: fnd_msg_pub.add;
679: Add_Err_Msg;
680:
681: -- Re-establish Savepoint
682: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;

Line 714: fnd_msg_pub.add;

710:
711: COMMIT;
712: fnd_message.set_name('CSP','CSP_ASL_MSG');
713: fnd_message.set_token('VALUE','Min Max');
714: fnd_msg_pub.add;
715: Add_Err_Msg;
716:
717: -- Re-establish Savepoint
718: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;

Line 778: fnd_msg_pub.add;

774: and process_status = 'O';
775: COMMIT;
776: fnd_message.set_name('CSP','CSP_ASL_MSG');
777: fnd_message.set_token('VALUE','Tracking signal');
778: fnd_msg_pub.add;
779: Add_Err_Msg;
780:
781: -- Re-establish Savepoint
782: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;

Line 834: fnd_msg_pub.add;

830: End If;
831:
832: fnd_message.set_name('CSP','CSP_ASL_MSG');
833: fnd_message.set_token('VALUE','Apply Business Rules');
834: fnd_msg_pub.add;
835: Add_Err_Msg;
836: end if;
837: --
838: -- End of API body

Line 851: FND_MSG_PUB.Count_And_Get

847: EXECUTE IMMEDIATE 'ALTER MATERIALIZED VIEW CSP_USAGE_ORG_MV COMPILE';
848: EXECUTE IMMEDIATE 'ALTER MATERIALIZED VIEW CSP_USAGE_REG_MV COMPILE';
849:
850: -- Standard call to get message count and if count is 1, get message info.
851: FND_MSG_PUB.Count_And_Get
852: ( p_count => x_msg_count,
853: p_data => x_msg_data
854: );
855: retcode := 0;

Line 864: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

860: errbuf := X_Msg_Data;
861: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
862: P_API_NAME => L_API_NAME
863: ,P_PKG_NAME => G_PKG_NAME
864: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
865: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
866: ,P_ROLLBACK_FLAG => l_Rollback
867: ,X_MSG_COUNT => X_MSG_COUNT
868: ,X_MSG_DATA => X_MSG_DATA

Line 877: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

873: errbuf := X_Msg_Data;
874: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
875: P_API_NAME => L_API_NAME
876: ,P_PKG_NAME => G_PKG_NAME
877: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
878: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
879: ,P_ROLLBACK_FLAG => l_Rollback
880: ,X_MSG_COUNT => X_MSG_COUNT
881: ,X_MSG_DATA => X_MSG_DATA

Line 891: fnd_msg_pub.add;

887: retcode := 2;
888: errbuf := SQLERRM;
889: fnd_message.set_name('CSP','CSP_ASL_MSG');
890: fnd_message.set_token('VALUE',l_sqlcode || ' ' || l_sqlerrm);
891: fnd_msg_pub.add;
892: Add_Err_Msg;
893: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
894: P_API_NAME => L_API_NAME
895: ,P_PKG_NAME => G_PKG_NAME

Line 950: FND_MSG_PUB.initialize;

946:
947: -- Initialize message list if p_init_msg_list is set to TRUE.
948: IF FND_API.to_Boolean( p_init_msg_list )
949: THEN
950: FND_MSG_PUB.initialize;
951: END IF;
952:
953:
954: -- Initialize API return status to SUCCESS

Line 993: FND_MSG_PUB.Count_And_Get

989:
990:
991:
992: -- Standard call to get message count and if count is 1, get message info.
993: FND_MSG_PUB.Count_And_Get
994: ( p_count => x_msg_count,
995: p_data => x_msg_data
996: );
997:

Line 1003: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

999: WHEN FND_API.G_EXC_ERROR THEN
1000: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1001: P_API_NAME => L_API_NAME
1002: ,P_PKG_NAME => G_PKG_NAME
1003: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1004: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1005: ,P_ROLLBACK_FLAG => 'N'
1006: ,X_MSG_COUNT => X_MSG_COUNT
1007: ,X_MSG_DATA => X_MSG_DATA

Line 1014: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1011: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1012: P_API_NAME => L_API_NAME
1013: ,P_PKG_NAME => G_PKG_NAME
1014: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1015: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1016: ,P_ROLLBACK_FLAG => 'N'
1017: ,X_MSG_COUNT => X_MSG_COUNT
1018: ,X_MSG_DATA => X_MSG_DATA

Line 1081: FND_MSG_PUB.initialize;

1077:
1078: -- Initialize message list if p_init_msg_list is set to TRUE.
1079: IF FND_API.to_Boolean( l_init_msg_list )
1080: THEN
1081: FND_MSG_PUB.initialize;
1082: END IF;
1083:
1084:
1085:

Line 1165: FND_MSG_PUB.Count_And_Get

1161: --
1162: -- End of API body
1163: --
1164: -- Standard call to get message count and if count is 1, get message info.
1165: FND_MSG_PUB.Count_And_Get
1166: ( p_count => x_msg_count,
1167: p_data => x_msg_data
1168: );
1169: retcode := 0;

Line 1177: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1173: errbuf := X_Msg_Data;
1174: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1175: P_API_NAME => L_API_NAME
1176: ,P_PKG_NAME => G_PKG_NAME
1177: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1178: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1179: ,P_ROLLBACK_FLAG => 'Y'
1180: ,X_MSG_COUNT => X_MSG_COUNT
1181: ,X_MSG_DATA => X_MSG_DATA

Line 1190: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1186: errbuf := X_Msg_Data;
1187: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1188: P_API_NAME => L_API_NAME
1189: ,P_PKG_NAME => G_PKG_NAME
1190: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1191: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1192: ,P_ROLLBACK_FLAG => 'Y'
1193: ,X_MSG_COUNT => X_MSG_COUNT
1194: ,X_MSG_DATA => X_MSG_DATA

Line 1430: FND_MSG_PUB.initialize;

1426:
1427: -- Initialize message list if p_init_msg_list is set to TRUE.
1428: IF FND_API.to_Boolean( p_init_msg_list )
1429: THEN
1430: FND_MSG_PUB.initialize;
1431: END IF;
1432:
1433:
1434: -- Initialize API return status to SUCCESS

Line 1624: FND_MSG_PUB.Count_And_Get

1620: END IF;
1621:
1622:
1623: -- Standard call to get message count and if count is 1, get message info.
1624: FND_MSG_PUB.Count_And_Get
1625: ( p_count => x_msg_count,
1626: p_data => x_msg_data
1627: );
1628:

Line 1634: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1630: WHEN FND_API.G_EXC_ERROR THEN
1631: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1632: P_API_NAME => L_API_NAME
1633: ,P_PKG_NAME => G_PKG_NAME
1634: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1635: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1636: ,P_ROLLBACK_FLAG => 'N'
1637: ,X_MSG_COUNT => X_MSG_COUNT
1638: ,X_MSG_DATA => X_MSG_DATA

Line 1645: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1642: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1643: P_API_NAME => L_API_NAME
1644: ,P_PKG_NAME => G_PKG_NAME
1645: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1646: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1647: ,P_ROLLBACK_FLAG => 'N'
1648: ,X_MSG_COUNT => X_MSG_COUNT
1649: ,X_MSG_DATA => X_MSG_DATA

Line 1706: FND_MSG_PUB.initialize;

1702:
1703: -- Initialize message list if p_init_msg_list is set to TRUE.
1704: IF FND_API.to_Boolean( p_init_msg_list )
1705: THEN
1706: FND_MSG_PUB.initialize;
1707: END IF;
1708:
1709: INSERT INTO CSP_USAGE_HEADERS
1710: (USAGE_HEADER_ID,

Line 1756: FND_MSG_PUB.Count_And_Get

1752: END IF;
1753:
1754:
1755: -- Standard call to get message count and if count is 1, get message info.
1756: FND_MSG_PUB.Count_And_Get
1757: ( p_count => x_msg_count,
1758: p_data => x_msg_data
1759: );
1760:

Line 1766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1762: WHEN FND_API.G_EXC_ERROR THEN
1763: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1764: P_API_NAME => L_API_NAME
1765: ,P_PKG_NAME => G_PKG_NAME
1766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1767: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1768: ,P_ROLLBACK_FLAG => 'N'
1769: ,X_MSG_COUNT => X_MSG_COUNT
1770: ,X_MSG_DATA => X_MSG_DATA

Line 1777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1774: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1775: P_API_NAME => L_API_NAME
1776: ,P_PKG_NAME => G_PKG_NAME
1777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1778: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1779: ,P_ROLLBACK_FLAG => 'N'
1780: ,X_MSG_COUNT => X_MSG_COUNT
1781: ,X_MSG_DATA => X_MSG_DATA

Line 1838: FND_MSG_PUB.initialize;

1834:
1835: -- Initialize message list if p_init_msg_list is set to TRUE.
1836: IF FND_API.to_Boolean( p_init_msg_list )
1837: THEN
1838: FND_MSG_PUB.initialize;
1839: END IF;
1840:
1841: INSERT INTO CSP_USAGE_HEADERS
1842: (USAGE_HEADER_ID,

Line 1887: FND_MSG_PUB.Count_And_Get

1883: END IF;
1884:
1885:
1886: -- Standard call to get message count and if count is 1, get message info.
1887: FND_MSG_PUB.Count_And_Get
1888: ( p_count => x_msg_count,
1889: p_data => x_msg_data
1890: );
1891:

Line 1897: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1893: WHEN FND_API.G_EXC_ERROR THEN
1894: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1895: P_API_NAME => L_API_NAME
1896: ,P_PKG_NAME => G_PKG_NAME
1897: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1898: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1899: ,P_ROLLBACK_FLAG => 'N'
1900: ,X_MSG_COUNT => X_MSG_COUNT
1901: ,X_MSG_DATA => X_MSG_DATA

Line 1908: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1905: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1906: P_API_NAME => L_API_NAME
1907: ,P_PKG_NAME => G_PKG_NAME
1908: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1909: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1910: ,P_ROLLBACK_FLAG => 'N'
1911: ,X_MSG_COUNT => X_MSG_COUNT
1912: ,X_MSG_DATA => X_MSG_DATA

Line 1969: FND_MSG_PUB.initialize;

1965:
1966: -- Initialize message list if p_init_msg_list is set to TRUE.
1967: IF FND_API.to_Boolean( p_init_msg_list )
1968: THEN
1969: FND_MSG_PUB.initialize;
1970: END IF;
1971:
1972: INSERT INTO CSP_USAGE_HEADERS
1973: (USAGE_HEADER_ID,

Line 2018: FND_MSG_PUB.Count_And_Get

2014: END IF;
2015:
2016:
2017: -- Standard call to get message count and if count is 1, get message info.
2018: FND_MSG_PUB.Count_And_Get
2019: ( p_count => x_msg_count,
2020: p_data => x_msg_data
2021: );
2022:

Line 2028: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2024: WHEN FND_API.G_EXC_ERROR THEN
2025: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2026: P_API_NAME => L_API_NAME
2027: ,P_PKG_NAME => G_PKG_NAME
2028: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2029: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2030: ,P_ROLLBACK_FLAG => 'N'
2031: ,X_MSG_COUNT => X_MSG_COUNT
2032: ,X_MSG_DATA => X_MSG_DATA

Line 2039: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2037: P_API_NAME => L_API_NAME
2038: ,P_PKG_NAME => G_PKG_NAME
2039: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2040: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2041: ,P_ROLLBACK_FLAG => 'N'
2042: ,X_MSG_COUNT => X_MSG_COUNT
2043: ,X_MSG_DATA => X_MSG_DATA

Line 2119: FND_MSG_PUB.initialize;

2115:
2116: -- Initialize message list if p_init_msg_list is set to TRUE.
2117: IF FND_API.to_Boolean( p_init_msg_list )
2118: THEN
2119: FND_MSG_PUB.initialize;
2120: END IF;
2121:
2122:
2123: -- Initialize API return status to SUCCESS

Line 2260: FND_MSG_PUB.Count_And_Get

2256: END IF;
2257:
2258:
2259: -- Standard call to get message count and if count is 1, get message info.
2260: FND_MSG_PUB.Count_And_Get
2261: ( p_count => x_msg_count,
2262: p_data => x_msg_data
2263: );
2264:

Line 2270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2266: WHEN FND_API.G_EXC_ERROR THEN
2267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2268: P_API_NAME => L_API_NAME
2269: ,P_PKG_NAME => G_PKG_NAME
2270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2271: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2272: ,P_ROLLBACK_FLAG => 'N'
2273: ,X_MSG_COUNT => X_MSG_COUNT
2274: ,X_MSG_DATA => X_MSG_DATA

Line 2280: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2277: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2278: P_API_NAME => L_API_NAME
2279: ,P_PKG_NAME => G_PKG_NAME
2280: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2281: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2282: ,P_ROLLBACK_FLAG => 'N'
2283: ,X_MSG_COUNT => X_MSG_COUNT
2284: ,X_MSG_DATA => X_MSG_DATA

Line 2354: FND_MSG_PUB.initialize;

2350:
2351: -- Initialize message list if p_init_msg_list is set to TRUE.
2352: IF FND_API.to_Boolean( p_init_msg_list )
2353: THEN
2354: FND_MSG_PUB.initialize;
2355: END IF;
2356:
2357:
2358: -- Initialize API return status to SUCCESS

Line 2516: FND_MSG_PUB.Count_And_Get

2512: END IF;
2513:
2514:
2515: -- Standard call to get message count and if count is 1, get message info.
2516: FND_MSG_PUB.Count_And_Get
2517: ( p_count => x_msg_count,
2518: p_data => x_msg_data
2519: );
2520:

Line 2526: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2522: WHEN FND_API.G_EXC_ERROR THEN
2523: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2524: P_API_NAME => L_API_NAME
2525: ,P_PKG_NAME => G_PKG_NAME
2526: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2527: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2528: ,P_ROLLBACK_FLAG => 'N'
2529: ,X_MSG_COUNT => X_MSG_COUNT
2530: ,X_MSG_DATA => X_MSG_DATA

Line 2537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2534: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2535: P_API_NAME => L_API_NAME
2536: ,P_PKG_NAME => G_PKG_NAME
2537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2538: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2539: ,P_ROLLBACK_FLAG => 'N'
2540: ,X_MSG_COUNT => X_MSG_COUNT
2541: ,X_MSG_DATA => X_MSG_DATA

Line 2717: FND_MSG_PUB.Count_And_Get

2713: END IF;
2714:
2715:
2716: -- Standard call to get message count and if count is 1, get message info.
2717: FND_MSG_PUB.Count_And_Get
2718: ( p_count => x_msg_count,
2719: p_data => x_msg_data
2720: );
2721:

Line 2727: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2723: WHEN FND_API.G_EXC_ERROR THEN
2724: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2725: P_API_NAME => L_API_NAME
2726: ,P_PKG_NAME => G_PKG_NAME
2727: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2728: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2729: ,P_ROLLBACK_FLAG => 'N'
2730: ,X_MSG_COUNT => X_MSG_COUNT
2731: ,X_MSG_DATA => X_MSG_DATA

Line 2738: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2735: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2736: P_API_NAME => L_API_NAME
2737: ,P_PKG_NAME => G_PKG_NAME
2738: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2739: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2740: ,P_ROLLBACK_FLAG => 'N'
2741: ,X_MSG_COUNT => X_MSG_COUNT
2742: ,X_MSG_DATA => X_MSG_DATA

Line 3032: FND_MSG_PUB.Count_And_Get

3028: COMMIT WORK;
3029: END IF;
3030:
3031: -- Standard call to get message count and if count is 1, get message info.
3032: FND_MSG_PUB.Count_And_Get
3033: ( p_count => x_msg_count,
3034: p_data => x_msg_data
3035: );
3036: EXCEPTION

Line 3042: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3038: retcode := 2;
3039: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3040: P_API_NAME => L_API_NAME
3041: ,P_PKG_NAME => G_PKG_NAME
3042: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3043: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3044: ,P_ROLLBACK_FLAG => 'N'
3045: ,X_MSG_COUNT => X_MSG_COUNT
3046: ,X_MSG_DATA => X_MSG_DATA

Line 3054: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3050: retcode := 2;
3051: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3052: P_API_NAME => L_API_NAME
3053: ,P_PKG_NAME => G_PKG_NAME
3054: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3055: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3056: ,P_ROLLBACK_FLAG => 'N'
3057: ,X_MSG_COUNT => X_MSG_COUNT
3058: ,X_MSG_DATA => X_MSG_DATA

Line 3143: FND_MSG_PUB.initialize;

3139:
3140: -- Initialize message list if p_init_msg_list is set to TRUE.
3141: IF FND_API.to_Boolean( p_init_msg_list )
3142: THEN
3143: FND_MSG_PUB.initialize;
3144: END IF;
3145:
3146: -- Initialize API return status to SUCCESS
3147: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3187: FND_MSG_PUB.Count_And_Get

3183: COMMIT WORK;
3184: END IF;
3185:
3186: -- Standard call to get message count and if count is 1, get message info.
3187: FND_MSG_PUB.Count_And_Get
3188: ( p_count => x_msg_count,
3189: p_data => x_msg_data
3190: );
3191:

Line 3197: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3193: WHEN FND_API.G_EXC_ERROR THEN
3194: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3195: P_API_NAME => L_API_NAME
3196: ,P_PKG_NAME => G_PKG_NAME
3197: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3198: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3199: ,P_ROLLBACK_FLAG => 'N'
3200: ,X_MSG_COUNT => X_MSG_COUNT
3201: ,X_MSG_DATA => X_MSG_DATA

Line 3208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3205: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3206: P_API_NAME => L_API_NAME
3207: ,P_PKG_NAME => G_PKG_NAME
3208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3209: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
3210: ,P_ROLLBACK_FLAG => 'N'
3211: ,X_MSG_COUNT => X_MSG_COUNT
3212: ,X_MSG_DATA => X_MSG_DATA