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_MESSAGE

Line 722: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_SRS_TO_PURGE');

718: , 'There were no rows to purge. Row count was ' || l_row_count
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;

Line 773: FND_MESSAGE.Set_Name('CS', 'CS_SR_SUBMIT_CHILD_FAILED');

769: , 'Failed while starting worker concurrent request'
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;

Line 988: FND_MESSAGE.Set_Name('CS', 'CS_SR_GET_CHILD_STAT_FAILED');

984: || l_main_conc_req_message
985: );
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;

Line 989: FND_MESSAGE.Set_Token('ERROR', SQLERRM);

985: );
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;

Line 1087: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_RET_STAT');

1083: -- by raising corresponding exceptions.
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'

Line 1093: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_RET_STAT');

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

Line 1395: FND_MESSAGE.Set_Name('CS', 'CS_SR_PURG_MAIN_FAIL');

1391:
1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:

Line 1396: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 1397: FND_MESSAGE.Set_Token('ERROR', SQLERRM);

1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 1749: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PARAM_NULL');

1745: , 'no parameters were supplied to the purge worker program'
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;

Line 1808: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PURGSET_INV');

1804: , 'invalid purge set id supplied to the worker concurrent program'
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;

Line 2366: l_message := FND_MESSAGE.Get_String

2362: -- Setting the completion status of this concurrent
2363: -- request as COMPLETED with WARNINGS since there
2364: -- were some batches that had failed
2365:
2366: l_message := FND_MESSAGE.Get_String
2367: (
2368: 'CS'
2369: , 'CS_SR_WORKER_BATCH_FAIL'
2370: );

Line 2537: FND_MESSAGE.Set_Name('CS', 'CS_SR_PURG_WORKER_FAIL');

2533: ROLLBACK;
2534:
2535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:

Line 2538: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

2534:
2535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 2539: FND_MESSAGE.Set_Token('ERROR', SQLERRM);

2535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 3871: l_string := FND_MESSAGE.Get_String

3867: -- +--------------------------------------------------+-------+
3868: -- | Service Requests | 20039 |
3869: -- +--------------------------------------------------+-------+
3870:
3871: l_string := FND_MESSAGE.Get_String
3872: (
3873: 'CS'
3874: , 'CS_SERVICE_REQUESTS'
3875: );

Line 3882: l_string := FND_MESSAGE.Get_String

3878: l_string
3879: , to_char(l_sr_rows)
3880: );
3881:
3882: l_string := FND_MESSAGE.Get_String
3883: (
3884: 'CS'
3885: , 'CS_SR_ATTRIBUTES'
3886: );

Line 3893: l_string := FND_MESSAGE.Get_String

3889: l_string
3890: , to_char(l_sr_attrs)
3891: );
3892:
3893: l_string := FND_MESSAGE.Get_String
3894: (
3895: 'CS'
3896: , 'CS_CONTACTS'
3897: );

Line 3904: l_string := FND_MESSAGE.Get_String

3900: l_string
3901: , to_char(l_sr_contacts)
3902: );
3903:
3904: l_string := FND_MESSAGE.Get_String
3905: (
3906: 'CS'
3907: , 'CS_CONTACT_ATTRIBS'
3908: );

Line 3915: l_string := FND_MESSAGE.Get_String

3911: l_string
3912: , to_char(l_sr_cont_attrs)
3913: );
3914:
3915: l_string := FND_MESSAGE.Get_String
3916: (
3917: 'CS'
3918: , 'CS_SR_LINKS'
3919: );

Line 3926: l_string := FND_MESSAGE.Get_String

3922: l_string
3923: , to_char(l_sr_links)
3924: );
3925:
3926: l_string := FND_MESSAGE.Get_String
3927: (
3928: 'CS'
3929: , 'CS_MESSAGES'
3930: );

Line 3937: l_string := FND_MESSAGE.Get_String

3933: l_string
3934: , to_char(l_sr_msgs)
3935: );
3936:
3937: l_string := FND_MESSAGE.Get_String
3938: (
3939: 'CS'
3940: , 'CS_KM_LINKS'
3941: );

Line 3948: l_string := FND_MESSAGE.Get_String

3944: l_string
3945: , to_char(l_sr_kb_links)
3946: );
3947:
3948: l_string := FND_MESSAGE.Get_String
3949: (
3950: 'CS'
3951: , 'CS_CHARGE_LINES'
3952: );

Line 3959: l_string := FND_MESSAGE.Get_String

3955: l_string
3956: , to_char(l_sr_estimates)
3957: );
3958:
3959: l_string := FND_MESSAGE.Get_String
3960: (
3961: 'CS'
3962: , 'CS_TASKS'
3963: );

Line 3970: l_string := FND_MESSAGE.Get_String

3966: l_string
3967: , to_char(l_sr_tasks)
3968: );
3969:
3970: l_string := FND_MESSAGE.Get_String
3971: (
3972: 'CS'
3973: , 'CS_NOTES'
3974: );

Line 3981: l_string := FND_MESSAGE.Get_String

3977: l_string
3978: , to_char(l_sr_notes)
3979: );
3980:
3981: l_string := FND_MESSAGE.Get_String
3982: (
3983: 'CS'
3984: , 'CS_INT_ACTIVITIES'
3985: );

Line 3992: l_string := FND_MESSAGE.Get_String

3988: l_string
3989: , to_char(l_sr_activities)
3990: );
3991:
3992: l_string := FND_MESSAGE.Get_String
3993: (
3994: 'CS'
3995: , 'CS_ATTACHMENTS'
3996: );

Line 4003: l_string := FND_MESSAGE.Get_String

3999: l_string
4000: , to_char(l_sr_attachs)
4001: );
4002:
4003: l_string := FND_MESSAGE.Get_String
4004: (
4005: 'CS'
4006: , 'CS_UWQ_WORK_ITEMS'
4007: );

Line 4014: l_string := FND_MESSAGE.Get_String

4010: l_string
4011: , to_char(l_sr_work_items)
4012: );
4013:
4014: l_string := FND_MESSAGE.Get_String
4015: (
4016: 'CS'
4017: , 'CS_AUDIT_RECORDS'
4018: );

Line 4025: l_string := FND_MESSAGE.Get_String

4021: l_string
4022: , to_char(l_sr_audits)
4023: );
4024:
4025: l_string := FND_MESSAGE.Get_String
4026: (
4027: 'CS'
4028: , 'CS_TOTAL_ROWS'
4029: );

Line 4060: FND_MESSAGE.Set_Name('CS', 'CS_SR_PURG_ACT_SUM_FAIL');

4056: END IF ;
4057:
4058: EXCEPTION
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:

Line 4061: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

4057:
4058: EXCEPTION
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

Line 4062: FND_MESSAGE.Set_Token('ERROR', SQLERRM);

4058: EXCEPTION
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

Line 4461: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_PURGE_PARAMS');

4457: , 'no parameters were supplied to the purge program'
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;

Line 4526: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');

4522: end_user_column_name = 'P_CREATION_FROM_DATE'
4523: AND application_id = 170
4524: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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:

Line 4527: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);

4523: AND application_id = 170
4524: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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;

Line 4528: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);

4524: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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;

Line 4595: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');

4591: end_user_column_name = 'P_CREATION_TO_DATE'
4592: AND application_id = 170
4593: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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:

Line 4596: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);

4592: AND application_id = 170
4593: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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;

Line 4597: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);

4593: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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;

Line 4706: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');

4702: end_user_column_name = 'P_LAST_UPDATE_FROM_DATE'
4703: AND application_id = 170
4704: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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:

Line 4707: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);

4703: AND application_id = 170
4704: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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;

Line 4708: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);

4704: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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;

Line 4775: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_FORMAT_ERR');

4771: end_user_column_name = 'P_LAST_UPDATE_TO_DATE'
4772: AND application_id = 170
4773: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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:

Line 4776: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);

4772: AND application_id = 170
4773: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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;

Line 4777: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);

4773: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
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;

Line 4903: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');

4899: , 'error while getting the month/year combination from the lookup'
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;

Line 4947: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');

4943: , 'error while getting the month/year combination from the lookup'
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;

Line 4971: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');

4967: , 'error while getting the month/year combination from the lookup'
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;

Line 5000: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');

4996: , 'error while getting the month/year combination from the lookup'
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;

Line 5018: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');

5014: , 'error while getting the month/year combination from the lookup'
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;

Line 5044: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');

5040: , 'error while getting the month/year combination from the lookup'
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;

Line 5062: FND_MESSAGE.Set_Name('CS', 'CS_SR_NOT_UPD_SINCE_INV');

5058: , 'error while getting the month/year combination from the lookup'
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;

Line 5186: FND_MESSAGE.Set_Name('CS', 'CS_SR_CRTDT_FROM_ERR');

5182: , 'x_creation_from_date is invalid'
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;

Line 5233: FND_MESSAGE.Set_Name('CS', 'CS_SR_CRTDT_TO_ERR');

5229: , 'x_creation_to_date is invalid'
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;

Line 5280: FND_MESSAGE.Set_Name('CS', 'CS_SR_MODDT_FROM_ERR');

5276: , 'x_last_update_from_date is invalid'
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;

Line 5327: FND_MESSAGE.Set_Name('CS', 'CS_SR_MODDT_TO_ERR');

5323: , 'x_last_update_to_date is invalid'
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;

Line 5376: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_VALUE_ERR');

5372: , 'it is invalid to have x_creation_from_date > x_creation_to_date'
5373: );
5374: END IF ;
5375:
5376: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_VALUE_ERR');
5377:
5378: SELECT
5379: form_left_prompt
5380: INTO

Line 5389: FND_MESSAGE.Set_Token('DATEFIELDNAME1', l_prompt);

5385: end_user_column_name = 'P_CREATION_FROM_DATE'
5386: AND application_id = 170
5387: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
5388:
5389: FND_MESSAGE.Set_Token('DATEFIELDNAME1', l_prompt);
5390:
5391: SELECT
5392: form_left_prompt
5393: INTO

Line 5402: FND_MESSAGE.Set_Token('DATEFIELDNAME2', l_prompt);

5398: end_user_column_name = 'P_CREATION_TO_DATE'
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;

Line 5453: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_VALUE_ERR');

5449: || 'x_last_update_from_date'
5450: );
5451: END IF ;
5452:
5453: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_VALUE_ERR');
5454:
5455: SELECT
5456: form_left_prompt
5457: INTO

Line 5466: FND_MESSAGE.Set_Token('DATEFIELDNAME1', l_prompt);

5462: end_user_column_name = 'P_CREATION_FROM_DATE'
5463: AND application_id = 170
5464: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
5465:
5466: FND_MESSAGE.Set_Token('DATEFIELDNAME1', l_prompt);
5467:
5468: SELECT
5469: form_left_prompt
5470: INTO

Line 5485: FND_MESSAGE.Set_Token('DATEFIELDNAME2', l_prompt);

5481: )
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;

Line 5536: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_VALUE_ERR');

5532: || 'x_last_update_to_date'
5533: );
5534: END IF ;
5535:
5536: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_VALUE_ERR');
5537:
5538: SELECT
5539: form_left_prompt
5540: INTO

Line 5549: FND_MESSAGE.Set_Token('DATEFIELDNAME1', l_prompt);

5545: end_user_column_name = 'P_CREATION_FROM_DATE'
5546: AND application_id = 170
5547: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
5548:
5549: FND_MESSAGE.Set_Token('DATEFIELDNAME1', l_prompt);
5550:
5551: SELECT
5552: form_left_prompt
5553: INTO

Line 5568: FND_MESSAGE.Set_Token('DATEFIELDNAME2', l_prompt);

5564: )
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;

Line 5618: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_VALUE_ERR');

5614: , 'it is invalid to have x_creation_to_date > x_last_update_to_date'
5615: );
5616: END IF ;
5617:
5618: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_VALUE_ERR');
5619:
5620: SELECT
5621: form_left_prompt
5622: INTO

Line 5631: FND_MESSAGE.Set_Token('DATEFIELDNAME1', l_prompt);

5627: end_user_column_name = 'P_CREATION_TO_DATE'
5628: AND application_id = 170
5629: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
5630:
5631: FND_MESSAGE.Set_Token('DATEFIELDNAME1', l_prompt);
5632:
5633: SELECT
5634: form_left_prompt
5635: INTO

Line 5650: FND_MESSAGE.Set_Token('DATEFIELDNAME2', l_prompt);

5646: )
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;

Line 5701: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_VALUE_ERR');

5697: || 'x_last_update_to_date'
5698: );
5699: END IF ;
5700:
5701: FND_MESSAGE.Set_Name('CS', 'CS_SR_DATE_VALUE_ERR');
5702:
5703: SELECT
5704: form_left_prompt
5705: INTO

Line 5714: FND_MESSAGE.Set_Token('DATEFIELDNAME1', l_prompt);

5710: end_user_column_name = 'P_LAST_UPDATE_FROM_DATE'
5711: AND application_id = 170
5712: AND descriptive_flexfield_name = '$SRS$.CSSRPGP';
5713:
5714: FND_MESSAGE.Set_Token('DATEFIELDNAME1', l_prompt);
5715:
5716: SELECT
5717: form_left_prompt
5718: INTO

Line 5727: FND_MESSAGE.Set_Token('DATEFIELDNAME2', l_prompt);

5723: end_user_column_name = 'P_LAST_UPDATE_TO_DATE'
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;

Line 7139: l_report_caption := FND_MESSAGE.Get_String

7135: , ''
7136: );
7137: END IF;
7138:
7139: l_report_caption := FND_MESSAGE.Get_String
7140: (
7141: 'CS'
7142: , 'CS_SR_PURGE_RESULT'
7143: );

Line 7161: l_report_caption := FND_MESSAGE.Get_String

7157: || ''
7158: );
7159: END IF;
7160:
7161: l_report_caption := FND_MESSAGE.Get_String
7162: (
7163: 'CS'
7164: , 'CS_SR_PURGE_SUBMIT_COUNT'
7165: );
Line 7218: l_report_caption := FND_MESSAGE.Get_String

7214: , 'Getting number of SRs Successfully purged'
7215: );
7216: END IF;
7217:
7218: l_report_caption := FND_MESSAGE.Get_String
7219: (
7220: 'CS'
7221: , 'CS_SR_PURGE_SUCCESS_COUNT'
7222: );

Line 7276: l_report_caption := FND_MESSAGE.Get_String

7272: , 'Getting number of SRs not attempted to be purged'
7273: );
7274: END IF;
7275:
7276: l_report_caption := FND_MESSAGE.Get_String
7277: (
7278: 'CS'
7279: , 'CS_SR_PURGE_NOTDONE_COUNT'
7280: );

Line 7344: l_report_caption := FND_MESSAGE.Get_String

7340: , 'Getting number of SRs not purged due to validation failures'
7341: );
7342: END IF;
7343:
7344: l_report_caption := FND_MESSAGE.Get_String
7345: (
7346: 'CS'
7347: , 'CS_SR_PURGE_FAILURE_COUNT'
7348: );

Line 7437: l_report_caption := FND_MESSAGE.Get_String

7433: , '
'
7434: );
7435: END IF;
7436:
7437: l_report_caption := FND_MESSAGE.Get_String
7438: (
7439: 'CS'
7440: , 'CS_SR_FAILED_SRS_REPORT'
7441: );

Line 7489: l_report_caption := FND_MESSAGE.Get_String

7485: , '

'
7486: );
7487: END IF;
7488:
7489: l_report_caption := FND_MESSAGE.Get_String
7490: (
7491: 'CS'
7492: , 'CS_SR_FAILED_SRS_RPT_HEAD'
7493: );
Line 7635: l_error_message_text := FND_MESSAGE.Get_String

7631: END IF;
7632:
7633: IF l_error_message_loc > 0
7634: THEN
7635: l_error_message_text := FND_MESSAGE.Get_String
7636: (
7637: SUBSTR
7638: (
7639: l_purge_error_message_arr(j)

Line 7668: l_error_message_text := FND_MESSAGE.Get_String

7664: );
7665: END IF;
7666: ELSIF l_error_message_loc <= 0
7667: THEN
7668: l_error_message_text := FND_MESSAGE.Get_String
7669: (
7670: SUBSTR
7671: (
7672: l_purge_error_message_arr(j)