DBA Data[Home] [Help]

APPS.WSH_BATCH_PROCESS dependencies on FND_API

Line 657: p_init_msg_list => FND_API.G_FALSE,

653: END IF;
654:
655: WSH_DELIVERIES_GRP.Delivery_Action
656: ( p_api_version_number => 1.0,
657: p_init_msg_list => FND_API.G_FALSE,
658: p_commit => FND_API.G_FALSE,
659: p_action_prms => l_action_prms,
660: p_rec_attr_tab => l_rec_attr_tab,
661: x_delivery_out_rec => l_delivery_out_rec,

Line 658: p_commit => FND_API.G_FALSE,

654:
655: WSH_DELIVERIES_GRP.Delivery_Action
656: ( p_api_version_number => 1.0,
657: p_init_msg_list => FND_API.G_FALSE,
658: p_commit => FND_API.G_FALSE,
659: p_action_prms => l_action_prms,
660: p_rec_attr_tab => l_rec_attr_tab,
661: x_delivery_out_rec => l_delivery_out_rec,
662: x_defaults_rec => l_defaults_rec,

Line 817: p_init_msg_list => FND_API.G_FALSE,

813:
814:
815: WSH_TRIP_STOPS_GRP.Stop_Action
816: ( p_api_version_number => 1.0,
817: p_init_msg_list => FND_API.G_FALSE,
818: p_commit => FND_API.G_FALSE,
819: p_action_prms => l_action_prms,
820: p_rec_attr_tab => l_rec_attr_tab,
821: x_stop_out_rec => l_stop_out_rec,

Line 818: p_commit => FND_API.G_FALSE,

814:
815: WSH_TRIP_STOPS_GRP.Stop_Action
816: ( p_api_version_number => 1.0,
817: p_init_msg_list => FND_API.G_FALSE,
818: p_commit => FND_API.G_FALSE,
819: p_action_prms => l_action_prms,
820: p_rec_attr_tab => l_rec_attr_tab,
821: x_stop_out_rec => l_stop_out_rec,
822: x_def_rec => l_def_rec,

Line 1111: AND p_commit = FND_API.G_TRUE ) THEN

1107:
1108: --
1109: --bug 4070732
1110: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)
1111: AND p_commit = FND_API.G_TRUE ) THEN
1112: --{
1113: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1114: --{
1115:

Line 1177: IF ( P_COMMIT = FND_API.G_TRUE ) THEN

1173: END IF;
1174:
1175: -- Following if condition is added for Bugfix #4001135
1176: -- We will commit the data only when this api is called from Concurrent Request.
1177: IF ( P_COMMIT = FND_API.G_TRUE ) THEN
1178: COMMIT;
1179: END IF;
1180:
1181: END LOOP;

Line 1246: AND p_commit = FND_API.G_TRUE ) THEN

1242:
1243: --
1244: --bug 4070732
1245: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)
1246: AND p_commit = FND_API.G_TRUE ) THEN
1247: --{
1248: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1249: --{
1250:

Line 1309: IF ( P_COMMIT = FND_API.G_TRUE ) THEN

1305: END IF;
1306:
1307: -- Following if condition is added for Bugfix #4001135
1308: -- We will commit the data only when this api is called from Concurrent Request.
1309: IF ( P_COMMIT = FND_API.G_TRUE ) THEN
1310: COMMIT;
1311: END IF;
1312:
1313: END LOOP;

Line 1576: p_init_msg_list => FND_API.G_FALSE,

1572:
1573:
1574: WSH_DELIVERIES_GRP.Delivery_Action
1575: ( p_api_version_number => 1.0,
1576: p_init_msg_list => FND_API.G_FALSE,
1577: p_commit => FND_API.G_FALSE,
1578: p_action_prms => l_action_prms,
1579: p_rec_attr_tab => l_rec_attr_tab,
1580: x_delivery_out_rec => l_delivery_out_rec,

Line 1577: p_commit => FND_API.G_FALSE,

1573:
1574: WSH_DELIVERIES_GRP.Delivery_Action
1575: ( p_api_version_number => 1.0,
1576: p_init_msg_list => FND_API.G_FALSE,
1577: p_commit => FND_API.G_FALSE,
1578: p_action_prms => l_action_prms,
1579: p_rec_attr_tab => l_rec_attr_tab,
1580: x_delivery_out_rec => l_delivery_out_rec,
1581: x_defaults_rec => l_defaults_rec,

Line 1763: AND p_commit = FND_API.G_TRUE ) THEN

1759:
1760: --
1761: --bug 4070732
1762: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)
1763: AND p_commit = FND_API.G_TRUE ) THEN
1764: --{
1765: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1766: --{
1767:

Line 1833: IF ( P_COMMIT = FND_API.G_TRUE ) THEN

1829: END IF;
1830:
1831: -- Following if condition is added for Bugfix #4001135
1832: -- We will commit the data only when this api is called from Concurrent Request.
1833: IF ( P_COMMIT = FND_API.G_TRUE ) THEN
1834: COMMIT;
1835: END IF;
1836:
1837: END LOOP;

Line 2261: p_commit => FND_API.G_TRUE); -- BugFix #4001135

2257: p_log_level => l_log_level,
2258: x_confirmed_del_tab => l_confirmed_del_tab,
2259: x_results_summary => l_results_summary,
2260: x_return_status => l_return_status,
2261: p_commit => FND_API.G_TRUE); -- BugFix #4001135
2262:
2263: WSH_UTIL_CORE.PrintDateTime;
2264: WSH_UTIL_CORE.PrintMsg('Summary: ');
2265: WSH_UTIL_CORE.PrintMsg(to_char(l_selected_del_tab.count) ||' deliveries selected to be ship confirmed');

Line 2672: p_commit => FND_API.G_TRUE); -- BugFix #4001135

2668: p_log_level => l_log_level,
2669: x_packed_del_tab => l_packed_del_tab,
2670: x_results_summary => l_results_summary,
2671: x_return_status => l_return_status,
2672: p_commit => FND_API.G_TRUE); -- BugFix #4001135
2673:
2674: IF l_debug_on THEN
2675: WSH_DEBUG_SV.logmsg(l_module_name, 'Deliveries successfully packed are: ');
2676: FOR k in 1 .. l_packed_del_tab.count LOOP

Line 2827: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,

2823: IF l_debug_on THEN
2824: WSH_DEBUG_SV.logmsg(l_module_name,'COUNT--',c);
2825: END IF;
2826: FOR i in 1..c LOOP
2827: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,
2828: p_msg_index => i,
2829: p_data => l_buffer,
2830: p_msg_index_out => l_index_out);
2831: -- pass only first 2000 characters of l_buffer

Line 3443: p_commit => FND_API.G_FALSE,

3439: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
3440: p_delivery_detail_tbl => p_selected_det_tbl,
3441: p_append_flag => l_append_flag,
3442: p_group_by_header => l_ac_del_criteria,
3443: p_commit => FND_API.G_FALSE,
3444: p_lock_rows => FND_API.G_TRUE,
3445: p_check_fte_compatibility => FND_API.G_TRUE,
3446: x_appended_det_tbl => l_appended_det_tbl,
3447: x_unappended_det_tbl => l_unappended_det_tbl,

Line 3444: p_lock_rows => FND_API.G_TRUE,

3440: p_delivery_detail_tbl => p_selected_det_tbl,
3441: p_append_flag => l_append_flag,
3442: p_group_by_header => l_ac_del_criteria,
3443: p_commit => FND_API.G_FALSE,
3444: p_lock_rows => FND_API.G_TRUE,
3445: p_check_fte_compatibility => FND_API.G_TRUE,
3446: x_appended_det_tbl => l_appended_det_tbl,
3447: x_unappended_det_tbl => l_unappended_det_tbl,
3448: x_appended_del_tbl => l_appended_del_tbl,

Line 3445: p_check_fte_compatibility => FND_API.G_TRUE,

3441: p_append_flag => l_append_flag,
3442: p_group_by_header => l_ac_del_criteria,
3443: p_commit => FND_API.G_FALSE,
3444: p_lock_rows => FND_API.G_TRUE,
3445: p_check_fte_compatibility => FND_API.G_TRUE,
3446: x_appended_det_tbl => l_appended_det_tbl,
3447: x_unappended_det_tbl => l_unappended_det_tbl,
3448: x_appended_del_tbl => l_appended_del_tbl,
3449: x_return_status => l_return_status);

Line 3455: p_encoded => FND_API.G_FALSE

3451: FND_MSG_PUB.Count_And_Get
3452: (
3453: p_count => l_msg_count,
3454: p_data => l_msg_data,
3455: p_encoded => FND_API.G_FALSE
3456: );
3457: x_appended_det_num := l_appended_det_tbl.count;
3458: x_msg_count := l_msg_count;
3459: x_msg_data := l_msg_data;

Line 3486: p_init_msg_list => FND_API.G_FALSE,

3482: l_action_prms.group_by_header_flag := l_ac_del_criteria;
3483:
3484: wsh_interface_grp.delivery_detail_action(
3485: p_api_version_number => 1.0,
3486: p_init_msg_list => FND_API.G_FALSE,
3487: p_commit => FND_API.G_FALSE,
3488: x_return_status => l_return_status,
3489: x_msg_count => l_msg_count,
3490: x_msg_data => l_msg_data,

Line 3487: p_commit => FND_API.G_FALSE,

3483:
3484: wsh_interface_grp.delivery_detail_action(
3485: p_api_version_number => 1.0,
3486: p_init_msg_list => FND_API.G_FALSE,
3487: p_commit => FND_API.G_FALSE,
3488: x_return_status => l_return_status,
3489: x_msg_count => l_msg_count,
3490: x_msg_data => l_msg_data,
3491: p_detail_id_tab => l_unappended_det_tbl,

Line 3545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3541: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_DELIVERY_FAILED');
3542: END IF;
3543:
3544: WHEN OTHERS THEN
3545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3546: ROLLBACK TO BEFORE_PROCESS_DELIVERIES;
3547: wsh_util_core.add_message(x_return_status, l_module_name);
3548: WSH_UTIL_CORE.default_handler('WSH_BATCH_PROCESS.Process_Delivery_Lines_Batch');
3549: FND_MSG_PUB.Count_And_Get

Line 3553: p_encoded => FND_API.G_FALSE

3549: FND_MSG_PUB.Count_And_Get
3550: (
3551: p_count => x_msg_count,
3552: p_data => x_msg_data,
3553: p_encoded => FND_API.G_FALSE
3554: );
3555:
3556: IF l_debug_on THEN
3557: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4081: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,

4077: FND_FILE.put_line(FND_FILE.output,'====================');
4078: WSH_UTIL_CORE.PrintMsg('List of Messages: ');
4079: WSH_UTIL_CORE.PrintMsg('====================');
4080: FOR i in 1..l_msg_count LOOP
4081: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,
4082: p_msg_index => i,
4083: p_data => l_buffer,
4084: p_msg_index_out => l_index_out);
4085: IF l_buffer IS NOT NULL THEN

Line 4341: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,

4337: FND_FILE.put_line(FND_FILE.output,'====================');
4338:
4339: WSH_UTIL_CORE.PrintMsg('====================');
4340: FOR i in 1..l_msg_count LOOP
4341: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,
4342: p_msg_index => i,
4343: p_data => l_buffer,
4344: p_msg_index_out => l_index_out);
4345: IF l_buffer IS NOT NULL THEN