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.JTF_RS_INTERFACE_PVT dependencies on FND_MESSAGE

Line 247: l_trans_message := fnd_message.get_string('JTF','JTF_RS_START_DATE_NULL');

243: END IF;
244:
245: --validate Start Date Active value.
246: -- Get translated value for 'Start Date Active cannot be null'
247: l_trans_message := fnd_message.get_string('JTF','JTF_RS_START_DATE_NULL');
248:
249: UPDATE jtf_rs_resource_extns_int
250: SET OPERATION_STATUS = l_status_error,
251: OPERATION_MESSAGE = l_trans_message,

Line 284: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ISET_RESOURCE_NAME');

280: END IF;
281:
282: --validate Resource Name value.
283: --Get traslated Resource Name to set prompts.
284: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ISET_RESOURCE_NAME');
285:
286: -- Get translated value for 'Resource Name cannot be null'
287: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');
288: fnd_message.set_token('PROMPTS', l_trans_message);

Line 287: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');

283: --Get traslated Resource Name to set prompts.
284: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ISET_RESOURCE_NAME');
285:
286: -- Get translated value for 'Resource Name cannot be null'
287: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');
288: fnd_message.set_token('PROMPTS', l_trans_message);
289: fnd_msg_pub.add;
290:
291: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);

Line 288: fnd_message.set_token('PROMPTS', l_trans_message);

284: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ISET_RESOURCE_NAME');
285:
286: -- Get translated value for 'Resource Name cannot be null'
287: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');
288: fnd_message.set_token('PROMPTS', l_trans_message);
289: fnd_msg_pub.add;
290:
291: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
292:

Line 517: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

513:
514: -- if commit is there after 1000 recs and in update stmt, savepoint will
515: -- not be established.
516: -- ROLLBACK TO do_create_resource;
517: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
518: fnd_message.set_token('P_SQLCODE',SQLCODE);
519: fnd_message.set_token('P_SQLERRM',SQLERRM);
520: fnd_message.set_token('P_API_NAME', l_api_name);
521: FND_MSG_PUB.add;

Line 518: fnd_message.set_token('P_SQLCODE',SQLCODE);

514: -- if commit is there after 1000 recs and in update stmt, savepoint will
515: -- not be established.
516: -- ROLLBACK TO do_create_resource;
517: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
518: fnd_message.set_token('P_SQLCODE',SQLCODE);
519: fnd_message.set_token('P_SQLERRM',SQLERRM);
520: fnd_message.set_token('P_API_NAME', l_api_name);
521: FND_MSG_PUB.add;
522: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 519: fnd_message.set_token('P_SQLERRM',SQLERRM);

515: -- not be established.
516: -- ROLLBACK TO do_create_resource;
517: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
518: fnd_message.set_token('P_SQLCODE',SQLCODE);
519: fnd_message.set_token('P_SQLERRM',SQLERRM);
520: fnd_message.set_token('P_API_NAME', l_api_name);
521: FND_MSG_PUB.add;
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 520: fnd_message.set_token('P_API_NAME', l_api_name);

516: -- ROLLBACK TO do_create_resource;
517: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
518: fnd_message.set_token('P_SQLCODE',SQLCODE);
519: fnd_message.set_token('P_SQLERRM',SQLERRM);
520: fnd_message.set_token('P_API_NAME', l_api_name);
521: FND_MSG_PUB.add;
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
524: p_data => x_msg_data);

Line 733: l_trans_message := fnd_message.get_string('JTF','JTF_RS_RESOURCE_ID_NULL');

729:
730: --Validate if Resource Id value is NULL.
731: -- Get translated value for 'Resource Id cannot be null in Update mode.'
732:
733: l_trans_message := fnd_message.get_string('JTF','JTF_RS_RESOURCE_ID_NULL');
734:
735: UPDATE jtf_rs_resource_extns_int
736: SET operation_status = l_status_error,
737: operation_message = l_trans_message,

Line 763: l_trans_message := fnd_message.get_string('JTF','JTF_RS_RES_ID_INVALID');

759:
760: --If Resource Id value is there then Validate is it valid or not.
761: -- Get translated value for 'Resource Id is not valid'
762:
763: l_trans_message := fnd_message.get_string('JTF','JTF_RS_RES_ID_INVALID');
764:
765: UPDATE jtf_rs_resource_extns_int rs_int
766: SET operation_status = l_status_error,
767: operation_message = l_trans_message,

Line 798: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RES_ID_CAT');

794: -- by Resource manager interface
795: --If Resource Id is valid then check if it is belong to OTHER category.
796:
797: -- Get translated value for 'Resource Id is not of OTHER category.'
798: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RES_ID_CAT');
799: fnd_message.set_token('P_CATEGORY','OTHER');
800: fnd_msg_pub.add;
801:
802: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);

Line 799: fnd_message.set_token('P_CATEGORY','OTHER');

795: --If Resource Id is valid then check if it is belong to OTHER category.
796:
797: -- Get translated value for 'Resource Id is not of OTHER category.'
798: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RES_ID_CAT');
799: fnd_message.set_token('P_CATEGORY','OTHER');
800: fnd_msg_pub.add;
801:
802: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
803:

Line 845: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ISET_RESOURCE_NAME');

841: --Validate if Resource Id value is NULL.
842: --'Resource Name should not be updated to NULL.'
843: --Get traslated Resource Name to set prompts.
844:
845: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ISET_RESOURCE_NAME');
846:
847: -- Get translated value for 'Resource Name cannot be null'
848: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');
849: fnd_message.set_token('PROMPTS', l_trans_message);

Line 848: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');

844:
845: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ISET_RESOURCE_NAME');
846:
847: -- Get translated value for 'Resource Name cannot be null'
848: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');
849: fnd_message.set_token('PROMPTS', l_trans_message);
850: fnd_msg_pub.add;
851:
852: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);

Line 849: fnd_message.set_token('PROMPTS', l_trans_message);

845: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ISET_RESOURCE_NAME');
846:
847: -- Get translated value for 'Resource Name cannot be null'
848: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');
849: fnd_message.set_token('PROMPTS', l_trans_message);
850: fnd_msg_pub.add;
851:
852: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
853:

Line 888: l_trans_message := fnd_message.get_string('JTF','JTF_RS_START_DATE_NULL');

884: END IF;
885:
886: --Validate if Resource Id value is NULL.
887: -- Get translated value for 'Start Date Active cannot be null'
888: l_trans_message := fnd_message.get_string('JTF','JTF_RS_START_DATE_NULL');
889:
890: --'Active Start Date should not be updated to NULL.'
891: UPDATE jtf_rs_resource_extns_int
892: SET operation_status = l_status_error,

Line 1002: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ERR_STDT_GREATER_EDDT');

998: IF l_return_status <> l_status_success THEN
999: -- l_start_date_active cannot be null so if this API returns error status means
1000: -- only chance of JTF_RS_ERR_STDT_GREATER_EDDT
1001:
1002: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ERR_STDT_GREATER_EDDT');
1003:
1004: --'Date values should be valid'
1005: UPDATE jtf_rs_resource_extns_int
1006: SET operation_status = l_return_status,

Line 1488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1484: p_prefix =>l_debug_prefix,
1485: p_msg_level=>fnd_log.level_statement);
1486: END IF;
1487: ROLLBACK TO do_update_resource;
1488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1489: fnd_message.set_token('P_SQLCODE',SQLCODE);
1490: fnd_message.set_token('P_SQLERRM',SQLERRM);
1491: fnd_message.set_token('P_API_NAME', l_api_name);
1492: FND_MSG_PUB.add;

Line 1489: fnd_message.set_token('P_SQLCODE',SQLCODE);

1485: p_msg_level=>fnd_log.level_statement);
1486: END IF;
1487: ROLLBACK TO do_update_resource;
1488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1489: fnd_message.set_token('P_SQLCODE',SQLCODE);
1490: fnd_message.set_token('P_SQLERRM',SQLERRM);
1491: fnd_message.set_token('P_API_NAME', l_api_name);
1492: FND_MSG_PUB.add;
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1490: fnd_message.set_token('P_SQLERRM',SQLERRM);

1486: END IF;
1487: ROLLBACK TO do_update_resource;
1488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1489: fnd_message.set_token('P_SQLCODE',SQLCODE);
1490: fnd_message.set_token('P_SQLERRM',SQLERRM);
1491: fnd_message.set_token('P_API_NAME', l_api_name);
1492: FND_MSG_PUB.add;
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 1491: fnd_message.set_token('P_API_NAME', l_api_name);

1487: ROLLBACK TO do_update_resource;
1488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1489: fnd_message.set_token('P_SQLCODE',SQLCODE);
1490: fnd_message.set_token('P_SQLERRM',SQLERRM);
1491: fnd_message.set_token('P_API_NAME', l_api_name);
1492: FND_MSG_PUB.add;
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1495: p_data => x_msg_data);

Line 1609: l_trans_message := fnd_message.get_string('JTF','JTF_RS_RESOURCE_ID_NULL');

1605: END IF;
1606:
1607: --validate Resource Id value.
1608: --Getting Translated 'Resource Id cannot be null'.
1609: l_trans_message := fnd_message.get_string('JTF','JTF_RS_RESOURCE_ID_NULL');
1610:
1611: UPDATE jtf_rs_salesreps_int
1612: SET OPERATION_STATUS = l_status_error,
1613: OPERATION_MESSAGE = l_trans_message,

Line 1645: l_trans_message := fnd_message.get_string('JTF','JTF_RS_SALESREP_NUMBER_NULL');

1641:
1642:
1643: --validate Sales Number value.
1644: --Getting Translated 'Salesperson number is required to setup a salesperson.'.
1645: l_trans_message := fnd_message.get_string('JTF','JTF_RS_SALESREP_NUMBER_NULL');
1646:
1647: UPDATE jtf_rs_salesreps_int
1648: SET OPERATION_STATUS = l_status_error,
1649: OPERATION_MESSAGE = l_trans_message,

Line 1828: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1824: END IF;
1825: -- if commit is there after 1000 recs and in update stmt, savepoint will
1826: -- not be established.
1827: -- ROLLBACK TO do_create_salesrep;
1828: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1829: fnd_message.set_token('P_SQLCODE',SQLCODE);
1830: fnd_message.set_token('P_SQLERRM',SQLERRM);
1831: fnd_message.set_token('P_API_NAME', l_api_name);
1832: FND_MSG_PUB.add;

Line 1829: fnd_message.set_token('P_SQLCODE',SQLCODE);

1825: -- if commit is there after 1000 recs and in update stmt, savepoint will
1826: -- not be established.
1827: -- ROLLBACK TO do_create_salesrep;
1828: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1829: fnd_message.set_token('P_SQLCODE',SQLCODE);
1830: fnd_message.set_token('P_SQLERRM',SQLERRM);
1831: fnd_message.set_token('P_API_NAME', l_api_name);
1832: FND_MSG_PUB.add;
1833: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1830: fnd_message.set_token('P_SQLERRM',SQLERRM);

1826: -- not be established.
1827: -- ROLLBACK TO do_create_salesrep;
1828: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1829: fnd_message.set_token('P_SQLCODE',SQLCODE);
1830: fnd_message.set_token('P_SQLERRM',SQLERRM);
1831: fnd_message.set_token('P_API_NAME', l_api_name);
1832: FND_MSG_PUB.add;
1833: x_return_status := fnd_api.g_ret_sts_unexp_error;
1834: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 1831: fnd_message.set_token('P_API_NAME', l_api_name);

1827: -- ROLLBACK TO do_create_salesrep;
1828: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1829: fnd_message.set_token('P_SQLCODE',SQLCODE);
1830: fnd_message.set_token('P_SQLERRM',SQLERRM);
1831: fnd_message.set_token('P_API_NAME', l_api_name);
1832: FND_MSG_PUB.add;
1833: x_return_status := fnd_api.g_ret_sts_unexp_error;
1834: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1835: p_data => x_msg_data);

Line 1957: l_trans_message := fnd_message.get_string('JTF','JTF_RS_SALESREP_ID_NULL');

1953:
1954: --validate SalesRep Id value.
1955: --Getting Translated 'Salesrep Id cannot be null.'.
1956:
1957: l_trans_message := fnd_message.get_string('JTF','JTF_RS_SALESREP_ID_NULL');
1958:
1959: UPDATE jtf_rs_salesreps_int
1960: SET OPERATION_STATUS = l_status_error,
1961: OPERATION_MESSAGE = l_trans_message,

Line 1986: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');

1982: END IF;
1983:
1984: --validate SalesRep Id value.
1985: --Getting Translated 'Salesperson Id is Invalid'.
1986: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');
1987: fnd_message.set_token('P_SALESREP_ID','');
1988: fnd_msg_pub.add;
1989:
1990: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);

Line 1987: fnd_message.set_token('P_SALESREP_ID','');

1983:
1984: --validate SalesRep Id value.
1985: --Getting Translated 'Salesperson Id is Invalid'.
1986: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');
1987: fnd_message.set_token('P_SALESREP_ID','');
1988: fnd_msg_pub.add;
1989:
1990: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
1991:

Line 2184: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

2180:
2181: -- if commit is there after 1000 recs and in update stmt, savepoint will
2182: -- not be established.
2183: -- ROLLBACK TO do_create_resource;
2184: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2185: fnd_message.set_token('P_SQLCODE',SQLCODE);
2186: fnd_message.set_token('P_SQLERRM',SQLERRM);
2187: fnd_message.set_token('P_API_NAME', l_api_name);
2188: FND_MSG_PUB.add;

Line 2185: fnd_message.set_token('P_SQLCODE',SQLCODE);

2181: -- if commit is there after 1000 recs and in update stmt, savepoint will
2182: -- not be established.
2183: -- ROLLBACK TO do_create_resource;
2184: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2185: fnd_message.set_token('P_SQLCODE',SQLCODE);
2186: fnd_message.set_token('P_SQLERRM',SQLERRM);
2187: fnd_message.set_token('P_API_NAME', l_api_name);
2188: FND_MSG_PUB.add;
2189: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2186: fnd_message.set_token('P_SQLERRM',SQLERRM);

2182: -- not be established.
2183: -- ROLLBACK TO do_create_resource;
2184: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2185: fnd_message.set_token('P_SQLCODE',SQLCODE);
2186: fnd_message.set_token('P_SQLERRM',SQLERRM);
2187: fnd_message.set_token('P_API_NAME', l_api_name);
2188: FND_MSG_PUB.add;
2189: x_return_status := fnd_api.g_ret_sts_unexp_error;
2190: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 2187: fnd_message.set_token('P_API_NAME', l_api_name);

2183: -- ROLLBACK TO do_create_resource;
2184: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2185: fnd_message.set_token('P_SQLCODE',SQLCODE);
2186: fnd_message.set_token('P_SQLERRM',SQLERRM);
2187: fnd_message.set_token('P_API_NAME', l_api_name);
2188: FND_MSG_PUB.add;
2189: x_return_status := fnd_api.g_ret_sts_unexp_error;
2190: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2191: p_data => x_msg_data);

Line 2277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

2273: END IF;
2274: END IF ;
2275:
2276: EXCEPTION WHEN OTHERS THEN
2277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2278: fnd_message.set_token('P_SQLCODE',SQLCODE);
2279: fnd_message.set_token('P_SQLERRM',SQLERRM);
2280: fnd_message.set_token('P_API_NAME', l_api_name);
2281: FND_MSG_PUB.add;

Line 2278: fnd_message.set_token('P_SQLCODE',SQLCODE);

2274: END IF ;
2275:
2276: EXCEPTION WHEN OTHERS THEN
2277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2278: fnd_message.set_token('P_SQLCODE',SQLCODE);
2279: fnd_message.set_token('P_SQLERRM',SQLERRM);
2280: fnd_message.set_token('P_API_NAME', l_api_name);
2281: FND_MSG_PUB.add;
2282:

Line 2279: fnd_message.set_token('P_SQLERRM',SQLERRM);

2275:
2276: EXCEPTION WHEN OTHERS THEN
2277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2278: fnd_message.set_token('P_SQLCODE',SQLCODE);
2279: fnd_message.set_token('P_SQLERRM',SQLERRM);
2280: fnd_message.set_token('P_API_NAME', l_api_name);
2281: FND_MSG_PUB.add;
2282:
2283: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2280: fnd_message.set_token('P_API_NAME', l_api_name);

2276: EXCEPTION WHEN OTHERS THEN
2277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2278: fnd_message.set_token('P_SQLCODE',SQLCODE);
2279: fnd_message.set_token('P_SQLERRM',SQLERRM);
2280: fnd_message.set_token('P_API_NAME', l_api_name);
2281: FND_MSG_PUB.add;
2282:
2283: x_return_status := fnd_api.g_ret_sts_unexp_error;
2284: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 2378: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

2374: END IF;
2375: END IF ;
2376:
2377: EXCEPTION WHEN OTHERS THEN
2378: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2379: fnd_message.set_token('P_SQLCODE',SQLCODE);
2380: fnd_message.set_token('P_SQLERRM',SQLERRM);
2381: fnd_message.set_token('P_API_NAME', l_api_name);
2382: FND_MSG_PUB.add;

Line 2379: fnd_message.set_token('P_SQLCODE',SQLCODE);

2375: END IF ;
2376:
2377: EXCEPTION WHEN OTHERS THEN
2378: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2379: fnd_message.set_token('P_SQLCODE',SQLCODE);
2380: fnd_message.set_token('P_SQLERRM',SQLERRM);
2381: fnd_message.set_token('P_API_NAME', l_api_name);
2382: FND_MSG_PUB.add;
2383:

Line 2380: fnd_message.set_token('P_SQLERRM',SQLERRM);

2376:
2377: EXCEPTION WHEN OTHERS THEN
2378: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2379: fnd_message.set_token('P_SQLCODE',SQLCODE);
2380: fnd_message.set_token('P_SQLERRM',SQLERRM);
2381: fnd_message.set_token('P_API_NAME', l_api_name);
2382: FND_MSG_PUB.add;
2383:
2384: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2381: fnd_message.set_token('P_API_NAME', l_api_name);

2377: EXCEPTION WHEN OTHERS THEN
2378: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2379: fnd_message.set_token('P_SQLCODE',SQLCODE);
2380: fnd_message.set_token('P_SQLERRM',SQLERRM);
2381: fnd_message.set_token('P_API_NAME', l_api_name);
2382: FND_MSG_PUB.add;
2383:
2384: x_return_status := fnd_api.g_ret_sts_unexp_error;
2385: FND_MSG_PUB.count_and_get (p_count => x_msg_count,