DBA Data[Home] [Help]

APPS.CSF_TASK_ADDRESS_PVT dependencies on FND_MSG_PUB

Line 105: fnd_msg_pub.initialize;

101: FROM fnd_timezones_vl
102: WHERE timezone_code = p_timezone_id;
103: BEGIN
104: -- Initialize message list
105: fnd_msg_pub.initialize;
106: -- get termination messages
107: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
108: l_msg_succ := fnd_message.get;
109: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');

Line 384: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

380: put_stream (g_output, l_msg_succ);
381: -- End of API body
382:
383: -- Standard call to get message count and return the message info if the count is 1
384: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
385: EXCEPTION
386: WHEN fnd_api.g_exc_error
387: THEN
388: retcode := l_rc_err;

Line 390: fnd_msg_pub.count_and_get (p_count => l_msg_count,

386: WHEN fnd_api.g_exc_error
387: THEN
388: retcode := l_rc_err;
389: errbuf := l_msg_err;
390: fnd_msg_pub.count_and_get (p_count => l_msg_count,
391: p_data => l_msg_data
392: );
393: WHEN fnd_api.g_exc_unexpected_error
394: THEN

Line 397: fnd_msg_pub.count_and_get (p_count => l_msg_count,

393: WHEN fnd_api.g_exc_unexpected_error
394: THEN
395: retcode := l_rc_err;
396: errbuf := l_msg_err;
397: fnd_msg_pub.count_and_get (p_count => l_msg_count,
398: p_data => l_msg_data
399: );
400: WHEN OTHERS
401: THEN

Line 405: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

401: THEN
402: retcode := l_rc_err;
403: errbuf := l_msg_err;
404:
405: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
406: THEN
407: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
408: END IF;
409:

Line 407: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

403: errbuf := l_msg_err;
404:
405: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
406: THEN
407: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
408: END IF;
409:
410: fnd_msg_pub.count_and_get (p_count => l_msg_count,
411: p_data => l_msg_data);

Line 410: fnd_msg_pub.count_and_get (p_count => l_msg_count,

406: THEN
407: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
408: END IF;
409:
410: fnd_msg_pub.count_and_get (p_count => l_msg_count,
411: p_data => l_msg_data);
412: END validate_address;
413:
414: PROCEDURE log_info_detail (

Line 455: fnd_msg_pub.initialize;

451:
452: -- Initialize message list if p_init_msg_list is set to TRUE
453: IF fnd_api.to_boolean (p_init_msg_list)
454: THEN
455: fnd_msg_pub.initialize;
456: END IF;
457:
458: -- Initialize API return status to success
459: x_return_status := fnd_api.g_ret_sts_success;

Line 653: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

649: COMMIT WORK;
650: END IF;
651:
652: -- Standard call to get message count and return the message info if the count is 1
653: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
654: EXCEPTION
655: WHEN fnd_api.g_exc_unexpected_error
656: THEN
657: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 658: fnd_msg_pub.count_and_get (p_count => x_msg_count,

654: EXCEPTION
655: WHEN fnd_api.g_exc_unexpected_error
656: THEN
657: x_return_status := fnd_api.g_ret_sts_unexp_error;
658: fnd_msg_pub.count_and_get (p_count => x_msg_count,
659: p_data => x_msg_data
660: );
661: WHEN OTHERS
662: THEN

Line 665: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

661: WHEN OTHERS
662: THEN
663: x_return_status := fnd_api.g_ret_sts_unexp_error;
664:
665: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
666: THEN
667: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
668: END IF;
669:

Line 667: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

663: x_return_status := fnd_api.g_ret_sts_unexp_error;
664:
665: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
666: THEN
667: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
668: END IF;
669:
670: fnd_msg_pub.count_and_get (p_count => x_msg_count,
671: p_data => x_msg_data);

Line 670: fnd_msg_pub.count_and_get (p_count => x_msg_count,

666: THEN
667: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
668: END IF;
669:
670: fnd_msg_pub.count_and_get (p_count => x_msg_count,
671: p_data => x_msg_data);
672: END log_info_detail;
673:
674:

Line 960: fnd_msg_pub.initialize;

956:
957: -- Initialize message list if p_init_msg_list is set to TRUE
958: IF fnd_api.to_boolean (p_init_msg_list)
959: THEN
960: fnd_msg_pub.initialize;
961: END IF;
962:
963: -- Initialize API return status to success
964: x_return_status := fnd_api.g_ret_sts_success;

Line 1002: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

998: COMMIT WORK;
999: END IF;
1000:
1001: -- Standard call to get message count and return the message info if the count is 1
1002: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1003: EXCEPTION
1004: WHEN fnd_api.g_exc_unexpected_error
1005: THEN
1006: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1007: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1003: EXCEPTION
1004: WHEN fnd_api.g_exc_unexpected_error
1005: THEN
1006: x_return_status := fnd_api.g_ret_sts_unexp_error;
1007: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1008: p_data => x_msg_data
1009: );
1010: debug('CSF_TASK_ADDRESS_PVT.retrieve_data: Unexpected Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1011: WHEN OTHERS

Line 1015: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1011: WHEN OTHERS
1012: THEN
1013: x_return_status := fnd_api.g_ret_sts_unexp_error;
1014:
1015: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1016: THEN
1017: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1018: END IF;
1019:

Line 1017: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1013: x_return_status := fnd_api.g_ret_sts_unexp_error;
1014:
1015: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1016: THEN
1017: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1018: END IF;
1019:
1020: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1021: p_data => x_msg_data);

Line 1020: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1016: THEN
1017: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1018: END IF;
1019:
1020: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1021: p_data => x_msg_data);
1022: debug('CSF_TASK_ADDRESS_PVT.retrieve_data: Unexpected Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1023: END retrieve_data;
1024:

Line 1063: fnd_msg_pub.initialize;

1059:
1060: -- Initialize message list if p_init_msg_list is set to TRUE
1061: IF fnd_api.to_boolean (p_init_msg_list)
1062: THEN
1063: fnd_msg_pub.initialize;
1064: END IF;
1065:
1066: -- Initialize API return status to success
1067: x_return_status := fnd_api.g_ret_sts_success;

Line 1097: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1093: COMMIT WORK;
1094: END IF;
1095:
1096: -- Standard call to get message count and return the message info if the count is 1
1097: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1098: EXCEPTION
1099: WHEN fnd_api.g_exc_error
1100: THEN
1101: x_return_status := fnd_api.g_ret_sts_error;

Line 1102: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1098: EXCEPTION
1099: WHEN fnd_api.g_exc_error
1100: THEN
1101: x_return_status := fnd_api.g_ret_sts_error;
1102: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1103: p_data => x_msg_data
1104: );
1105: WHEN fnd_api.g_exc_unexpected_error
1106: THEN

Line 1108: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1104: );
1105: WHEN fnd_api.g_exc_unexpected_error
1106: THEN
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1109: p_data => x_msg_data
1110: );
1111: WHEN OTHERS
1112: THEN

Line 1115: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1111: WHEN OTHERS
1112: THEN
1113: x_return_status := fnd_api.g_ret_sts_unexp_error;
1114:
1115: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1116: THEN
1117: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1118: END IF;
1119:

Line 1117: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1113: x_return_status := fnd_api.g_ret_sts_unexp_error;
1114:
1115: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1116: THEN
1117: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1118: END IF;
1119:
1120: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1121: p_data => x_msg_data);

Line 1120: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1116: THEN
1117: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1118: END IF;
1119:
1120: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1121: p_data => x_msg_data);
1122: END get_geometry;
1123:
1124: -- This function is used to check if the geometry is null.

Line 1172: fnd_msg_pub.initialize;

1168:
1169: -- Initialize message list if p_init_msg_list is set to TRUE
1170: IF fnd_api.to_boolean (p_init_msg_list)
1171: THEN
1172: fnd_msg_pub.initialize;
1173: END IF;
1174:
1175: -- Initialize API return status to success
1176: x_return_status := fnd_api.g_ret_sts_success;

Line 1210: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1206: COMMIT WORK;
1207: END IF;
1208:
1209: -- Standard call to get message count and return the message info if the count is 1
1210: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1211: EXCEPTION
1212: WHEN fnd_api.g_exc_error
1213: THEN
1214: x_return_status := fnd_api.g_ret_sts_error;

Line 1215: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1211: EXCEPTION
1212: WHEN fnd_api.g_exc_error
1213: THEN
1214: x_return_status := fnd_api.g_ret_sts_error;
1215: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1216: p_data => x_msg_data
1217: );
1218: WHEN fnd_api.g_exc_unexpected_error
1219: THEN

Line 1221: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1217: );
1218: WHEN fnd_api.g_exc_unexpected_error
1219: THEN
1220: x_return_status := fnd_api.g_ret_sts_unexp_error;
1221: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1222: p_data => x_msg_data
1223: );
1224: WHEN OTHERS
1225: THEN

Line 1228: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1224: WHEN OTHERS
1225: THEN
1226: x_return_status := fnd_api.g_ret_sts_unexp_error;
1227:
1228: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1229: THEN
1230: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1231: END IF;
1232:

Line 1230: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1226: x_return_status := fnd_api.g_ret_sts_unexp_error;
1227:
1228: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1229: THEN
1230: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1231: END IF;
1232:
1233: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1234: p_data => x_msg_data);

Line 1233: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1229: THEN
1230: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1231: END IF;
1232:
1233: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1234: p_data => x_msg_data);
1235: END is_geometry_valid;
1236:
1237: PROCEDURE get_error_detail (

Line 1296: fnd_msg_pub.initialize;

1292:
1293: -- Initialize message list if p_init_msg_list is set to TRUE
1294: IF fnd_api.to_boolean (p_init_msg_list)
1295: THEN
1296: fnd_msg_pub.initialize;
1297: END IF;
1298:
1299: -- Initialize API return status to success
1300: x_return_status := fnd_api.g_ret_sts_success;

Line 1629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1625: COMMIT WORK;
1626: END IF;
1627:
1628: -- Standard call to get message count and return the message info if the count is 1
1629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1630: EXCEPTION
1631: WHEN fnd_api.g_exc_unexpected_error
1632: THEN
1633: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1634: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1630: EXCEPTION
1631: WHEN fnd_api.g_exc_unexpected_error
1632: THEN
1633: x_return_status := fnd_api.g_ret_sts_unexp_error;
1634: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1635: p_data => x_msg_data
1636: );
1637: WHEN OTHERS
1638: THEN

Line 1641: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1637: WHEN OTHERS
1638: THEN
1639: x_return_status := fnd_api.g_ret_sts_unexp_error;
1640:
1641: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1642: THEN
1643: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1644: END IF;
1645:

Line 1643: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1639: x_return_status := fnd_api.g_ret_sts_unexp_error;
1640:
1641: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1642: THEN
1643: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1644: END IF;
1645:
1646: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1647: p_data => x_msg_data);

Line 1646: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1642: THEN
1643: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1644: END IF;
1645:
1646: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1647: p_data => x_msg_data);
1648: END get_error_detail;
1649:
1650:

Line 1690: fnd_msg_pub.initialize;

1686:
1687: -- Initialize message list if p_init_msg_list is set to TRUE
1688: IF fnd_api.to_boolean (p_init_msg_list)
1689: THEN
1690: fnd_msg_pub.initialize;
1691: END IF;
1692:
1693: -- Initialize API return status to success
1694: x_return_status := fnd_api.g_ret_sts_success;

Line 1840: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1836: COMMIT WORK;
1837: END IF;
1838:
1839: -- Standard call to get message count and return the message info if the count is 1
1840: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1841: EXCEPTION
1842: WHEN fnd_api.g_exc_unexpected_error
1843: THEN
1844: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1845: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1841: EXCEPTION
1842: WHEN fnd_api.g_exc_unexpected_error
1843: THEN
1844: x_return_status := fnd_api.g_ret_sts_unexp_error;
1845: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1846: p_data => x_msg_data
1847: );
1848: WHEN OTHERS
1849: THEN

Line 1852: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1848: WHEN OTHERS
1849: THEN
1850: x_return_status := fnd_api.g_ret_sts_unexp_error;
1851:
1852: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1853: THEN
1854: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1855: END IF;
1856:

Line 1854: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1850: x_return_status := fnd_api.g_ret_sts_unexp_error;
1851:
1852: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1853: THEN
1854: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1855: END IF;
1856:
1857: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1858: p_data => x_msg_data);

Line 1857: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1853: THEN
1854: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1855: END IF;
1856:
1857: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1858: p_data => x_msg_data);
1859: END log_info;
1860:
1861:

Line 1893: fnd_msg_pub.initialize;

1889:
1890: -- Initialize message list if p_init_msg_list is set to TRUE
1891: IF fnd_api.to_boolean (p_init_msg_list)
1892: THEN
1893: fnd_msg_pub.initialize;
1894: END IF;
1895: if (x_dup_msg_data = 'CSF_LF 223634:CSF_LF_INVALID_ADDRESS_DETAILS') then
1896: fnd_message.set_name ('CSF', 'CSF_LF_INVALID_ADDRESS_DETAILS');
1897: x_error_detail := fnd_message.get;

Line 1999: fnd_msg_pub.initialize;

1995:
1996: -- Initialize message list if p_init_msg_list is set to TRUE
1997: IF fnd_api.to_boolean (p_init_msg_list)
1998: THEN
1999: fnd_msg_pub.initialize;
2000: END IF;
2001:
2002: l_dataset_profile_value := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
2003:

Line 2395: fnd_msg_pub.initialize;

2391:
2392: -- Initialize message list if p_init_msg_list is set to TRUE
2393: IF fnd_api.to_boolean (p_init_msg_list)
2394: THEN
2395: fnd_msg_pub.initialize;
2396: END IF;
2397:
2398: -- Initialize API return status to success
2399: x_return_status := fnd_api.g_ret_sts_success;

Line 2427: fnd_msg_pub.add_detail ();

2423:
2424: IF l_timezone_id IS NULL
2425: THEN
2426: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
2427: fnd_msg_pub.add_detail ();
2428: RAISE fnd_api.g_exc_error;
2429: END IF;
2430:
2431: CLOSE c_timezone_check; */

Line 2496: fnd_msg_pub.add_detail ();*/

2492: x_result := g_valid_false;
2493: /* fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
2494: fnd_message.set_token ('LOCATION_ID', p_location_id);
2495: fnd_message.set_token ('RETURN_STATUS', x_return_status);
2496: fnd_msg_pub.add_detail ();*/
2497: -- Added for Bug 7571215
2498: get_error_detail_info (
2499: p_api_version => 1.0,
2500: p_init_msg_list => fnd_api.g_false,

Line 2521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2517: COMMIT WORK;
2518: END IF;
2519:
2520: -- Standard call to get message count and return the message info if the count is 1
2521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2522: EXCEPTION
2523: WHEN fnd_api.g_exc_error
2524: THEN
2525: x_return_status := fnd_api.g_ret_sts_error;

Line 2529: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2525: x_return_status := fnd_api.g_ret_sts_error;
2526: x_result := fnd_api.g_false;
2527: IF x_msg_data IS NULL
2528: THEN
2529: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2530: p_data => x_msg_data
2531: );
2532: END IF;
2533: WHEN fnd_api.g_exc_unexpected_error

Line 2537: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2533: WHEN fnd_api.g_exc_unexpected_error
2534: THEN
2535: x_return_status := fnd_api.g_ret_sts_unexp_error;
2536: x_result := fnd_api.g_false;
2537: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2538: p_data => x_msg_data
2539: );
2540: WHEN OTHERS
2541: THEN

Line 2545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2541: THEN
2542: x_return_status := fnd_api.g_ret_sts_unexp_error;
2543: x_result := fnd_api.g_false;
2544:
2545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2546: THEN
2547: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2548: END IF;
2549:

Line 2547: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2543: x_result := fnd_api.g_false;
2544:
2545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2546: THEN
2547: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2548: END IF;
2549:
2550: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2551: p_data => x_msg_data);

Line 2550: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2546: THEN
2547: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2548: END IF;
2549:
2550: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2551: p_data => x_msg_data);
2552: END validate_task_data;
2553:
2554: FUNCTION is_task_address_valid (p_task_id IN jtf_tasks_b.task_id%TYPE)

Line 2634: fnd_msg_pub.initialize;

2630:
2631: -- Initialize message list if p_init_msg_list is set to TRUE
2632: IF fnd_api.to_boolean (p_init_msg_list)
2633: THEN
2634: fnd_msg_pub.initialize;
2635: END IF;
2636:
2637: -- Initialize API return status to success
2638: x_return_status := fnd_api.g_ret_sts_success;

Line 2774: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2770: COMMIT WORK;
2771: END IF;
2772:
2773: -- Standard call to get message count and return the message info if the count is 1
2774: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2775: EXCEPTION
2776: WHEN fnd_api.g_exc_unexpected_error
2777: THEN
2778: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2779: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2775: EXCEPTION
2776: WHEN fnd_api.g_exc_unexpected_error
2777: THEN
2778: x_return_status := fnd_api.g_ret_sts_unexp_error;
2779: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2780: p_data => x_msg_data
2781: );
2782: WHEN OTHERS
2783: THEN

Line 2786: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2782: WHEN OTHERS
2783: THEN
2784: x_return_status := fnd_api.g_ret_sts_unexp_error;
2785:
2786: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2787: THEN
2788: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2789: END IF;
2790:

Line 2788: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2784: x_return_status := fnd_api.g_ret_sts_unexp_error;
2785:
2786: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2787: THEN
2788: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2789: END IF;
2790:
2791: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2792: p_data => x_msg_data);

Line 2791: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2787: THEN
2788: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2789: END IF;
2790:
2791: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2792: p_data => x_msg_data);
2793: END update_task_address;
2794:
2795: PROCEDURE dbgl (p_msg_data VARCHAR2)

Line 2841: fnd_msg_pub.count_and_get (fnd_api.g_false, l_msg_count, l_msg_data);

2837: put_stream (g_output, p_msg_data);
2838: put_stream (g_log, p_msg_data);
2839: END IF;
2840:
2841: fnd_msg_pub.count_and_get (fnd_api.g_false, l_msg_count, l_msg_data);
2842:
2843: IF l_msg_count = 1
2844: THEN
2845: put_stream (g_output, l_msg_data);

Line 2850: fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false)

2846: put_stream (g_log, l_msg_data);
2847: END IF;
2848:
2849: put_stream (g_output,
2850: fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false)
2851: );
2852: fnd_msg_pub.RESET;
2853:
2854: LOOP

Line 2852: fnd_msg_pub.RESET;

2848:
2849: put_stream (g_output,
2850: fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false)
2851: );
2852: fnd_msg_pub.RESET;
2853:
2854: LOOP
2855: l_msg_data := fnd_msg_pub.get_detail (p_encoded => fnd_api.g_false);
2856: EXIT WHEN l_msg_data IS NULL;

Line 2855: l_msg_data := fnd_msg_pub.get_detail (p_encoded => fnd_api.g_false);

2851: );
2852: fnd_msg_pub.RESET;
2853:
2854: LOOP
2855: l_msg_data := fnd_msg_pub.get_detail (p_encoded => fnd_api.g_false);
2856: EXIT WHEN l_msg_data IS NULL;
2857: put_stream (g_log, l_msg_data);
2858: END LOOP;
2859: END show_messages;

Line 2902: fnd_msg_pub.initialize;

2898:
2899: -- Initialize message list if p_init_msg_list is set to TRUE
2900: IF fnd_api.to_boolean (p_init_msg_list)
2901: THEN
2902: fnd_msg_pub.initialize;
2903: END IF;
2904:
2905: -- Initialize API return status to success
2906: x_return_status := fnd_api.g_ret_sts_success;

Line 2967: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2963: COMMIT WORK;
2964: END IF;
2965:
2966: -- Standard call to get message count and return the message info if the count is 1
2967: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2968: EXCEPTION
2969: WHEN fnd_api.g_exc_unexpected_error
2970: THEN
2971: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2972: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2968: EXCEPTION
2969: WHEN fnd_api.g_exc_unexpected_error
2970: THEN
2971: x_return_status := fnd_api.g_ret_sts_unexp_error;
2972: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2973: p_data => x_msg_data
2974: );
2975: WHEN OTHERS
2976: THEN

Line 2979: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2975: WHEN OTHERS
2976: THEN
2977: x_return_status := fnd_api.g_ret_sts_unexp_error;
2978:
2979: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2980: THEN
2981: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2982: END IF;
2983:

Line 2981: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2977: x_return_status := fnd_api.g_ret_sts_unexp_error;
2978:
2979: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2980: THEN
2981: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2982: END IF;
2983:
2984: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2985: p_data => x_msg_data);

Line 2984: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2980: THEN
2981: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2982: END IF;
2983:
2984: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2985: p_data => x_msg_data);
2986: END success_log_info;
2987: -- This procedure used by Change Invalid address to get the counrty code
2988: -- and place id