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

Line 495: FND_MSG_PUB.Count_And_Get

491: , L_API_NAME
492: , g_pkg_name
493: )
494: THEN
495: FND_MSG_PUB.Count_And_Get
496: (
497: p_count => x_msg_count
498: , p_data => x_msg_data
499: );

Line 505: FND_MSG_PUB.initialize;

501: END IF ;
502:
503: IF FND_API.to_Boolean(p_init_msg_list)
504: THEN
505: FND_MSG_PUB.initialize;
506: END IF ;
507:
508: ---
509:

Line 723: FND_MSG_PUB.ADD;

719: );
720: END IF ;
721:
722: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_SRS_TO_PURGE');
723: FND_MSG_PUB.ADD;
724:
725: RAISE L_EXC_PURGE_WARNING;
726: END IF;
727:

Line 774: FND_MSG_PUB.ADD;

770: );
771: END IF;
772:
773: FND_MESSAGE.Set_Name('CS', 'CS_SR_SUBMIT_CHILD_FAILED');
774: FND_MSG_PUB.ADD;
775:
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: END IF;
778:

Line 990: FND_MSG_PUB.ADD;

986: END IF;
987:
988: FND_MESSAGE.Set_Name('CS', 'CS_SR_GET_CHILD_STAT_FAILED');
989: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
990: FND_MSG_PUB.ADD;
991:
992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
993: END IF;
994: END LOOP;

Line 1088: FND_MSG_PUB.ADD;

1084:
1085: IF l_main_conc_req_dev_status = 'WARNING'
1086: THEN
1087: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_RET_STAT');
1088: FND_MSG_PUB.ADD;
1089:
1090: RAISE L_EXC_PURGE_WARNING;
1091: ELSIF l_main_conc_req_dev_status = 'ERROR'
1092: THEN

Line 1094: FND_MSG_PUB.ADD;

1090: RAISE L_EXC_PURGE_WARNING;
1091: ELSIF l_main_conc_req_dev_status = 'ERROR'
1092: THEN
1093: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_RET_STAT');
1094: FND_MSG_PUB.ADD;
1095:
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;
1098:

Line 1222: x_msg_count := FND_MSG_PUB.Count_Msg;

1218: -- setting the completion status as WARNING since
1219: -- there was a warning in the execution of this
1220: -- request.
1221:
1222: x_msg_count := FND_MSG_PUB.Count_Msg;
1223: IF x_msg_count > 0
1224: THEN
1225: FND_MSG_PUB.Get
1226: (

Line 1225: FND_MSG_PUB.Get

1221:
1222: x_msg_count := FND_MSG_PUB.Count_Msg;
1223: IF x_msg_count > 0
1224: THEN
1225: FND_MSG_PUB.Get
1226: (
1227: p_msg_index => 1
1228: , p_encoded => 'F'
1229: , p_data => x_msg_data

Line 1249: x_msg_count := FND_MSG_PUB.Count_Msg;

1245: , L_LOG_MODULE || 'error'
1246: , 'Inside WHEN L_EXC_PURGE_WARNING of ' || L_API_NAME_FULL
1247: );
1248:
1249: x_msg_count := FND_MSG_PUB.Count_Msg;
1250:
1251: IF x_msg_count > 0
1252: THEN
1253: FOR

Line 1256: FND_MSG_PUB.Get

1252: THEN
1253: FOR
1254: i IN 1..x_msg_count
1255: LOOP
1256: FND_MSG_PUB.Get
1257: (
1258: p_msg_index => i
1259: , p_encoded => 'F'
1260: , p_data => x_msg_data

Line 1281: x_msg_count := FND_MSG_PUB.Count_Msg;

1277: -- setting the completion status as ERROR since
1278: -- there was an error in the execution of this
1279: -- request.
1280:
1281: x_msg_count := FND_MSG_PUB.Count_Msg;
1282: IF x_msg_count > 0
1283: THEN
1284: FND_MSG_PUB.Get
1285: (

Line 1284: FND_MSG_PUB.Get

1280:
1281: x_msg_count := FND_MSG_PUB.Count_Msg;
1282: IF x_msg_count > 0
1283: THEN
1284: FND_MSG_PUB.Get
1285: (
1286: p_msg_index => 1
1287: , p_encoded => 'F'
1288: , p_data => x_msg_data

Line 1308: x_msg_count := FND_MSG_PUB.Count_Msg;

1304: , L_LOG_MODULE || 'error'
1305: , 'Inside WHEN FND_API.G_EXC_ERROR of ' || L_API_NAME_FULL
1306: );
1307:
1308: x_msg_count := FND_MSG_PUB.Count_Msg;
1309:
1310: IF x_msg_count > 0
1311: THEN
1312: FOR

Line 1315: FND_MSG_PUB.Get

1311: THEN
1312: FOR
1313: i IN 1..x_msg_count
1314: LOOP
1315: FND_MSG_PUB.Get
1316: (
1317: p_msg_index => i
1318: , p_encoded => 'F'
1319: , p_data => x_msg_data

Line 1340: x_msg_count := FND_MSG_PUB.Count_Msg;

1336: -- setting the completion status as ERROR since
1337: -- there was an unexpected error in the execution
1338: -- of this request.
1339:
1340: x_msg_count := FND_MSG_PUB.Count_Msg;
1341: IF x_msg_count > 0
1342: THEN
1343: FND_MSG_PUB.Get
1344: (

Line 1343: FND_MSG_PUB.Get

1339:
1340: x_msg_count := FND_MSG_PUB.Count_Msg;
1341: IF x_msg_count > 0
1342: THEN
1343: FND_MSG_PUB.Get
1344: (
1345: p_msg_index => 1
1346: , p_encoded => 'F'
1347: , p_data => x_msg_data

Line 1367: x_msg_count := FND_MSG_PUB.Count_Msg;

1363: , L_LOG_MODULE || 'unexpected_error'
1364: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
1365: );
1366:
1367: x_msg_count := FND_MSG_PUB.Count_Msg;
1368:
1369: IF x_msg_count > 0
1370: THEN
1371: FOR

Line 1374: FND_MSG_PUB.Get

1370: THEN
1371: FOR
1372: i IN 1..x_msg_count
1373: LOOP
1374: FND_MSG_PUB.Get
1375: (
1376: p_msg_index => i
1377: , p_encoded => 'F'
1378: , p_data => x_msg_data

Line 1398: FND_MSG_PUB.ADD;

1394:
1395: FND_MESSAGE.Set_Name('CS', 'CS_SR_PURG_MAIN_FAIL');
1396: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
1397: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
1398: FND_MSG_PUB.ADD;
1399:
1400: -- setting the completion status as ERROR since
1401: -- there was an unexpected error in the execution
1402: -- of this request.

Line 1404: x_msg_count := FND_MSG_PUB.Count_Msg;

1400: -- setting the completion status as ERROR since
1401: -- there was an unexpected error in the execution
1402: -- of this request.
1403:
1404: x_msg_count := FND_MSG_PUB.Count_Msg;
1405: IF x_msg_count > 0
1406: THEN
1407: FND_MSG_PUB.Get
1408: (

Line 1407: FND_MSG_PUB.Get

1403:
1404: x_msg_count := FND_MSG_PUB.Count_Msg;
1405: IF x_msg_count > 0
1406: THEN
1407: FND_MSG_PUB.Get
1408: (
1409: p_msg_index => 1
1410: , p_encoded => 'F'
1411: , p_data => x_msg_data

Line 1703: FND_MSG_PUB.Count_And_Get

1699: , L_API_NAME
1700: , g_pkg_name
1701: )
1702: THEN
1703: FND_MSG_PUB.Count_And_Get
1704: (
1705: p_count => x_msg_count
1706: , p_data => x_msg_data
1707: );

Line 1713: FND_MSG_PUB.initialize;

1709: END IF ;
1710:
1711: IF FND_API.to_Boolean(p_init_msg_list)
1712: THEN
1713: FND_MSG_PUB.initialize;
1714: END IF ;
1715:
1716: ------------------------------------------------------------------------------
1717: -- Parameter Validations:

Line 1750: FND_MSG_PUB.ADD;

1746: );
1747: END IF ;
1748:
1749: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PARAM_NULL');
1750: FND_MSG_PUB.ADD;
1751:
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: END IF;
1754:

Line 1809: FND_MSG_PUB.ADD;

1805: );
1806: END IF ;
1807:
1808: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');
1809: FND_MSG_PUB.ADD;
1810:
1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1812: END;
1813:

Line 2106: x_msg_count := FND_MSG_PUB.Count_Msg;

2102: ROLLBACK;
2103:
2104: ---
2105:
2106: x_msg_count := FND_MSG_PUB.Count_Msg;
2107: IF x_msg_count > 0
2108: THEN
2109: FND_MSG_PUB.Get
2110: (

Line 2109: FND_MSG_PUB.Get

2105:
2106: x_msg_count := FND_MSG_PUB.Count_Msg;
2107: IF x_msg_count > 0
2108: THEN
2109: FND_MSG_PUB.Get
2110: (
2111: p_msg_index => 1
2112: , p_encoded => 'F'
2113: , p_data => x_msg_data

Line 2238: x_msg_count := FND_MSG_PUB.Count_Msg;

2234: -- and writing them to the log
2235:
2236: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
2237: THEN
2238: x_msg_count := FND_MSG_PUB.Count_Msg;
2239:
2240: IF x_msg_count > 0
2241: THEN
2242: FOR

Line 2245: FND_MSG_PUB.Get

2241: THEN
2242: FOR
2243: i IN 1..x_msg_count
2244: LOOP
2245: FND_MSG_PUB.Get
2246: (
2247: p_msg_index => i
2248: , p_encoded => 'F'
2249: , p_data => x_msg_data

Line 2476: x_msg_count := FND_MSG_PUB.Count_Msg;

2472: -- setting the completion status of this
2473: -- worker thread as COMPLETED with ERRORS
2474: -- since purging failed.
2475:
2476: x_msg_count := FND_MSG_PUB.Count_Msg;
2477: IF x_msg_count > 0
2478: THEN
2479: FND_MSG_PUB.Get
2480: (

Line 2479: FND_MSG_PUB.Get

2475:
2476: x_msg_count := FND_MSG_PUB.Count_Msg;
2477: IF x_msg_count > 0
2478: THEN
2479: FND_MSG_PUB.Get
2480: (
2481: p_msg_index => 1
2482: , p_encoded => 'F'
2483: , p_data => x_msg_data

Line 2503: x_msg_count := FND_MSG_PUB.Count_Msg;

2499: , L_LOG_MODULE || 'unexpected_error'
2500: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2501: );
2502:
2503: x_msg_count := FND_MSG_PUB.Count_Msg;
2504:
2505: IF x_msg_count > 0
2506: THEN
2507: FOR

Line 2510: FND_MSG_PUB.Get

2506: THEN
2507: FOR
2508: i IN 1..x_msg_count
2509: LOOP
2510: FND_MSG_PUB.Get
2511: (
2512: p_msg_index => i
2513: , p_encoded => 'F'
2514: , p_data => x_msg_data

Line 2540: FND_MSG_PUB.ADD;

2536:
2537: FND_MESSAGE.Set_Name('CS', 'CS_SR_PURG_WORKER_FAIL');
2538: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2539: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2540: FND_MSG_PUB.ADD;
2541:
2542: -- setting the completion status of this
2543: -- worker thread as COMPLETED with ERRORS
2544: -- since purging failed.

Line 2546: x_msg_count := FND_MSG_PUB.Count_Msg;

2542: -- setting the completion status of this
2543: -- worker thread as COMPLETED with ERRORS
2544: -- since purging failed.
2545:
2546: x_msg_count := FND_MSG_PUB.Count_Msg;
2547: IF x_msg_count > 0
2548: THEN
2549: FND_MSG_PUB.Get
2550: (

Line 2549: FND_MSG_PUB.Get

2545:
2546: x_msg_count := FND_MSG_PUB.Count_Msg;
2547: IF x_msg_count > 0
2548: THEN
2549: FND_MSG_PUB.Get
2550: (
2551: p_msg_index => 1
2552: , p_encoded => 'F'
2553: , p_data => x_msg_data

Line 4063: FND_MSG_PUB.ADD;

4059: WHEN OTHERS THEN
4060: FND_MESSAGE.Set_Name('CS', 'CS_SR_PURG_ACT_SUM_FAIL');
4061: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4062: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
4063: FND_MSG_PUB.ADD;
4064:
4065: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
4066: THEN
4067: FND_LOG.String

Line 4462: FND_MSG_PUB.ADD;

4458: );
4459: END IF ;
4460:
4461: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_PURGE_PARAMS');
4462: FND_MSG_PUB.ADD;
4463:
4464: RAISE FND_API.G_EXC_ERROR;
4465: END IF;
4466:

Line 4529: FND_MSG_PUB.ADD;

4525:
4526: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');
4527: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
4528: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
4529: FND_MSG_PUB.ADD;
4530:
4531: RAISE FND_API.G_EXC_ERROR;
4532: END IF;
4533:

Line 4598: FND_MSG_PUB.ADD;

4594:
4595: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');
4596: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
4597: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
4598: FND_MSG_PUB.ADD;
4599:
4600: RAISE FND_API.G_EXC_ERROR;
4601: END IF;
4602:

Line 4709: FND_MSG_PUB.ADD;

4705:
4706: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');
4707: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
4708: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
4709: FND_MSG_PUB.ADD;
4710:
4711: RAISE FND_API.G_EXC_ERROR;
4712: END IF;
4713:

Line 4778: FND_MSG_PUB.ADD;

4774:
4775: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');
4776: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
4777: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
4778: FND_MSG_PUB.ADD;
4779:
4780: RAISE FND_API.G_EXC_ERROR;
4781: END IF;
4782:

Line 4904: FND_MSG_PUB.ADD;

4900: );
4901: END IF;
4902:
4903: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');
4904: FND_MSG_PUB.ADD;
4905:
4906: RAISE FND_API.G_EXC_ERROR;
4907: END IF;
4908:

Line 4948: FND_MSG_PUB.ADD;

4944: );
4945: END IF;
4946:
4947: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');
4948: FND_MSG_PUB.ADD;
4949:
4950: RAISE FND_API.G_EXC_ERROR;
4951: END IF;
4952: l_year_part := 0;

Line 4972: FND_MSG_PUB.ADD;

4968: );
4969: END IF;
4970:
4971: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');
4972: FND_MSG_PUB.ADD;
4973:
4974: RAISE FND_API.G_EXC_ERROR;
4975: END IF;
4976: ELSIF l_year_loc > 0

Line 5001: FND_MSG_PUB.ADD;

4997: );
4998: END IF;
4999:
5000: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');
5001: FND_MSG_PUB.ADD;
5002:
5003: RAISE FND_API.G_EXC_ERROR;
5004: END IF;
5005: IF NOT Is_Number(l_str_month_part, l_month_part)

Line 5019: FND_MSG_PUB.ADD;

5015: );
5016: END IF;
5017:
5018: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');
5019: FND_MSG_PUB.ADD;
5020:
5021: RAISE FND_API.G_EXC_ERROR;
5022: END IF;
5023: ELSIF l_year_loc > l_month_loc

Line 5045: FND_MSG_PUB.ADD;

5041: );
5042: END IF;
5043:
5044: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');
5045: FND_MSG_PUB.ADD;
5046:
5047: RAISE FND_API.G_EXC_ERROR;
5048: END IF;
5049: IF NOT Is_Number(l_str_year_part, l_year_part)

Line 5063: FND_MSG_PUB.ADD;

5059: );
5060: END IF;
5061:
5062: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');
5063: FND_MSG_PUB.ADD;
5064:
5065: RAISE FND_API.G_EXC_ERROR;
5066: END IF;
5067: END IF ;

Line 5187: FND_MSG_PUB.ADD;

5183: );
5184: END IF ;
5185:
5186: FND_MESSAGE.Set_Name('CS', 'CS_SR_CRTDT_FROM_ERR');
5187: FND_MSG_PUB.ADD;
5188:
5189: RAISE FND_API.G_EXC_ERROR;
5190: END IF;
5191:

Line 5234: FND_MSG_PUB.ADD;

5230: );
5231: END IF ;
5232:
5233: FND_MESSAGE.Set_Name('CS', 'CS_SR_CRTDT_TO_ERR');
5234: FND_MSG_PUB.ADD;
5235:
5236: RAISE FND_API.G_EXC_ERROR;
5237: END IF;
5238:

Line 5281: FND_MSG_PUB.ADD;

5277: );
5278: END IF ;
5279:
5280: FND_MESSAGE.Set_Name('CS', 'CS_SR_MODDT_FROM_ERR');
5281: FND_MSG_PUB.ADD;
5282:
5283: RAISE FND_API.G_EXC_ERROR;
5284: END IF;
5285:

Line 5328: FND_MSG_PUB.ADD;

5324: );
5325: END IF ;
5326:
5327: FND_MESSAGE.Set_Name('CS', 'CS_SR_MODDT_TO_ERR');
5328: FND_MSG_PUB.ADD;
5329:
5330: RAISE FND_API.G_EXC_ERROR;
5331: END IF;
5332:

Line 5403: FND_MSG_PUB.ADD;

5399: AND application_id = 170
5400: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
5401:
5402: FND_MESSAGE.Set_Token('DATEFIELDNAME2', l_prompt);
5403: FND_MSG_PUB.ADD;
5404:
5405: RAISE FND_API.G_EXC_ERROR;
5406: END IF;
5407:

Line 5486: FND_MSG_PUB.ADD;

5482: AND application_id = 170
5483: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
5484:
5485: FND_MESSAGE.Set_Token('DATEFIELDNAME2', l_prompt);
5486: FND_MSG_PUB.ADD;
5487:
5488: RAISE FND_API.G_EXC_ERROR;
5489: END IF;
5490:

Line 5569: FND_MSG_PUB.ADD;

5565: AND application_id = 170
5566: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
5567:
5568: FND_MESSAGE.Set_Token('DATEFIELDNAME2', l_prompt);
5569: FND_MSG_PUB.ADD;
5570:
5571: RAISE FND_API.G_EXC_ERROR;
5572: END IF;
5573:

Line 5651: FND_MSG_PUB.ADD;

5647: AND application_id = 170
5648: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
5649:
5650: FND_MESSAGE.Set_Token('DATEFIELDNAME2', l_prompt);
5651: FND_MSG_PUB.ADD;
5652:
5653: RAISE FND_API.G_EXC_ERROR;
5654: END IF;
5655:

Line 5728: FND_MSG_PUB.ADD;

5724: AND application_id = 170
5725: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
5726:
5727: FND_MESSAGE.Set_Token('DATEFIELDNAME2', l_prompt);
5728: FND_MSG_PUB.ADD;
5729:
5730: RAISE FND_API.G_EXC_ERROR;
5731: END IF;
5732: