DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on FND_API

Line 513: raise FND_API.G_EXC_ERROR;

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

Line 547: raise FND_API.G_EXC_ERROR;

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

Line 893: raise fnd_api.g_exc_error;

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

Line 1236: raise fnd_api.g_exc_error;

1232: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR',l_token2);
1233:
1234: end loop ;
1235:
1236: raise fnd_api.g_exc_error;
1237:
1238: end if ;
1239:
1240: end if;

Line 1429: raise fnd_api.g_exc_error;

1425: when others then
1426: IF PG_DEBUG <> 0 THEN
1427: oe_debug_pub.add('Others excepn from stmt '||lStmtNum ||':'||sqlerrm);
1428: END IF;
1429: raise fnd_api.g_exc_error;
1430: END ;
1431: end loop;
1432:
1433: /* gDropItem is set to 0 . Not resetting this to 1

Line 1546: raise fnd_api.g_exc_error;

1542: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1543:
1544:
1545:
1546: raise fnd_api.g_exc_error;
1547:
1548: end if;
1549:
1550: end if;

Line 1876: raise fnd_api.g_exc_error;

1872: cto_msg_pub.cto_message('BOM','CTO_MODEL_LINE_EXCPN_HOLD');
1873:
1874:
1875:
1876: raise fnd_api.g_exc_error;
1877:
1878: end if; /* create item profile condition */
1879:
1880: end if; /* missed lines cursor condition */

Line 1894: raise fnd_api.g_exc_error;

1890: when others then
1891: IF PG_DEBUG <> 0 THEN
1892: oe_debug_pub.add ('Failed in stmt ' || lStmtNum || ' with error: '||sqlerrm);
1893: END IF;
1894: raise fnd_api.g_exc_error;
1895: END ;
1896:
1897:
1898: /* 2524562 End of bugfix */

Line 2059: WHEN FND_API.G_EXC_ERROR THEN

2055: WHEN NO_DATA_FOUND THEN -- Bugfix 2374246 Instead of handling no_calendar_date exception here
2056: xBillID := 0; -- the exception is placed directly with stmt # 43.
2057: return(-1); -- 2986192
2058:
2059: WHEN FND_API.G_EXC_ERROR THEN
2060: xErrorMessage := 'CTOCBOMB:create_bom_ml failed with expected error in stmt '||to_char(lStmtNum);
2061: --xMessageName := 'CTO_CREATE_BOM_ERROR';
2062:
2063: IF PG_DEBUG <> 0 THEN

Line 2080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2076: END IF;
2077:
2078: return(0);
2079:
2080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2081: xErrorMessage := 'CTOCBOMB:create_bom_ml failed with unexpected error in stmt '||to_char(lStmtNum);
2082: xMessageName := 'CTO_CREATE_BOM_ERROR';
2083: IF PG_DEBUG <> 0 THEN
2084: oe_debug_pub.add ('create_bom_ml: ' || 'create_item::unexp error::'||to_char(lStmtNum)||sqlerrm,1);

Line 2489: raise fnd_api.g_exc_error;

2485: --cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2486: cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2487:
2488:
2489: raise fnd_api.g_exc_error;
2490:
2491:
2492: end if;
2493:

Line 3500: l_return_status := FND_API.G_RET_STS_SUCCESS;

3496: l_return_status VARCHAR2(1);
3497:
3498: BEGIN
3499: i := 1;
3500: l_return_status := FND_API.G_RET_STS_SUCCESS;
3501:
3502: for rec in ctg
3503: loop
3504: l_catalog_dtls(i).cat_element_name := rec.element_name;

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

3526: p_params => l_params,
3527: p_catalog_dtls => l_catalog_dtls,
3528: x_return_status => l_return_status);
3529:
3530: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
3531: IF PG_DEBUG <> 0 THEN
3532: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error');
3533: END IF;
3534: RAISE FND_API.G_EXC_ERROR ;

Line 3534: RAISE FND_API.G_EXC_ERROR ;

3530: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
3531: IF PG_DEBUG <> 0 THEN
3532: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error');
3533: END IF;
3534: RAISE FND_API.G_EXC_ERROR ;
3535:
3536: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
3537: IF PG_DEBUG <> 0 THEN
3538: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error');

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

3532: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error');
3533: END IF;
3534: RAISE FND_API.G_EXC_ERROR ;
3535:
3536: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
3537: IF PG_DEBUG <> 0 THEN
3538: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error');
3539: END IF;
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3536: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
3537: IF PG_DEBUG <> 0 THEN
3538: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error');
3539: END IF;
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3541:
3542: end if ;
3543:
3544: if l_catalog_dtls.count <> original_count then

Line 3550: raise FND_API.G_EXC_ERROR;

3546: oe_debug_pub.add ('Custom hook did not return same number of elements.'||
3547: 'Original_count='||original_count||
3548: 'New count = '||l_catalog_dtls.count);
3549: END IF;
3550: raise FND_API.G_EXC_ERROR;
3551: end if;
3552:
3553: for k in l_catalog_dtls.first..l_catalog_dtls.last
3554: loop

Line 3672: raise FND_API.G_EXC_ERROR;

3668: oe_debug_pub.add('create_bom_data_ml: ' || 'bmlupid_update_item_desc returned ' || status,1 );
3669: END IF;
3670:
3671: if status <> 0 then
3672: raise FND_API.G_EXC_ERROR;
3673: end if;
3674:
3675: lStmtNum := 360;
3676: select common_bill_sequence_id

Line 3724: when FND_API.G_EXC_ERROR then

3720: where bill_sequence_id = pConfigBillId;
3721:
3722: return(0);
3723:
3724: when FND_API.G_EXC_ERROR then
3725: xErrorMessage:='CTOCBOMB:'||lStmtNum||':'||substrb(sqlerrm,1,150);
3726: xMessageName := 'CTO_CREATE_BOM_ERROR';
3727: IF PG_DEBUG <> 0 THEN
3728: oe_debug_pub.add('create_bom_data_ml: ' || 'eXpected Error: ' || xErrorMessage, 1);

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

3736:
3737:
3738: return(0);
3739:
3740: when FND_API.G_EXC_UNEXPECTED_ERROR then -- bugfix 2765635
3741: xErrorMessage:='CTOCBOMB:'||lStmtNum||':'||substrb(sqlerrm,1,150);
3742: IF PG_DEBUG <> 0 THEN
3743: oe_debug_pub.add('Unexpected Error: ' || xErrorMessage);
3744: END IF;

Line 4236: raise fnd_api.g_exc_error;

4232:
4233:
4234: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP' , l_token1 );
4235:
4236: raise fnd_api.g_exc_error;
4237:
4238:
4239:
4240:

Line 4813: raise fnd_api.g_exc_error;

4809: l_token2(1).token_value :=l_model_name;
4810: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR',l_token2);
4811: end loop ;
4812:
4813: raise fnd_api.g_exc_error;
4814:
4815: end if ;
4816:
4817: end if;

Line 4853: when FND_API.G_EXC_ERROR then

4849: oe_debug_pub.add ('inherit_op_seq_ml: ' || 'Error: No data found in inherit_op_seq_ml. Returning 0 ', 1);
4850: END IF;
4851: return(0);
4852:
4853: when FND_API.G_EXC_ERROR then
4854: xErrorMessage:='CTOCBOMB:'||lStmtNumber||':'||substrb(sqlerrm,1,150);
4855: xMessageName := 'CTO_INHERIT_OP_SEQ_ERROR';
4856: IF PG_DEBUG <> 0 THEN
4857: oe_debug_pub.add('create_bom_data_ml: ' || 'Error: ' || xErrorMessage, 1);

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

4857: oe_debug_pub.add('create_bom_data_ml: ' || 'Error: ' || xErrorMessage, 1);
4858: END IF;
4859: return(0);
4860:
4861: when FND_API.G_EXC_UNEXPECTED_ERROR then -- bugfix 2765635
4862: xErrorMessage:='CTOCBOMB:'||lStmtNumber||':'||substrb(sqlerrm,1,150);
4863: xMessageName := 'CTO_INHERIT_OP_SEQ_ERROR';
4864: IF PG_DEBUG <> 0 THEN
4865: oe_debug_pub.add('Error: ' || xErrorMessage);