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 1040: if x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 1046: -- raise FND_API.G_EXC_ERROR;

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

Line 1047: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 1053: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1094: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1191: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

1435: else
1436: raise PROCESS_ERROR;
1437: end if;
1438:
1439: if (l_x_status = FND_API.g_ret_sts_success) then
1440: l_stmt_num := 160;
1441: IF PG_DEBUG <> 0 THEN
1442: oe_debug_pub.add
1443: ('create_config_reservation: ' || 'Success in reserve_config with reservation id:' ||