DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on FND_MSG_PUB

Line 456: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

452: /* --
453: -- debugging portion
454: -- can be commented ut for final code
455: IF inv_pp_debug.is_debug_mode THEN
456: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
457: -- the message retrieved here since it is no longer on the stack
458: inv_pp_debug.set_last_error_message(Sqlerrm);
459: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
460: inv_pp_debug.send_last_error_message;

Line 471: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

467: if inpline%isopen then
468: close inpline;
469: end if;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
472: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
473: end if;
474: fnd_msg_pub.count_and_get( p_count => x_msg_count
475: ,p_data => x_msg_data );

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

468: close inpline;
469: end if;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
472: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
473: end if;
474: fnd_msg_pub.count_and_get( p_count => x_msg_count
475: ,p_data => x_msg_data );
476: If (l_debug = 1) then

Line 474: fnd_msg_pub.count_and_get( p_count => x_msg_count

470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
472: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
473: end if;
474: fnd_msg_pub.count_and_get( p_count => x_msg_count
475: ,p_data => x_msg_data );
476: If (l_debug = 1) then
477: log_error(l_api_name, 'error', 'Error in InitInput - ' ||x_msg_data);
478: End if;

Line 605: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

601: /* --
602: -- debugging portion
603: -- can be commented ut for final code
604: IF inv_pp_debug.is_debug_mode THEN
605: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
606: -- the message retrieved here since it is no longer on the stack
607: inv_pp_debug.set_last_error_message(Sqlerrm);
608: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
609: inv_pp_debug.send_last_error_message;

Line 617: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

613: if rules%isopen then
614: close rules;
615: end if;
616: x_return_status := fnd_api.g_ret_sts_unexp_error;
617: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
618: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
619: end if;
620: fnd_msg_pub.count_and_get( p_count => x_msg_count
621: ,p_data => x_msg_data );

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

614: close rules;
615: end if;
616: x_return_status := fnd_api.g_ret_sts_unexp_error;
617: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
618: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
619: end if;
620: fnd_msg_pub.count_and_get( p_count => x_msg_count
621: ,p_data => x_msg_data );
622:

Line 620: fnd_msg_pub.count_and_get( p_count => x_msg_count

616: x_return_status := fnd_api.g_ret_sts_unexp_error;
617: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
618: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
619: end if;
620: fnd_msg_pub.count_and_get( p_count => x_msg_count
621: ,p_data => x_msg_data );
622:
623: If (l_debug = 1) then
624: log_error(l_api_name, 'error', 'Error in InitStrategyRules - ' ||

Line 792: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

788: /* --
789: -- debugging portion
790: -- can be commented ut for final code
791: IF inv_pp_debug.is_debug_mode THEN
792: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
793: -- the message retrieved here since it is no longer on the stack
794: inv_pp_debug.set_last_error_message(Sqlerrm);
795: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
796: inv_pp_debug.send_last_error_message;

Line 804: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

800: if iteminfo%isopen then
801: close iteminfo;
802: end if;
803: x_return_status := fnd_api.g_ret_sts_unexp_error;
804: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
805: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
806: end if;
807: fnd_msg_pub.count_and_get( p_count => x_msg_count
808: ,p_data => x_msg_data );

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

801: close iteminfo;
802: end if;
803: x_return_status := fnd_api.g_ret_sts_unexp_error;
804: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
805: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
806: end if;
807: fnd_msg_pub.count_and_get( p_count => x_msg_count
808: ,p_data => x_msg_data );
809: If (l_debug = 1) then

Line 807: fnd_msg_pub.count_and_get( p_count => x_msg_count

803: x_return_status := fnd_api.g_ret_sts_unexp_error;
804: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
805: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
806: end if;
807: fnd_msg_pub.count_and_get( p_count => x_msg_count
808: ,p_data => x_msg_data );
809: If (l_debug = 1) then
810: log_error(l_api_name, 'error', 'Error in InitQtyTree - ' || x_msg_data);
811: End if;

Line 1048: fnd_msg_pub.initialize;

1044: end if;
1045:
1046: -- Initialize message list if p_init_msg_list is set to TRUE
1047: if fnd_api.to_boolean( p_init_msg_list ) then
1048: fnd_msg_pub.initialize;
1049: end if;
1050:
1051: -- Initialize API return status to success
1052: x_return_status := fnd_api.g_ret_sts_success;

Line 1060: fnd_msg_pub.add;

1056: if p_validation_level <> fnd_api.g_valid_level_none then
1057: if p_transaction_temp_id is null or
1058: p_transaction_temp_id = fnd_api.g_miss_num then
1059: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
1060: fnd_msg_pub.add;
1061: If (l_debug = 1) then
1062: log_error_msg(l_api_name, 'missing_txn_temp_id');
1063: End if;
1064: raise fnd_api.g_exc_unexpected_error;

Line 1069: fnd_msg_pub.add;

1065: end if;
1066: if p_type_code is null or
1067: p_type_code = fnd_api.g_miss_num then
1068: fnd_message.set_name('WMS','WMS_STRA_TYPE_CODE_MISS');
1069: fnd_msg_pub.add;
1070: If (l_debug = 1) then
1071: log_error_msg(l_api_name, 'missing_type_code');
1072: End if;
1073: raise fnd_api.g_exc_unexpected_error;

Line 1086: fnd_msg_pub.add;

1082: fetch cg_org into l_organization_id;
1083: if cg_org%notfound then
1084: close cg_org;
1085: fnd_message.set_name('WMS','WMS_TRX_REQ_REC_NOTFOUND');
1086: fnd_msg_pub.add;
1087: If (l_debug = 1) then
1088: log_error_msg(l_api_name, 'missing_org_id_cg');
1089: End if;
1090: raise fnd_api.g_exc_unexpected_error;

Line 1099: fnd_msg_pub.add;

1095: fetch input into l_organization_id;
1096: if input%notfound then
1097: close input;
1098: fnd_message.set_name('WMS','WMS_TRX_REQ_REC_NOTFOUND');
1099: fnd_msg_pub.add;
1100: If (l_debug = 1) then
1101: log_error_msg(l_api_name, 'missing_org_id_pp');
1102: End if;
1103: raise fnd_api.g_exc_unexpected_error;

Line 1141: fnd_msg_pub.add;

1137: -- every other return status seems to be unexpected: leave
1138: else
1139: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
1140: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status
1141: fnd_msg_pub.add;
1142: If (l_debug = 1) then
1143: log_error_msg(l_api_name, 'bad_return_status');
1144: End if;
1145: raise fnd_api.g_exc_unexpected_error;

Line 1324: fnd_msg_pub.add;

1320: if l_last_object_found = FALSE then
1321: close hierarchy;
1322: fnd_message.set_name('WMS','WMS_DB_OBJECT_CHAIN');
1323: -- Seed data corrupted: DB object chain
1324: fnd_msg_pub.add;
1325: If (g_debug = 1) then
1326: log_error_msg(l_api_name, 'bad_db_object_chain');
1327: End if;
1328: raise fnd_api.g_exc_unexpected_error;

Line 1394: --fnd_msg_pub.add;

1390: if l_hierarchy = 0 then
1391: fnd_message.set_name('WMS','WMS_SEARCH_ORDER_EMPTY');
1392: --inv_pp_debug.send_message_to_pipe('no search order defined for this org');
1393: -- Strategy search object hierarchy contains no entry
1394: --fnd_msg_pub.add;
1395: If (g_debug = 1) then
1396: log_event(l_api_name, 'no_hierarchy',
1397: 'No strategy search order defined for this organization');
1398: End if;

Line 1405: --fnd_msg_pub.add;

1401: if l_strategy_id is null then
1402: fnd_message.set_name('WMS','WMS_NO_STRATEGY_ASSIGN');
1403: -- inv_pp_debug.send_message_to_pipe('no strategy assigned');
1404: --No active strategy assignment detected according to provided input
1405: --fnd_msg_pub.add;
1406: If (g_debug = 1) then
1407: log_event(l_api_name, 'no_strategy',
1408: 'The strategy search function failed to find a valid ' ||
1409: 'strategy.');

Line 1458: fnd_msg_pub.count_and_get( p_count => x_msg_count

1454: -- Clean up variables for dynamically bound input parameters
1455: inv_sql_binding_pvt.InitBindTables;
1456:
1457: -- Standard call to get message count and if count is 1, get message info
1458: fnd_msg_pub.count_and_get( p_count => x_msg_count
1459: ,p_data => x_msg_data );
1460: IF inv_pp_debug.is_debug_mode THEN
1461: inv_pp_debug.send_message_to_pipe('strategy id found '||l_strategy_id);
1462: END IF;

Line 1482: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

1478: --
1479: -- debugging portion
1480: -- can be commented ut for final code
1481: IF inv_pp_debug.is_debug_mode THEN
1482: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1483: -- the message retrieved here since it is no longer on the stack
1484: inv_pp_debug.set_last_error_message(Sqlerrm);
1485: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1486: --changed by jcearley on 11/22/99 because call was causing error

Line 1497: fnd_msg_pub.count_and_get( p_count => x_msg_count

1493: -- end of debugging section
1494: --
1495: inv_sql_binding_pvt.InitBindTables;
1496: x_return_status := fnd_api.g_ret_sts_error;
1497: fnd_msg_pub.count_and_get( p_count => x_msg_count
1498: ,p_data => x_msg_data );
1499: If (g_debug = 1) then
1500: log_error(l_api_name, 'error', 'Error in Search - ' || x_msg_data);
1501: End if;

Line 1510: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

1506: --
1507: -- debugging portion
1508: -- can be commented ut for final code
1509: IF inv_pp_debug.is_debug_mode THEN
1510: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1511: -- the message retrieved here since it is no longer on the stack
1512: inv_pp_debug.set_last_error_message(Sqlerrm);
1513: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1514: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);

Line 1524: fnd_msg_pub.count_and_get( p_count => x_msg_count

1520: -- end of debugging section
1521: --
1522: inv_sql_binding_pvt.InitBindTables;
1523: x_return_status := fnd_api.g_ret_sts_unexp_error;
1524: fnd_msg_pub.count_and_get( p_count => x_msg_count
1525: ,p_data => x_msg_data );
1526: If (g_debug = 1) then
1527: log_error(l_api_name, 'unexp_error',
1528: 'Unexpected error in Search - ' || x_msg_data);

Line 1537: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

1533: --
1534: -- debugging portion
1535: -- can be commented ut for final code
1536: IF inv_pp_debug.is_debug_mode THEN
1537: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1538: -- the message retrieved here since it is no longer on the stack
1539: inv_pp_debug.set_last_error_message(Sqlerrm);
1540: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1541: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);

Line 1563: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

1559: if conditions%isopen then
1560: close conditions;
1561: end if;
1562: x_return_status := fnd_api.g_ret_sts_unexp_error;
1563: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1564: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1565: end if;
1566: fnd_msg_pub.count_and_get( p_count => x_msg_count
1567: ,p_data => x_msg_data );

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

1560: close conditions;
1561: end if;
1562: x_return_status := fnd_api.g_ret_sts_unexp_error;
1563: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1564: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1565: end if;
1566: fnd_msg_pub.count_and_get( p_count => x_msg_count
1567: ,p_data => x_msg_data );
1568: If (g_debug = 1) then

Line 1566: fnd_msg_pub.count_and_get( p_count => x_msg_count

1562: x_return_status := fnd_api.g_ret_sts_unexp_error;
1563: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1564: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1565: end if;
1566: fnd_msg_pub.count_and_get( p_count => x_msg_count
1567: ,p_data => x_msg_data );
1568: If (g_debug = 1) then
1569: log_error(l_api_name, 'other_error',
1570: 'Other error in Search - ' || x_msg_data);

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

1689: END IF;
1690: EXCEPTION
1691: WHEN FND_API.G_EXC_ERROR THEN
1692: x_return_status := FND_API.G_RET_STS_ERROR;
1693: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1695: x_return_status := FND_API.G_RET_STS_ERROR;
1696: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1697: WHEN OTHERS THEN

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

1692: x_return_status := FND_API.G_RET_STS_ERROR;
1693: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1695: x_return_status := FND_API.G_RET_STS_ERROR;
1696: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1697: WHEN OTHERS THEN
1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1699: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1700: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1699: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1695: x_return_status := FND_API.G_RET_STS_ERROR;
1696: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1697: WHEN OTHERS THEN
1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1699: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1700: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1701: END IF;
1702: END get_max_tolerance;
1703:

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

1696: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1697: WHEN OTHERS THEN
1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1699: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1700: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1701: END IF;
1702: END get_max_tolerance;
1703:
1704: -- Start of comments

Line 1901: fnd_msg_pub.initialize;

1897: end if;
1898:
1899: -- Initialize message list if p_init_msg_list is set to TRUE
1900: if fnd_api.to_boolean( p_init_msg_list ) then
1901: fnd_msg_pub.initialize;
1902: end if;
1903:
1904: -- Initialize API return status to success
1905: x_return_status := fnd_api.g_ret_sts_success;

Line 1919: fnd_msg_pub.add;

1915: p_transaction_temp_id = fnd_api.g_miss_num
1916: then
1917: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
1918: -- Transaction input identifier required but not provided
1919: fnd_msg_pub.add;
1920: If (l_debug = 1) then
1921: log_error_msg(l_api_name,'missing_txn_temp_id');
1922: End if;
1923: raise fnd_api.g_exc_unexpected_error;

Line 1930: fnd_msg_pub.add;

1926: p_type_code = fnd_api.g_miss_num
1927: then
1928: fnd_message.set_name('WMS','WMS_STRA_TYPE_CODE_MISS');
1929: -- Strategy type code required but not provided
1930: fnd_msg_pub.add;
1931: If (l_debug = 1) then
1932: log_error_msg(l_api_name,'missing_type_code');
1933: End if;
1934: raise fnd_api.g_exc_unexpected_error;

Line 1941: fnd_msg_pub.add;

1937: if p_strategy_id is null or
1938: p_strategy_id = fnd_api.g_miss_num then
1939: fnd_message.set_name('WMS','WMS_STRATEGY_ID_MISSING');
1940: -- Strategy identifier required but not provided
1941: fnd_msg_pub.add;
1942: raise fnd_api.g_exc_unexpected_error;
1943: end if;
1944: */
1945: end if;

Line 2528: fnd_msg_pub.count_and_get( p_count => x_msg_count

2524: end if;
2525:
2526: --
2527: -- Standard call to get message count and if count is 1, get message info
2528: fnd_msg_pub.count_and_get( p_count => x_msg_count
2529: ,p_data => x_msg_data );
2530: /* --
2531: -- debugging portion
2532: -- can be commented ut for final code

Line 2548: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2544: /* --
2545: -- debugging portion
2546: -- can be commented ut for final code
2547: IF inv_pp_debug.is_debug_mode THEN
2548: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2549: -- the message retrieved here since it is no longer on the stack
2550: inv_pp_debug.set_last_error_message(Sqlerrm);
2551: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2552: inv_pp_debug.send_last_error_message;

Line 2558: fnd_msg_pub.count_and_get( p_count => x_msg_count

2554: -- end of debugging section
2555: -- */
2556: rollback to ApplyStrategySP;
2557: FreeGlobals;
2558: fnd_msg_pub.count_and_get( p_count => x_msg_count
2559: ,p_data => x_msg_data );
2560: If (l_debug = 1) then
2561: log_error(l_api_name, 'error', 'Error in Apply - ' || x_msg_data);
2562: End if;

Line 2570: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2566: /*--
2567: -- debugging portion
2568: -- can be commented ut for final code
2569: IF inv_pp_debug.is_debug_mode THEN
2570: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2571: -- the message retrieved here since it is no longer on the stack
2572: inv_pp_debug.set_last_error_message(Sqlerrm);
2573: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2574: inv_pp_debug.send_last_error_message;

Line 2581: fnd_msg_pub.count_and_get( p_count => x_msg_count

2577: -- */
2578: rollback to ApplyStrategySP;
2579: FreeGlobals;
2580: x_return_status := fnd_api.g_ret_sts_unexp_error;
2581: fnd_msg_pub.count_and_get( p_count => x_msg_count
2582: ,p_data => x_msg_data );
2583: If (l_debug = 1) then
2584: log_error(l_api_name, 'unexp_error',
2585: 'Unexpected error in Apply - ' || x_msg_data);

Line 2594: -- Note: in debug mode, later call to fnd_msg_pub.get will not get

2590: /*--
2591: -- debugging portion
2592: -- can be commented ut for final code
2593: IF inv_pp_debug.is_debug_mode THEN
2594: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2595: -- the message retrieved here since it is no longer on the stack
2596: inv_pp_debug.set_last_error_message(Sqlerrm);
2597: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2598: inv_pp_debug.send_last_error_message;

Line 2605: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

2601: -- */
2602: rollback to ApplyStrategySP;
2603: FreeGlobals;
2604: x_return_status := fnd_api.g_ret_sts_unexp_error;
2605: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2606: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2607: end if;
2608: fnd_msg_pub.count_and_get( p_count => x_msg_count
2609: ,p_data => x_msg_data );

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

2602: rollback to ApplyStrategySP;
2603: FreeGlobals;
2604: x_return_status := fnd_api.g_ret_sts_unexp_error;
2605: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2606: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2607: end if;
2608: fnd_msg_pub.count_and_get( p_count => x_msg_count
2609: ,p_data => x_msg_data );
2610: If (l_debug = 1) then

Line 2608: fnd_msg_pub.count_and_get( p_count => x_msg_count

2604: x_return_status := fnd_api.g_ret_sts_unexp_error;
2605: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2606: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2607: end if;
2608: fnd_msg_pub.count_and_get( p_count => x_msg_count
2609: ,p_data => x_msg_data );
2610: If (l_debug = 1) then
2611: log_error(l_api_name, 'other_error',
2612: 'Other error in Apply - ' || x_msg_data);