DBA Data[Home] [Help]

APPS.WMS_COSTGROUPENGINE_PVT dependencies on FND_API

Line 253: IF NOT fnd_api.compatible_api_call( l_api_version

249: END IF;
250: l_debug := g_debug;
251:
252: -- Standard call to check for call compatibility
253: IF NOT fnd_api.compatible_api_call( l_api_version
254: ,p_api_version
255: ,l_api_name
256: ,g_pkg_name ) THEN
257: RAISE fnd_api.g_exc_unexpected_error;

Line 257: RAISE fnd_api.g_exc_unexpected_error;

253: IF NOT fnd_api.compatible_api_call( l_api_version
254: ,p_api_version
255: ,l_api_name
256: ,g_pkg_name ) THEN
257: RAISE fnd_api.g_exc_unexpected_error;
258: END IF;
259:
260:
261: -- Initialize message list if p_init_msg_list is set to TRUE

Line 262: IF fnd_api.to_boolean( p_init_msg_list ) THEN

258: END IF;
259:
260:
261: -- Initialize message list if p_init_msg_list is set to TRUE
262: IF fnd_api.to_boolean( p_init_msg_list ) THEN
263: fnd_msg_pub.initialize;
264: END IF;
265: --
266: -- Initialize API return status to success

Line 267: x_return_status := fnd_api.g_ret_sts_success;

263: fnd_msg_pub.initialize;
264: END IF;
265: --
266: -- Initialize API return status to success
267: x_return_status := fnd_api.g_ret_sts_success;
268:
269: -- debugging portion
270: -- can be commented out for final code
271:

Line 280: IF p_validation_level <> fnd_api.g_valid_level_none THEN

276: END IF;
277:
278: -- Validate input parameters and pre-requisites, if validation level
279: -- requires this
280: IF p_validation_level <> fnd_api.g_valid_level_none THEN
281:
282: --check for null line_id
283: if (p_line_id IS NULL) then
284: fnd_message.set_name('WMS','WMS_CG_MISSING_LINE_ID');

Line 287: raise fnd_api.g_exc_error;

283: if (p_line_id IS NULL) then
284: fnd_message.set_name('WMS','WMS_CG_MISSING_LINE_ID');
285: fnd_msg_pub.add;
286: log_error_msg(l_api_name, 'missing_line_id');
287: raise fnd_api.g_exc_error;
288: end if;
289:
290: --check for null type code
291: if (p_input_type IS NULL) then

Line 295: raise fnd_api.g_exc_error;

291: if (p_input_type IS NULL) then
292: fnd_message.set_name('WMS','WMS_CG_MISSING_INPUT_TYPE');
293: fnd_msg_pub.add;
294: log_error_msg(l_api_name, 'missing_input_type');
295: raise fnd_api.g_exc_error;
296: end if;
297:
298: END IF;
299:

Line 314: raise fnd_api.g_exc_error;

310: ELSE
311: fnd_message.set_name('WMS','WMS_CG_MISSING_INPUT_TYPE');
312: fnd_msg_pub.add;
313: log_error_msg(l_api_name, 'invalid_input_type');
314: raise fnd_api.g_exc_error;
315: END IF;
316:
317: --set record type in global variable
318: g_current_input_type := p_input_type;

Line 344: raise fnd_api.g_exc_error;

340: CLOSE c_input_line_mmtt;
341: fnd_message.set_name('WMS','WMS_CG_LINE_NOT_FOUND');
342: fnd_msg_pub.add;
343: log_error_msg(l_api_name, 'line_not_found');
344: raise fnd_api.g_exc_error;
345: END IF;
346: CLOSE c_input_line_mmtt;
347: ELSIF p_input_type = g_input_mtrl THEN
348: OPEN c_input_line_mtrl;

Line 358: raise fnd_api.g_exc_error;

354: CLOSE c_input_line_mtrl;
355: fnd_message.set_name('WMS','WMS_CG_LINE_NOT_FOUND');
356: fnd_msg_pub.add;
357: log_error_msg(l_api_name, 'line_not_found');
358: raise fnd_api.g_exc_error;
359: END IF;
360: CLOSE c_input_line_mtrl;
361: END IF;
362:

Line 410: ,p_init_msg_list => fnd_api.g_false

406: log_event(l_api_name, 'p_organization_id', l_organization_id);
407: end if;
408: wms_rules_workbench_pvt.cg_mmtt_search
409: ( p_api_version => 1.0
410: ,p_init_msg_list => fnd_api.g_false
411: ,p_validation_level => fnd_api.g_valid_level_none
412: ,x_return_status => l_return_status
413: ,x_msg_count => x_msg_count
414: ,x_msg_data => x_msg_data

Line 411: ,p_validation_level => fnd_api.g_valid_level_none

407: end if;
408: wms_rules_workbench_pvt.cg_mmtt_search
409: ( p_api_version => 1.0
410: ,p_init_msg_list => fnd_api.g_false
411: ,p_validation_level => fnd_api.g_valid_level_none
412: ,x_return_status => l_return_status
413: ,x_msg_count => x_msg_count
414: ,x_msg_data => x_msg_data
415: ,p_transaction_temp_id => p_line_id

Line 434: ,p_init_msg_list => fnd_api.g_false

430: log_event(l_api_name, 'Search', 'wms_rules_workbench_pvt.search');
431: end if;
432: wms_rules_workbench_pvt.Search
433: ( p_api_version => 1.0
434: ,p_init_msg_list => fnd_api.g_false
435: ,p_validation_level => fnd_api.g_valid_level_none
436: ,x_return_status => l_return_status
437: ,x_msg_count => x_msg_count
438: ,x_msg_data => x_msg_data

Line 435: ,p_validation_level => fnd_api.g_valid_level_none

431: end if;
432: wms_rules_workbench_pvt.Search
433: ( p_api_version => 1.0
434: ,p_init_msg_list => fnd_api.g_false
435: ,p_validation_level => fnd_api.g_valid_level_none
436: ,x_return_status => l_return_status
437: ,x_msg_count => x_msg_count
438: ,x_msg_data => x_msg_data
439: ,p_transaction_temp_id => p_line_id

Line 454: if l_return_status = fnd_api.g_ret_sts_unexp_error then

450: log_statement(l_api_name, ': l_sequence_number ', l_sequence_number );
451: log_event(l_api_name, 'search', 'End');
452: end if;
453: End if;
454: if l_return_status = fnd_api.g_ret_sts_unexp_error then
455: if l_debug = 1 THEN
456: log_error(l_api_name, 'strat_search_unexp_err',
457: 'Unexpected error in wms_strategy_pvt search procedure');
458: end if;

Line 459: raise fnd_api.g_exc_unexpected_error;

455: if l_debug = 1 THEN
456: log_error(l_api_name, 'strat_search_unexp_err',
457: 'Unexpected error in wms_strategy_pvt search procedure');
458: end if;
459: raise fnd_api.g_exc_unexpected_error;
460:
461: elsif l_return_status = fnd_api.g_ret_sts_error then
462: if l_debug = 1 then
463: log_error(l_api_name, 'strat_search_err',

Line 461: elsif l_return_status = fnd_api.g_ret_sts_error then

457: 'Unexpected error in wms_strategy_pvt search procedure');
458: end if;
459: raise fnd_api.g_exc_unexpected_error;
460:
461: elsif l_return_status = fnd_api.g_ret_sts_error then
462: if l_debug = 1 then
463: log_error(l_api_name, 'strat_search_err',
464: 'Error in wms_strategy_pvt search procedure');
465: end if;

Line 466: raise fnd_api.g_exc_error;

462: if l_debug = 1 then
463: log_error(l_api_name, 'strat_search_err',
464: 'Error in wms_strategy_pvt search procedure');
465: end if;
466: raise fnd_api.g_exc_error;
467: elsif l_return_status = fnd_api.g_ret_sts_success then
468: --If l_rules_engine_mode = 1 then
469: -- {{[ Test Case # UTK-REALLOC-3.1.3:3c
470: -- Description: Strategy search based on rule and strategy assignments

Line 467: elsif l_return_status = fnd_api.g_ret_sts_success then

463: log_error(l_api_name, 'strat_search_err',
464: 'Error in wms_strategy_pvt search procedure');
465: end if;
466: raise fnd_api.g_exc_error;
467: elsif l_return_status = fnd_api.g_ret_sts_success then
468: --If l_rules_engine_mode = 1 then
469: -- {{[ Test Case # UTK-REALLOC-3.1.3:3c
470: -- Description: Strategy search based on rule and strategy assignments
471: -- Searching Cost Group rule assignments Misc Receipt ] }}

Line 529: if l_return_status = fnd_api.g_ret_sts_unexp_error then

525: ,x_msg_count
526: ,x_msg_data
527: ,l_strategy_id );
528:
529: if l_return_status = fnd_api.g_ret_sts_unexp_error then
530: if l_debug = 1 then
531: log_error(l_api_name, 'init_rules_unexp_err',
532: 'Unexpected error in wms_strategy_pvt InitStrategyRules');
533: end if;

Line 534: raise fnd_api.g_exc_unexpected_error;

530: if l_debug = 1 then
531: log_error(l_api_name, 'init_rules_unexp_err',
532: 'Unexpected error in wms_strategy_pvt InitStrategyRules');
533: end if;
534: raise fnd_api.g_exc_unexpected_error;
535: elsif l_return_status = fnd_api.g_ret_sts_error then
536: if l_debug = 1 then
537: log_error(l_api_name, 'init_rules_err',
538: 'Error in wms_strategy_pvt InitStrategyRules');

Line 535: elsif l_return_status = fnd_api.g_ret_sts_error then

531: log_error(l_api_name, 'init_rules_unexp_err',
532: 'Unexpected error in wms_strategy_pvt InitStrategyRules');
533: end if;
534: raise fnd_api.g_exc_unexpected_error;
535: elsif l_return_status = fnd_api.g_ret_sts_error then
536: if l_debug = 1 then
537: log_error(l_api_name, 'init_rules_err',
538: 'Error in wms_strategy_pvt InitStrategyRules');
539: end if;

Line 540: raise fnd_api.g_exc_error;

536: if l_debug = 1 then
537: log_error(l_api_name, 'init_rules_err',
538: 'Error in wms_strategy_pvt InitStrategyRules');
539: end if;
540: raise fnd_api.g_exc_error;
541: end if;
542: END IF;
543: -- Loop through all the rules, until all input lines are satisfied
544: -- [ call the rule and exit from the loop ]

Line 615: RAISE fnd_api.g_exc_unexpected_error;

611: log_statement(l_api_name, 'l_sql_return ', l_sql_return );
612: log_error_msg(l_api_name, 'rule_package_missing');
613: log_statement(l_api_name,'', 'Package name: ' || l_package_name);
614: end if;
615: RAISE fnd_api.g_exc_unexpected_error;
616: ELSIF l_sql_return <> -1 THEN
617: EXIT;
618: END IF;
619: END LOOP;

Line 734: raise fnd_api.g_exc_error;

730: fnd_msg_pub.add;
731: if l_debug = 1 then
732: log_error_msg(l_api_name, 'no_default_org_cg');
733: end if;
734: raise fnd_api.g_exc_error;
735: END IF;
736: CLOSE l_default_cg_org;
737: if l_debug = 1 then
738: log_event(l_api_name, 'default_cg_for_org',

Line 781: IF fnd_api.to_boolean(p_commit) THEN

777: wms_search_order_globals_pvt.g_costgroup_id := l_cost_group_id;
778: END IF;
779:
780: -- Standard check of p_commit
781: IF fnd_api.to_boolean(p_commit) THEN
782: COMMIT WORK;
783: END IF;
784:
785: -- debugging portion

Line 793: WHEN fnd_api.g_exc_error THEN

789: log_procedure(l_api_name, '', 'End Assign_Cost_Group');
790: end if;
791: EXCEPTION
792:
793: WHEN fnd_api.g_exc_error THEN
794:
795: ROLLBACK TO assignCGSP;
796: x_return_status := fnd_api.g_ret_sts_error;
797: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 796: x_return_status := fnd_api.g_ret_sts_error;

792:
793: WHEN fnd_api.g_exc_error THEN
794:
795: ROLLBACK TO assignCGSP;
796: x_return_status := fnd_api.g_ret_sts_error;
797: fnd_msg_pub.count_and_get( p_count => x_msg_count
798: ,p_data => x_msg_data );
799: if l_debug = 1 then
800: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);

Line 806: x_return_status := fnd_api.g_ret_sts_unexp_error;

802:
803: WHEN OTHERS THEN
804:
805: ROLLBACK TO assignCGSP;
806: x_return_status := fnd_api.g_ret_sts_unexp_error;
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,'unexp_error','Unexpected error - ' || x_msg_data);