DBA Data[Home] [Help]

APPS.CTO_MATCH_AND_RESERVE dependencies on FND_API

Line 329: if x_return_status = FND_API.G_RET_STS_ERROR then

325: x_return_status => x_Return_Status,
326: x_msg_count => X_Msg_Count,
327: x_msg_data => X_Msg_Data);
328:
329: if x_return_status = FND_API.G_RET_STS_ERROR then
330: IF PG_DEBUG <> 0 THEN
331: oe_debug_pub.add ('Failed in populate_bcol with expected error.', 1);
332: END IF;
333:

Line 335: raise FND_API.G_EXC_ERROR;

331: oe_debug_pub.add ('Failed in populate_bcol with expected error.', 1);
332: END IF;
333:
334: cto_msg_pub.cto_message('BOM','CTO_MATCH_AND_RESERVE');
335: raise FND_API.G_EXC_ERROR;
336:
337: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
338: IF PG_DEBUG <> 0 THEN
339: oe_debug_pub.add ('Failed in populate_bcol with unexpected error.', 1);

Line 337: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

333:
334: cto_msg_pub.cto_message('BOM','CTO_MATCH_AND_RESERVE');
335: raise FND_API.G_EXC_ERROR;
336:
337: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
338: IF PG_DEBUG <> 0 THEN
339: oe_debug_pub.add ('Failed in populate_bcol with unexpected error.', 1);
340: END IF;
341:

Line 343: raise FND_API.G_EXC_UNEXPECTED_ERROR;

339: oe_debug_pub.add ('Failed in populate_bcol with unexpected error.', 1);
340: END IF;
341:
342: cto_msg_pub.cto_message('BOM','CTO_MATCH_AND_RESERVE');
343: raise FND_API.G_EXC_UNEXPECTED_ERROR;
344: end if;
345:
346: IF PG_DEBUG <> 0 THEN
347: oe_debug_pub.add('After populate_bcol.', 1);

Line 520: IF ( x_return_status = fnd_api.G_RET_STS_ERROR) THEN

516:
517:
518: oe_debug_pub.add ('match_inquiry: CTO_CONFIGURED_ITEM_GRP.match_configured_item done ' , 1) ;
519:
520: IF ( x_return_status = fnd_api.G_RET_STS_ERROR) THEN
521: IF PG_DEBUG <> 0 THEN
522: oe_debug_pub.add ('Create_Item: ' ||
523: 'CTO_CONFIGURED_ITEM_GRP.match_configured_item returned with expected error.');
524: END IF;

Line 525: raise FND_API.G_EXC_ERROR;

521: IF PG_DEBUG <> 0 THEN
522: oe_debug_pub.add ('Create_Item: ' ||
523: 'CTO_CONFIGURED_ITEM_GRP.match_configured_item returned with expected error.');
524: END IF;
525: raise FND_API.G_EXC_ERROR;
526:
527: ELSIF ( x_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
528: IF PG_DEBUG <> 0 THEN
529: oe_debug_pub.add ('Create_Item: ' ||

Line 527: ELSIF ( x_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN

523: 'CTO_CONFIGURED_ITEM_GRP.match_configured_item returned with expected error.');
524: END IF;
525: raise FND_API.G_EXC_ERROR;
526:
527: ELSIF ( x_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
528: IF PG_DEBUG <> 0 THEN
529: oe_debug_pub.add ('Create_Item: ' ||
530: 'CTO_CONFIGURED_ITEM_GRP.match_configured_item returned with unexp error.');
531: END IF;

Line 532: raise FND_API.G_EXC_UNEXPECTED_ERROR;

528: IF PG_DEBUG <> 0 THEN
529: oe_debug_pub.add ('Create_Item: ' ||
530: 'CTO_CONFIGURED_ITEM_GRP.match_configured_item returned with unexp error.');
531: END IF;
532: raise FND_API.G_EXC_UNEXPECTED_ERROR;
533:
534: END IF;
535:
536:

Line 629: IF ( l_Status <> 1 and X_Return_Status = FND_API.G_RET_STS_ERROR) THEN

625: x_return_status => x_return_status,
626: x_msg_count => x_msg_count,
627: x_msg_data => x_msg_data);
628:
629: IF ( l_Status <> 1 and X_Return_Status = FND_API.G_RET_STS_ERROR) THEN
630: IF PG_DEBUG <> 0 THEN
631: oe_debug_pub.add('CTO_MSUTIL_PUB.Populate_src_orgs returned with exp error',1);
632: END IF;
633:

Line 634: raise FND_API.G_EXC_ERROR;

630: IF PG_DEBUG <> 0 THEN
631: oe_debug_pub.add('CTO_MSUTIL_PUB.Populate_src_orgs returned with exp error',1);
632: END IF;
633:
634: raise FND_API.G_EXC_ERROR;
635:
636: ELSIF ( l_Status <> 1 and X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
637: IF PG_DEBUG <> 0 THEN
638: oe_debug_pub.add('CTO_MSUTIL_PUB.Populate_src_orgs returned with unexp error',1);

Line 636: ELSIF ( l_Status <> 1 and X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

632: END IF;
633:
634: raise FND_API.G_EXC_ERROR;
635:
636: ELSIF ( l_Status <> 1 and X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
637: IF PG_DEBUG <> 0 THEN
638: oe_debug_pub.add('CTO_MSUTIL_PUB.Populate_src_orgs returned with unexp error',1);
639: END IF;
640:

Line 641: raise FND_API.G_EXC_UNEXPECTED_ERROR;

637: IF PG_DEBUG <> 0 THEN
638: oe_debug_pub.add('CTO_MSUTIL_PUB.Populate_src_orgs returned with unexp error',1);
639: END IF;
640:
641: raise FND_API.G_EXC_UNEXPECTED_ERROR;
642:
643: END IF;
644:
645:

Line 667: IF (l_status <> 1 and x_Return_Status = fnd_api.g_ret_sts_error ) then

663: xReturnStatus => x_Return_Status,
664: xMsgCount => x_msg_count,
665: XMsgData => x_msg_data);
666:
667: IF (l_status <> 1 and x_Return_Status = fnd_api.g_ret_sts_error ) then
668: IF PG_DEBUG <> 0 THEN
669: oe_debug_pub.add ('Create_All_Items returned with 0', 1);
670: END IF;
671:

Line 674: raise FND_API.G_EXC_ERROR;

670: END IF;
671:
672:
673: --cto_msg_pub.cto_message('BOM','CTO_MATCH_AND_RESERVE');
674: raise FND_API.G_EXC_ERROR;
675:
676: ELSIF (l_status <> 1 and x_Return_Status = fnd_api.g_ret_sts_unexp_error ) then
677: IF PG_DEBUG <> 0 THEN
678: oe_debug_pub.add ('Create_All_Items returned with 0', 1);

Line 676: ELSIF (l_status <> 1 and x_Return_Status = fnd_api.g_ret_sts_unexp_error ) then

672:
673: --cto_msg_pub.cto_message('BOM','CTO_MATCH_AND_RESERVE');
674: raise FND_API.G_EXC_ERROR;
675:
676: ELSIF (l_status <> 1 and x_Return_Status = fnd_api.g_ret_sts_unexp_error ) then
677: IF PG_DEBUG <> 0 THEN
678: oe_debug_pub.add ('Create_All_Items returned with 0', 1);
679: END IF ;
680:

Line 683: raise FND_API.G_EXC_UNEXPECTED_ERROR;

679: END IF ;
680:
681:
682: --cto_msg_pub.cto_message('BOM','CTO_MATCH_AND_RESERVE');
683: raise FND_API.G_EXC_UNEXPECTED_ERROR;
684:
685: END IF;
686:
687:

Line 789: raise FND_API.G_EXC_UNEXPECTED_ERROR;

785: IF PG_DEBUG <> 0 THEN
786: oe_debug_pub.add('CTOMCRSB: ' || 'return value from display_wf_status' ||return_value ,1);
787: END IF;
788: cto_msg_pub.cto_message('CTO', 'CTO_ERROR_FROM_DISPLAY_STATUS');
789: raise FND_API.G_EXC_UNEXPECTED_ERROR;
790: end if;
791:
792:
793:

Line 827: , p_init_msg_lst => fnd_api.g_false

823: +--------------------------------------------------*/
824: l_stmt_num := 150;
825: INV_QUANTITY_TREE_GRP.create_tree
826: ( p_api_version_number => 1.0
827: , p_init_msg_lst => fnd_api.g_false
828: , x_return_status => l_return_status
829: , x_msg_count => x_msg_count
830: , x_msg_data => x_msg_data
831: , p_organization_id => l_org_id

Line 839: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

835: , p_is_lot_control => FALSE
836: , p_is_serial_control => FALSE
837: , x_tree_id => l_tree_id);
838:
839: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
840: IF PG_DEBUG <> 0 THEN
841: oe_debug_pub.add('Failed in create_tree with status: ' ||
842: l_return_status, 1);
843: END IF;

Line 860: p_init_msg_lst => fnd_api.g_false,

856: +------------------------------------------------------*/
857: l_stmt_num := 160;
858: INV_QUANTITY_TREE_GRP.query_tree
859: (p_api_version_number => 1.0,
860: p_init_msg_lst => fnd_api.g_false,
861: x_return_status => l_return_status,
862: x_msg_count => x_msg_count,
863: x_msg_data => x_msg_data,
864: p_tree_id => l_tree_id,

Line 876: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

872: x_qs => l_x_qs,
873: x_att => l_x_att,
874: x_atr => x_available_qty);
875:
876: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
877: IF PG_DEBUG <> 0 THEN
878: oe_debug_pub.add('Failed in create_tree with status: ' ||
879: l_return_status, 1);
880: END IF;

Line 1038: if x_return_status = FND_API.G_RET_STS_ERROR then

1034:
1035:
1036:
1037:
1038: if x_return_status = FND_API.G_RET_STS_ERROR then
1039: IF PG_DEBUG <> 0 THEN
1040: oe_debug_pub.add(' Failed in Create_purchasing_doc call...',1);
1041: END IF ;
1042:

Line 1044: -- raise FND_API.G_EXC_ERROR;

1040: oe_debug_pub.add(' Failed in Create_purchasing_doc call...',1);
1041: END IF ;
1042:
1043:
1044: -- raise FND_API.G_EXC_ERROR;
1045: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1046: IF PG_DEBUG <> 0 THEN
1047: oe_debug_pub.add(' Failed in Create_purchasing_doc call...',1);
1048: END IF;

Line 1045: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1041: END IF ;
1042:
1043:
1044: -- raise FND_API.G_EXC_ERROR;
1045: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1046: IF PG_DEBUG <> 0 THEN
1047: oe_debug_pub.add(' Failed in Create_purchasing_doc call...',1);
1048: END IF;
1049:

Line 1051: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

1047: oe_debug_pub.add(' Failed in Create_purchasing_doc call...',1);
1048: END IF;
1049:
1050:
1051: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
1052: end if;
1053:
1054:
1055: else

Line 1092: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1088: oe_debug_pub.add('Failure in cost_rollup ', 1);
1089: END IF;
1090:
1091: cto_msg_pub.cto_message('BOM', x_msg_data);
1092: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1093: else
1094: IF PG_DEBUG <> 0 THEN
1095: oe_debug_pub.add('Success in cost_rollup ', 1);
1096: END IF;

Line 1189: WHEN FND_API.G_EXC_ERROR THEN

1185: END IF;
1186:
1187: return FALSE;
1188:
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: x_error_message := 'CTOMCRSB:match_inquiry failed with expected error in stmt '
1191: ||to_char(l_stmt_num);
1192: IF PG_DEBUG <> 0 THEN
1193: oe_debug_pub.add ('match_inquiry: exp_error ' || to_char(l_stmt_num) ||sqlerrm,1);

Line 1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1194: END IF;
1195:
1196: return FALSE;
1197:
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: x_error_message := 'CTOMCRSB:match_inquiry failed with unexpected error in stmt '
1200: ||to_char(l_stmt_num);
1201: IF PG_DEBUG <> 0 THEN
1202: oe_debug_pub.add ('match_inquiry: unexp_error ' || to_char(l_stmt_num) ||sqlerrm,1);

Line 1422: if (l_x_status = FND_API.g_ret_sts_success) then

1418: else
1419: raise PROCESS_ERROR;
1420: end if;
1421:
1422: if (l_x_status = FND_API.g_ret_sts_success) then
1423: l_stmt_num := 160;
1424: IF PG_DEBUG <> 0 THEN
1425: oe_debug_pub.add
1426: ('create_config_reservation: ' || 'Success in reserve_config with reservation id:' ||