DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on FND_API

Line 515: raise FND_API.G_EXC_ERROR;

511: end if ;
512:
513: if (lOEValidationOrg = -99) then --bugfix 2646849
514: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');
515: raise FND_API.G_EXC_ERROR;
516: end if;
517:
518: IF PG_DEBUG <> 0 THEN
519: oe_debug_pub.add('create_bom_ml: ' || 'Validation Org is :' || lOEValidationOrg,2);

Line 549: raise FND_API.G_EXC_ERROR;

545: if (lStatus = 0) then
546: IF PG_DEBUG <> 0 THEN
547: oe_debug_pub.add('create_bom_ml: ' || 'Failed in get_model_lead_time. Error Buffer : '||lERrBuf, 1);
548: END IF;
549: raise FND_API.G_EXC_ERROR;
550: else
551: lTotLeadTime := lLeadTime + lTotLeadTime;
552: end if;
553:

Line 895: raise fnd_api.g_exc_error;

891:
892:
893: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP', l_token1 );
894:
895: raise fnd_api.g_exc_error;
896:
897:
898: /* Please incorporate raising exception */
899:

Line 1262: raise fnd_api.g_exc_error;

1258: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR',l_token2);
1259:
1260: end loop ;
1261:
1262: raise fnd_api.g_exc_error;
1263:
1264: end if ;
1265:
1266: end if;

Line 1455: raise fnd_api.g_exc_error;

1451: when others then
1452: IF PG_DEBUG <> 0 THEN
1453: oe_debug_pub.add('Others excepn from stmt '||lStmtNum ||':'||sqlerrm);
1454: END IF;
1455: raise fnd_api.g_exc_error;
1456: END ;
1457: end loop;
1458:
1459: /* gDropItem is set to 0 . Not resetting this to 1

Line 1572: raise fnd_api.g_exc_error;

1568: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1569:
1570:
1571:
1572: raise fnd_api.g_exc_error;
1573:
1574: end if;
1575:
1576: end if;

Line 1902: raise fnd_api.g_exc_error;

1898: cto_msg_pub.cto_message('BOM','CTO_MODEL_LINE_EXCPN_HOLD');
1899:
1900:
1901:
1902: raise fnd_api.g_exc_error;
1903:
1904: end if; /* create item profile condition */
1905:
1906: end if; /* missed lines cursor condition */

Line 1920: raise fnd_api.g_exc_error;

1916: when others then
1917: IF PG_DEBUG <> 0 THEN
1918: oe_debug_pub.add ('Failed in stmt ' || lStmtNum || ' with error: '||sqlerrm);
1919: END IF;
1920: raise fnd_api.g_exc_error;
1921: END ;
1922:
1923:
1924: /* 2524562 End of bugfix */

Line 2085: WHEN FND_API.G_EXC_ERROR THEN

2081: WHEN NO_DATA_FOUND THEN -- Bugfix 2374246 Instead of handling no_calendar_date exception here
2082: xBillID := 0; -- the exception is placed directly with stmt # 43.
2083: return(-1); -- 2986192
2084:
2085: WHEN FND_API.G_EXC_ERROR THEN
2086: xErrorMessage := 'CTOCBOMB:create_bom_ml failed with expected error in stmt '||to_char(lStmtNum);
2087: --xMessageName := 'CTO_CREATE_BOM_ERROR';
2088:
2089: IF PG_DEBUG <> 0 THEN

Line 2120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2116: END IF;
2117:
2118: return(0);
2119:
2120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2121: xErrorMessage := 'CTOCBOMB:create_bom_ml failed with unexpected error in stmt '||to_char(lStmtNum);
2122: xMessageName := 'CTO_CREATE_BOM_ERROR';
2123: IF PG_DEBUG <> 0 THEN
2124: oe_debug_pub.add ('create_bom_ml: ' || 'create_item::unexp error::'||to_char(lStmtNum)||sqlerrm,1);

Line 2549: raise fnd_api.g_exc_error;

2545: --cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2546: cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2547:
2548:
2549: raise fnd_api.g_exc_error;
2550:
2551:
2552: end if;
2553:

Line 3592: l_return_status := FND_API.G_RET_STS_SUCCESS;

3588: l_return_status VARCHAR2(1);
3589:
3590: BEGIN
3591: i := 1;
3592: l_return_status := FND_API.G_RET_STS_SUCCESS;
3593:
3594: for rec in ctg
3595: loop
3596: l_catalog_dtls(i).cat_element_name := rec.element_name;

Line 3622: if( l_return_status = FND_API.G_RET_STS_ERROR ) then

3618: p_params => l_params,
3619: p_catalog_dtls => l_catalog_dtls,
3620: x_return_status => l_return_status);
3621:
3622: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
3623: IF PG_DEBUG <> 0 THEN
3624: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error');
3625: END IF;
3626: RAISE FND_API.G_EXC_ERROR ;

Line 3626: RAISE FND_API.G_EXC_ERROR ;

3622: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
3623: IF PG_DEBUG <> 0 THEN
3624: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error');
3625: END IF;
3626: RAISE FND_API.G_EXC_ERROR ;
3627:
3628: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
3629: IF PG_DEBUG <> 0 THEN
3630: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error');

Line 3628: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then

3624: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error');
3625: END IF;
3626: RAISE FND_API.G_EXC_ERROR ;
3627:
3628: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
3629: IF PG_DEBUG <> 0 THEN
3630: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error');
3631: END IF;
3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3628: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
3629: IF PG_DEBUG <> 0 THEN
3630: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error');
3631: END IF;
3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3633:
3634: end if ;
3635:
3636: if l_catalog_dtls.count <> original_count then

Line 3642: raise FND_API.G_EXC_ERROR;

3638: oe_debug_pub.add ('Custom hook did not return same number of elements.'||
3639: 'Original_count='||original_count||
3640: 'New count = '||l_catalog_dtls.count);
3641: END IF;
3642: raise FND_API.G_EXC_ERROR;
3643: end if;
3644:
3645: for k in l_catalog_dtls.first..l_catalog_dtls.last
3646: loop

Line 3772: raise FND_API.G_EXC_ERROR;

3768: oe_debug_pub.add('create_bom_data_ml: ' || 'bmlupid_update_item_desc returned ' || status,1 );
3769: END IF;
3770:
3771: if status <> 0 then
3772: raise FND_API.G_EXC_ERROR;
3773: end if;
3774:
3775: lStmtNum := 360;
3776: --

Line 3861: when FND_API.G_EXC_ERROR then

3857: END IF;
3858:
3859: return(0);
3860:
3861: when FND_API.G_EXC_ERROR then
3862: xErrorMessage:='CTOCBOMB:'||lStmtNum||':'||substrb(sqlerrm,1,150);
3863: xMessageName := 'CTO_CREATE_BOM_ERROR';
3864: IF PG_DEBUG <> 0 THEN
3865: oe_debug_pub.add('create_bom_data_ml: ' || 'eXpected Error: ' || xErrorMessage, 1);

Line 3891: when FND_API.G_EXC_UNEXPECTED_ERROR then -- bugfix 2765635

3887:
3888:
3889: return(0);
3890:
3891: when FND_API.G_EXC_UNEXPECTED_ERROR then -- bugfix 2765635
3892: xErrorMessage:='CTOCBOMB:'||lStmtNum||':'||substrb(sqlerrm,1,150);
3893: IF PG_DEBUG <> 0 THEN
3894: oe_debug_pub.add('Unexpected Error: ' || xErrorMessage);
3895: END IF;

Line 4408: raise fnd_api.g_exc_error;

4404: l_token1(1).token_value := v_model_item_name ;
4405:
4406: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP' , l_token1 );
4407:
4408: raise fnd_api.g_exc_error;
4409: end if ;
4410:
4411: /* begin Extend Effectivity Dates for Option Items with disable date */
4412:

Line 5141: raise fnd_api.g_exc_error;

5137: l_token2(1).token_value :=l_model_name;
5138: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR',l_token2);
5139: end loop ;
5140:
5141: raise fnd_api.g_exc_error;
5142: end if ;
5143: end if;
5144:
5145: /* end Check for Overlapping Effectivity Dates */

Line 5165: when FND_API.G_EXC_ERROR then

5161: oe_debug_pub.add ('inherit_op_seq_ml: ' || 'Error: No data found in inherit_op_seq_ml. Returning 0. Stmt:' || lStmtNumber, 1);
5162: END IF;
5163: return(0);
5164:
5165: when FND_API.G_EXC_ERROR then
5166: xErrorMessage:='CTOCBOMB:'||lStmtNumber||':'||substrb(sqlerrm,1,150);
5167: xMessageName := 'CTO_INHERIT_OP_SEQ_ERROR';
5168: IF PG_DEBUG <> 0 THEN
5169: oe_debug_pub.add('create_bom_data_ml: ' || 'Error: ' || xErrorMessage, 1);

Line 5173: when FND_API.G_EXC_UNEXPECTED_ERROR then -- bugfix 2765635

5169: oe_debug_pub.add('create_bom_data_ml: ' || 'Error: ' || xErrorMessage, 1);
5170: END IF;
5171: return(0);
5172:
5173: when FND_API.G_EXC_UNEXPECTED_ERROR then -- bugfix 2765635
5174: xErrorMessage:='CTOCBOMB:'||lStmtNumber||':'||substrb(sqlerrm,1,150);
5175: xMessageName := 'CTO_INHERIT_OP_SEQ_ERROR';
5176: IF PG_DEBUG <> 0 THEN
5177: oe_debug_pub.add('Error: ' || xErrorMessage);