DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on FND_MSG_PUB

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

461: /* --
462: -- debugging portion
463: -- can be commented ut for final code
464: IF inv_pp_debug.is_debug_mode THEN
465: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
466: -- the message retrieved here since it is no longer on the stack
467: inv_pp_debug.set_last_error_message(Sqlerrm);
468: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
469: inv_pp_debug.send_last_error_message;

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

476: if inpline%isopen then
477: close inpline;
478: end if;
479: x_return_status := fnd_api.g_ret_sts_unexp_error;
480: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
481: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
482: end if;
483: fnd_msg_pub.count_and_get( p_count => x_msg_count
484: ,p_data => x_msg_data );

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

477: close inpline;
478: end if;
479: x_return_status := fnd_api.g_ret_sts_unexp_error;
480: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
481: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
482: end if;
483: fnd_msg_pub.count_and_get( p_count => x_msg_count
484: ,p_data => x_msg_data );
485: If (l_debug = 1) then

Line 483: fnd_msg_pub.count_and_get( p_count => x_msg_count

479: x_return_status := fnd_api.g_ret_sts_unexp_error;
480: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
481: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
482: end if;
483: fnd_msg_pub.count_and_get( p_count => x_msg_count
484: ,p_data => x_msg_data );
485: If (l_debug = 1) then
486: log_error(l_api_name, 'error', 'Error in InitInput - ' ||x_msg_data);
487: End if;

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

625: /* --
626: -- debugging portion
627: -- can be commented ut for final code
628: IF inv_pp_debug.is_debug_mode THEN
629: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
630: -- the message retrieved here since it is no longer on the stack
631: inv_pp_debug.set_last_error_message(Sqlerrm);
632: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
633: inv_pp_debug.send_last_error_message;

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

637: if rules%isopen then
638: close rules;
639: end if;
640: x_return_status := fnd_api.g_ret_sts_unexp_error;
641: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
642: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
643: end if;
644: fnd_msg_pub.count_and_get( p_count => x_msg_count
645: ,p_data => x_msg_data );

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

638: close rules;
639: end if;
640: x_return_status := fnd_api.g_ret_sts_unexp_error;
641: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
642: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
643: end if;
644: fnd_msg_pub.count_and_get( p_count => x_msg_count
645: ,p_data => x_msg_data );
646:

Line 644: fnd_msg_pub.count_and_get( p_count => x_msg_count

640: x_return_status := fnd_api.g_ret_sts_unexp_error;
641: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
642: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
643: end if;
644: fnd_msg_pub.count_and_get( p_count => x_msg_count
645: ,p_data => x_msg_data );
646:
647: If (l_debug = 1) then
648: log_error(l_api_name, 'error', 'Error in InitStrategyRules - ' ||

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

826: /* --
827: -- debugging portion
828: -- can be commented ut for final code
829: IF inv_pp_debug.is_debug_mode THEN
830: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
831: -- the message retrieved here since it is no longer on the stack
832: inv_pp_debug.set_last_error_message(Sqlerrm);
833: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
834: inv_pp_debug.send_last_error_message;

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

838: if iteminfo%isopen then
839: close iteminfo;
840: end if;
841: x_return_status := fnd_api.g_ret_sts_unexp_error;
842: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
843: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
844: end if;
845: fnd_msg_pub.count_and_get( p_count => x_msg_count
846: ,p_data => x_msg_data );

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

839: close iteminfo;
840: end if;
841: x_return_status := fnd_api.g_ret_sts_unexp_error;
842: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
843: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
844: end if;
845: fnd_msg_pub.count_and_get( p_count => x_msg_count
846: ,p_data => x_msg_data );
847: If (l_debug = 1) then

Line 845: fnd_msg_pub.count_and_get( p_count => x_msg_count

841: x_return_status := fnd_api.g_ret_sts_unexp_error;
842: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
843: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
844: end if;
845: fnd_msg_pub.count_and_get( p_count => x_msg_count
846: ,p_data => x_msg_data );
847: If (l_debug = 1) then
848: log_error(l_api_name, 'error', 'Error in InitQtyTree - ' || x_msg_data);
849: End if;

Line 1086: fnd_msg_pub.initialize;

1082: end if;
1083:
1084: -- Initialize message list if p_init_msg_list is set to TRUE
1085: if fnd_api.to_boolean( p_init_msg_list ) then
1086: fnd_msg_pub.initialize;
1087: end if;
1088:
1089: -- Initialize API return status to success
1090: x_return_status := fnd_api.g_ret_sts_success;

Line 1098: fnd_msg_pub.add;

1094: if p_validation_level <> fnd_api.g_valid_level_none then
1095: if p_transaction_temp_id is null or
1096: p_transaction_temp_id = fnd_api.g_miss_num then
1097: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
1098: fnd_msg_pub.add;
1099: If (l_debug = 1) then
1100: log_error_msg(l_api_name, 'missing_txn_temp_id');
1101: End if;
1102: raise fnd_api.g_exc_unexpected_error;

Line 1107: fnd_msg_pub.add;

1103: end if;
1104: if p_type_code is null or
1105: p_type_code = fnd_api.g_miss_num then
1106: fnd_message.set_name('WMS','WMS_STRA_TYPE_CODE_MISS');
1107: fnd_msg_pub.add;
1108: If (l_debug = 1) then
1109: log_error_msg(l_api_name, 'missing_type_code');
1110: End if;
1111: raise fnd_api.g_exc_unexpected_error;

Line 1124: fnd_msg_pub.add;

1120: fetch cg_org into l_organization_id;
1121: if cg_org%notfound then
1122: close cg_org;
1123: fnd_message.set_name('WMS','WMS_TRX_REQ_REC_NOTFOUND');
1124: fnd_msg_pub.add;
1125: If (l_debug = 1) then
1126: log_error_msg(l_api_name, 'missing_org_id_cg');
1127: End if;
1128: raise fnd_api.g_exc_unexpected_error;

Line 1137: fnd_msg_pub.add;

1133: fetch input into l_organization_id;
1134: if input%notfound then
1135: close input;
1136: fnd_message.set_name('WMS','WMS_TRX_REQ_REC_NOTFOUND');
1137: fnd_msg_pub.add;
1138: If (l_debug = 1) then
1139: log_error_msg(l_api_name, 'missing_org_id_pp');
1140: End if;
1141: raise fnd_api.g_exc_unexpected_error;

Line 1179: fnd_msg_pub.add;

1175: -- every other return status seems to be unexpected: leave
1176: else
1177: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
1178: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status
1179: fnd_msg_pub.add;
1180: If (l_debug = 1) then
1181: log_error_msg(l_api_name, 'bad_return_status');
1182: End if;
1183: raise fnd_api.g_exc_unexpected_error;

Line 1362: fnd_msg_pub.add;

1358: if l_last_object_found = FALSE then
1359: close hierarchy;
1360: fnd_message.set_name('WMS','WMS_DB_OBJECT_CHAIN');
1361: -- Seed data corrupted: DB object chain
1362: fnd_msg_pub.add;
1363: If (g_debug = 1) then
1364: log_error_msg(l_api_name, 'bad_db_object_chain');
1365: End if;
1366: raise fnd_api.g_exc_unexpected_error;

Line 1432: --fnd_msg_pub.add;

1428: if l_hierarchy = 0 then
1429: fnd_message.set_name('WMS','WMS_SEARCH_ORDER_EMPTY');
1430: --inv_pp_debug.send_message_to_pipe('no search order defined for this org');
1431: -- Strategy search object hierarchy contains no entry
1432: --fnd_msg_pub.add;
1433: If (g_debug = 1) then
1434: log_event(l_api_name, 'no_hierarchy',
1435: 'No strategy search order defined for this organization');
1436: End if;

Line 1443: --fnd_msg_pub.add;

1439: if l_strategy_id is null then
1440: fnd_message.set_name('WMS','WMS_NO_STRATEGY_ASSIGN');
1441: -- inv_pp_debug.send_message_to_pipe('no strategy assigned');
1442: --No active strategy assignment detected according to provided input
1443: --fnd_msg_pub.add;
1444: If (g_debug = 1) then
1445: log_event(l_api_name, 'no_strategy',
1446: 'The strategy search function failed to find a valid ' ||
1447: 'strategy.');

Line 1496: fnd_msg_pub.count_and_get( p_count => x_msg_count

1492: -- Clean up variables for dynamically bound input parameters
1493: inv_sql_binding_pvt.InitBindTables;
1494:
1495: -- Standard call to get message count and if count is 1, get message info
1496: fnd_msg_pub.count_and_get( p_count => x_msg_count
1497: ,p_data => x_msg_data );
1498: IF inv_pp_debug.is_debug_mode THEN
1499: inv_pp_debug.send_message_to_pipe('strategy id found '||l_strategy_id);
1500: END IF;

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

1516: --
1517: -- debugging portion
1518: -- can be commented ut for final code
1519: IF inv_pp_debug.is_debug_mode THEN
1520: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1521: -- the message retrieved here since it is no longer on the stack
1522: inv_pp_debug.set_last_error_message(Sqlerrm);
1523: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1524: --changed by jcearley on 11/22/99 because call was causing error

Line 1535: fnd_msg_pub.count_and_get( p_count => x_msg_count

1531: -- end of debugging section
1532: --
1533: inv_sql_binding_pvt.InitBindTables;
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: fnd_msg_pub.count_and_get( p_count => x_msg_count
1536: ,p_data => x_msg_data );
1537: If (g_debug = 1) then
1538: log_error(l_api_name, 'error', 'Error in Search - ' || x_msg_data);
1539: End if;

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

1544: --
1545: -- debugging portion
1546: -- can be commented ut for final code
1547: IF inv_pp_debug.is_debug_mode THEN
1548: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1549: -- the message retrieved here since it is no longer on the stack
1550: inv_pp_debug.set_last_error_message(Sqlerrm);
1551: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1552: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);

Line 1562: fnd_msg_pub.count_and_get( p_count => x_msg_count

1558: -- end of debugging section
1559: --
1560: inv_sql_binding_pvt.InitBindTables;
1561: x_return_status := fnd_api.g_ret_sts_unexp_error;
1562: fnd_msg_pub.count_and_get( p_count => x_msg_count
1563: ,p_data => x_msg_data );
1564: If (g_debug = 1) then
1565: log_error(l_api_name, 'unexp_error',
1566: 'Unexpected error in Search - ' || x_msg_data);

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

1571: --
1572: -- debugging portion
1573: -- can be commented ut for final code
1574: IF inv_pp_debug.is_debug_mode THEN
1575: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1576: -- the message retrieved here since it is no longer on the stack
1577: inv_pp_debug.set_last_error_message(Sqlerrm);
1578: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1579: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);

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

1597: if conditions%isopen then
1598: close conditions;
1599: end if;
1600: x_return_status := fnd_api.g_ret_sts_unexp_error;
1601: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1602: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1603: end if;
1604: fnd_msg_pub.count_and_get( p_count => x_msg_count
1605: ,p_data => x_msg_data );

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

1598: close conditions;
1599: end if;
1600: x_return_status := fnd_api.g_ret_sts_unexp_error;
1601: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1602: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1603: end if;
1604: fnd_msg_pub.count_and_get( p_count => x_msg_count
1605: ,p_data => x_msg_data );
1606: If (g_debug = 1) then

Line 1604: fnd_msg_pub.count_and_get( p_count => x_msg_count

1600: x_return_status := fnd_api.g_ret_sts_unexp_error;
1601: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1602: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1603: end if;
1604: fnd_msg_pub.count_and_get( p_count => x_msg_count
1605: ,p_data => x_msg_data );
1606: If (g_debug = 1) then
1607: log_error(l_api_name, 'other_error',
1608: 'Other error in Search - ' || x_msg_data);

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

1844: END IF;
1845: EXCEPTION
1846: WHEN FND_API.G_EXC_ERROR THEN
1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1852: WHEN OTHERS THEN

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

1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1852: WHEN OTHERS THEN
1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1855: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

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

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

1851: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1852: WHEN OTHERS THEN
1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1855: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1856: END IF;
1857: END get_max_tolerance;
1858:
1859: -- Start of comments

Line 2054: fnd_msg_pub.initialize;

2050: end if;
2051:
2052: -- Initialize message list if p_init_msg_list is set to TRUE
2053: if fnd_api.to_boolean( p_init_msg_list ) then
2054: fnd_msg_pub.initialize;
2055: end if;
2056:
2057: -- Initialize API return status to success
2058: x_return_status := fnd_api.g_ret_sts_success;

Line 2072: fnd_msg_pub.add;

2068: p_transaction_temp_id = fnd_api.g_miss_num
2069: then
2070: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
2071: -- Transaction input identifier required but not provided
2072: fnd_msg_pub.add;
2073: If (l_debug = 1) then
2074: log_error_msg(l_api_name,'missing_txn_temp_id');
2075: End if;
2076: raise fnd_api.g_exc_unexpected_error;

Line 2083: fnd_msg_pub.add;

2079: p_type_code = fnd_api.g_miss_num
2080: then
2081: fnd_message.set_name('WMS','WMS_STRA_TYPE_CODE_MISS');
2082: -- Strategy type code required but not provided
2083: fnd_msg_pub.add;
2084: If (l_debug = 1) then
2085: log_error_msg(l_api_name,'missing_type_code');
2086: End if;
2087: raise fnd_api.g_exc_unexpected_error;

Line 2094: fnd_msg_pub.add;

2090: if p_strategy_id is null or
2091: p_strategy_id = fnd_api.g_miss_num then
2092: fnd_message.set_name('WMS','WMS_STRATEGY_ID_MISSING');
2093: -- Strategy identifier required but not provided
2094: fnd_msg_pub.add;
2095: raise fnd_api.g_exc_unexpected_error;
2096: end if;
2097: */
2098: end if;

Line 2767: fnd_msg_pub.count_and_get( p_count => x_msg_count

2763: end if;
2764:
2765: --
2766: -- Standard call to get message count and if count is 1, get message info
2767: fnd_msg_pub.count_and_get( p_count => x_msg_count
2768: ,p_data => x_msg_data );
2769: /* --
2770: -- debugging portion
2771: -- can be commented ut for final code

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

2783: /* --
2784: -- debugging portion
2785: -- can be commented ut for final code
2786: IF inv_pp_debug.is_debug_mode THEN
2787: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2788: -- the message retrieved here since it is no longer on the stack
2789: inv_pp_debug.set_last_error_message(Sqlerrm);
2790: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2791: inv_pp_debug.send_last_error_message;

Line 2797: fnd_msg_pub.count_and_get( p_count => x_msg_count

2793: -- end of debugging section
2794: -- */
2795: rollback to ApplyStrategySP;
2796: FreeGlobals;
2797: fnd_msg_pub.count_and_get( p_count => x_msg_count
2798: ,p_data => x_msg_data );
2799: If (l_debug = 1) then
2800: log_error(l_api_name, 'error', 'Error in Apply - ' || x_msg_data);
2801: End if;

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

2805: /*--
2806: -- debugging portion
2807: -- can be commented ut for final code
2808: IF inv_pp_debug.is_debug_mode THEN
2809: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2810: -- the message retrieved here since it is no longer on the stack
2811: inv_pp_debug.set_last_error_message(Sqlerrm);
2812: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2813: inv_pp_debug.send_last_error_message;

Line 2820: fnd_msg_pub.count_and_get( p_count => x_msg_count

2816: -- */
2817: rollback to ApplyStrategySP;
2818: FreeGlobals;
2819: x_return_status := fnd_api.g_ret_sts_unexp_error;
2820: fnd_msg_pub.count_and_get( p_count => x_msg_count
2821: ,p_data => x_msg_data );
2822: If (l_debug = 1) then
2823: log_error(l_api_name, 'unexp_error',
2824: 'Unexpected error in Apply - ' || x_msg_data);

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

2829: /*--
2830: -- debugging portion
2831: -- can be commented ut for final code
2832: IF inv_pp_debug.is_debug_mode THEN
2833: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2834: -- the message retrieved here since it is no longer on the stack
2835: inv_pp_debug.set_last_error_message(Sqlerrm);
2836: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2837: inv_pp_debug.send_last_error_message;

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

2840: -- */
2841: rollback to ApplyStrategySP;
2842: FreeGlobals;
2843: x_return_status := fnd_api.g_ret_sts_unexp_error;
2844: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2845: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2846: end if;
2847: fnd_msg_pub.count_and_get( p_count => x_msg_count
2848: ,p_data => x_msg_data );

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

2841: rollback to ApplyStrategySP;
2842: FreeGlobals;
2843: x_return_status := fnd_api.g_ret_sts_unexp_error;
2844: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2845: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2846: end if;
2847: fnd_msg_pub.count_and_get( p_count => x_msg_count
2848: ,p_data => x_msg_data );
2849: If (l_debug = 1) then

Line 2847: fnd_msg_pub.count_and_get( p_count => x_msg_count

2843: x_return_status := fnd_api.g_ret_sts_unexp_error;
2844: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2845: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2846: end if;
2847: fnd_msg_pub.count_and_get( p_count => x_msg_count
2848: ,p_data => x_msg_data );
2849: If (l_debug = 1) then
2850: log_error(l_api_name, 'other_error',
2851: 'Other error in Apply - ' || x_msg_data);