eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OE_CONFIG_TSO_PVT dependencies on FND_API

Line 192: RAISE FND_API.G_EXC_ERROR;

188: END IF;
189:
190: IF p_top_model_line_id = p_line_id THEN
191: IF p_inventory_item_id is NULL THEN
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194: ELSE
195:
196: SELECT inventory_item_id

Line 336: RAISE FND_API.G_EXC_ERROR;

332: IF l_debug_level > 0 THEN
333: OE_DEBUG_PUB.Add('No data found in Is_Part_of_Container_Model:'
334: ||sqlerrm, 3);
335: END IF;
336: RAISE FND_API.G_EXC_ERROR;
337:
338: WHEN TOO_MANY_ROWS THEN
339: IF l_debug_level > 0 THEN
340: OE_DEBUG_PUB.Add('Too Many Rows in Is_Part_of_Container_Model:'

Line 343: RAISE FND_API.G_EXC_ERROR;

339: IF l_debug_level > 0 THEN
340: OE_DEBUG_PUB.Add('Too Many Rows in Is_Part_of_Container_Model:'
341: ||sqlerrm, 3);
342: END IF;
343: RAISE FND_API.G_EXC_ERROR;
344:
345: WHEN OTHERS THEN
346: IF l_debug_level > 0 THEN
347: OE_DEBUG_PUB.Add('Other error in Is_Part_Of_Container_Model:'

Line 355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

351: OE_MSG_PUB.Add_Exc_Msg
352: ( G_PKG_NAME
353: ,'Is_Part_of_Container_Model' );
354: END IF;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356:
357:
358: END Is_Part_of_Container_Model;
359:

Line 395: x_return_status := FND_API.G_RET_STS_SUCCESS;

391: BEGIN
392:
393: Print_Time('Entering OE_CONFIG_TSO_PVT.Validate_Container_model...');
394:
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: IF l_debug_level > 0 THEN
398: OE_DEBUG_PUB.Add('Before Calling Is_Part_Of_Container_Model...',3);
399: END IF;

Line 418: x_return_status := FND_API.G_RET_STS_ERROR;

414: IF p_line_rec.ib_owner='INSTALL_BASE' THEN
415: IF l_debug_level > 0 THEN
416: OE_DEBUG_PUB.Add('IB validation failed: IB_OWNER',3);
417: END IF;
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
420: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_OWNER');
421: OE_MSG_PUB.Add;
422: END IF;

Line 428: x_return_status := FND_API.G_RET_STS_ERROR;

424: IF p_line_rec.ib_installed_at_location='INSTALL_BASE' THEN
425: IF l_debug_level > 0 THEN
426: OE_DEBUG_PUB.Add('IB validation failed: INSTALLED_AT_LOCATION',3);
427: END IF;
428: x_return_status := FND_API.G_RET_STS_ERROR;
429: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
430: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_INSTALLED_AT_LOCATION');
431: OE_MSG_PUB.Add;
432: END IF;

Line 438: x_return_status := FND_API.G_RET_STS_ERROR;

434: IF p_line_rec.ib_current_location='INSTALL_BASE' THEN
435: IF l_debug_level > 0 THEN
436: OE_DEBUG_PUB.Add('IB validation failed: IB_CURRENT_LOCATION',3);
437: END IF;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_CURRENT_LOCATION');
441: OE_MSG_PUB.Add;
442: END IF;

Line 474: IF l_x_return_status= FND_API.G_RET_STS_ERROR THEN

470: OE_DEBUG_PUB.ADD('l_config_mode='||l_config_mode);
471: END IF;
472:
473: -- Bug 3677344
474: IF l_x_return_status= FND_API.G_RET_STS_ERROR THEN
475: Raise FND_API.G_EXC_ERROR ;
476: ELSIF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
477: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;

Line 475: Raise FND_API.G_EXC_ERROR ;

471: END IF;
472:
473: -- Bug 3677344
474: IF l_x_return_status= FND_API.G_RET_STS_ERROR THEN
475: Raise FND_API.G_EXC_ERROR ;
476: ELSIF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
477: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479: -- Bug 3677344

Line 476: ELSIF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

472:
473: -- Bug 3677344
474: IF l_x_return_status= FND_API.G_RET_STS_ERROR THEN
475: Raise FND_API.G_EXC_ERROR ;
476: ELSIF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
477: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479: -- Bug 3677344
480: END IF;

Line 477: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

473: -- Bug 3677344
474: IF l_x_return_status= FND_API.G_RET_STS_ERROR THEN
475: Raise FND_API.G_EXC_ERROR ;
476: ELSIF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
477: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479: -- Bug 3677344
480: END IF;
481:

Line 488: x_return_status := FND_API.G_RET_STS_ERROR;

484: IF p_line_rec.ib_owner='INSTALL_BASE' THEN
485: IF l_debug_level > 0 THEN
486: OE_DEBUG_PUB.Add('IB validation failed: IB_OWNER');
487: END IF;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
490: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_OWNER'));
491: OE_MSG_PUB.Add;
492: END IF;

Line 498: x_return_status := FND_API.G_RET_STS_ERROR;

494: IF p_line_rec.ib_installed_at_location='INSTALL_BASE' THEN
495: IF l_debug_level > 0 THEN
496: OE_DEBUG_PUB.Add('IB validation failed: INSTALLED_AT_LOCATION',3);
497: END IF;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
500: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_INSTALLED_AT_LOCATION'));
501: OE_MSG_PUB.Add;
502: END IF;

Line 508: x_return_status := FND_API.G_RET_STS_ERROR;

504: IF p_line_rec.ib_current_location='INSTALL_BASE' THEN
505: IF l_debug_level > 0 THEN
506: OE_DEBUG_PUB.Add('IB validation failed: IB_CURRENT_LOCATION', 3);
507: END IF;
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
510: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_CURRENT_LOCATION'));
511: OE_MSG_PUB.Add;
512: END IF;

Line 552: x_return_status := FND_API.G_RET_STS_ERROR;

548: ELSE
549: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
550: Null;
551: ELSE
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: FND_MESSAGE.SET_NAME('ONT','ONT_TSO_BOOKED_ORDER');
554: OE_MSG_PUB.Add;
555: END IF;
556: IF l_debug_level > 0 THEN

Line 590: x_return_status := FND_API.G_RET_STS_ERROR;

586: IF l_debug_level > 0 THEN
587: OE_DEBUG_PUB.Add ('Item is IB trackable',3);
588: OE_DEBUG_PUB.Add('ERRM: IB trackable item Ordered Quantity must be 1 Only',3);
589: END IF;
590: x_return_status := FND_API.G_RET_STS_ERROR;
591: FND_MESSAGE.SET_NAME ('ONT','ONT_TSO_ORD_QTY_NOT_ONE');
592: OE_MSG_PUB.Add;
593: ELSE
594: IF l_debug_level > 0 THEN

Line 619: x_return_status := FND_API.G_RET_STS_ERROR;

615: ,p_old_line_rec.line_type_id)) AND
616: p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
617: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y' THEN
618:
619: x_return_status := FND_API.G_RET_STS_ERROR;
620:
621: FND_MESSAGE.SET_NAME ('ONT','ONT_TSO_NO_LINE_TYPE_CHANGE');
622: OE_MSG_PUB.Add;
623:

Line 673: x_return_status:=FND_API.G_RET_STS_ERROR;

669: l_delta := 0;
670: END;
671:
672: IF l_delta = 0 THEN
673: x_return_status:=FND_API.G_RET_STS_ERROR;
674: FND_MESSAGE.SET_NAME('ONT','ONT_TSO_DELETE_NOT_ALLOWED');
675: FND_MESSAGE.SET_TOKEN('ITEM_DESCRIPTION',l_description);
676: OE_MSG_PUB.Add;
677: IF l_debug_level > 0 THEN

Line 701: x_return_status := FND_API.G_RET_STS_ERROR;

697: IF NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id,
698: p_old_line_rec.sold_to_org_id) AND
699: p_line_rec.operation=OE_GLOBALS.G_OPR_UPDATE THEN
700:
701: x_return_status := FND_API.G_RET_STS_ERROR;
702:
703: FND_MESSAGE.SET_NAME('ONT','ONT_TSO_NO_CUSTOMER_CHANGE');
704: OE_MSG_PUB.Add;
705:

Line 713: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

709:
710: END IF;
711:
712: IF l_debug_level > 0 THEN
713: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
714: OE_DEBUG_PUB.Add('All validations for container model passed',3);
715: ELSE
716: OE_DEBUG_PUB.Add('ERR:Validations violation for container model',3);
717: END IF;

Line 724: WHEN FND_API.G_EXC_ERROR THEN

720: Print_Time('Exiting OE_CONFIG_TSO_PVT.Validate_Container_Model...');
721:
722: EXCEPTION
723:
724: WHEN FND_API.G_EXC_ERROR THEN
725: IF l_debug_level > 0 THEN
726: OE_DEBUG_PUB.Add('Expected Error in Validate_Container_Model:'
727: ||sqlerrm,3);
728: END IF;

Line 729: x_return_status := FND_API.G_RET_STS_ERROR;

725: IF l_debug_level > 0 THEN
726: OE_DEBUG_PUB.Add('Expected Error in Validate_Container_Model:'
727: ||sqlerrm,3);
728: END IF;
729: x_return_status := FND_API.G_RET_STS_ERROR;
730:
731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
732: IF l_debug_level > 0 THEN
733: OE_DEBUG_PUB.Add('Unexpected Error Validate_Container_Model:'

Line 731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

727: ||sqlerrm,3);
728: END IF;
729: x_return_status := FND_API.G_RET_STS_ERROR;
730:
731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
732: IF l_debug_level > 0 THEN
733: OE_DEBUG_PUB.Add('Unexpected Error Validate_Container_Model:'
734: ||sqlerrm,3);
735: END IF;

Line 736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

732: IF l_debug_level > 0 THEN
733: OE_DEBUG_PUB.Add('Unexpected Error Validate_Container_Model:'
734: ||sqlerrm,3);
735: END IF;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737:
738: WHEN OTHERS THEN
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: IF l_debug_level > 0 THEN

Line 739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

735: END IF;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737:
738: WHEN OTHERS THEN
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: IF l_debug_level > 0 THEN
741: OE_DEBUG_PUB.Add('Other error in Validate_Container_Model:'
742: ||sqlerrm,1);
743: END IF;

Line 955: x_return_status := FND_API.G_RET_STS_ERROR;

951:
952: IF l_debug_level > 0 THEN
953: OE_DEBUG_PUB.Add('ERR: At least one Config keys not present', 1);
954: END IF;
955: x_return_status := FND_API.G_RET_STS_ERROR;
956: x_config_mode := null;
957: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode');
958: RETURN;
959: --RAISE FND_API.G_EXC_ERROR;

Line 959: --RAISE FND_API.G_EXC_ERROR;

955: x_return_status := FND_API.G_RET_STS_ERROR;
956: x_config_mode := null;
957: Print_Time ('Exiting OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode');
958: RETURN;
959: --RAISE FND_API.G_EXC_ERROR;
960: END IF;
961:
962:
963: SELECT cz_hdr.baseline_rev_nbr

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038: ,'Get_MACD_Action_Mode' );
1039: END IF;
1040:
1041: x_config_mode := null;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: END Get_MACD_Action_Mode;
1044:
1045:
1046: -----------------------------------------------------------------------

Line 1124: x_return_status:=FND_API.G_RET_STS_ERROR;

1120: IF l_debug_level > 0 THEN
1121: OE_DEBUG_PUB.Add('Item not eligible for removal of unchanged lines',3);
1122: END IF;
1123:
1124: x_return_status:=FND_API.G_RET_STS_ERROR;
1125: x_msg_count := 1;
1126:
1127: SELECT description
1128: INTO l_description

Line 1177: IF x_return_status=FND_API.G_RET_STS_ERROR THEN

1173: OE_DEBUG_PUB.Add('After Calling CZ_NETWORK_API_PUB.'
1174: ||'Ext_Deactivate_Item:'||x_return_status,3);
1175: END IF;
1176:
1177: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
1178: RAISE FND_API.G_EXC_ERROR;
1179: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: END IF;

Line 1178: RAISE FND_API.G_EXC_ERROR;

1174: ||'Ext_Deactivate_Item:'||x_return_status,3);
1175: END IF;
1176:
1177: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
1178: RAISE FND_API.G_EXC_ERROR;
1179: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: END IF;
1182:

Line 1179: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN

1175: END IF;
1176:
1177: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
1178: RAISE FND_API.G_EXC_ERROR;
1179: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: END IF;
1182:
1183: END LOOP;

Line 1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1176:
1177: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
1178: RAISE FND_API.G_EXC_ERROR;
1179: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: END IF;
1182:
1183: END LOOP;
1184: CLOSE C_UNCHANGED_LINES;

Line 1226: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1222: OE_DEBUG_PUB.Add('After Calling Process_Config..'
1223: ||x_return_status,3);
1224: END IF;
1225:
1226: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;

Line 1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1223: ||x_return_status,3);
1224: END IF;
1225:
1226: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;
1231: ELSE

Line 1228: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1224: END IF;
1225:
1226: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;
1231: ELSE
1232: IF l_debug_level > 0 THEN

Line 1229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1225:
1226: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;
1231: ELSE
1232: IF l_debug_level > 0 THEN
1233: OE_DEBUG_PUB.Add ('Csr Count 0. Skip OE_CONFIG_PVT.Process_Config',1);

Line 1240: WHEN FND_API.G_EXC_ERROR THEN

1236: Print_Time('Exiting OE_CONFIG_TSO_PVT.Remove_Unchanged_Lines...');
1237:
1238: EXCEPTION
1239:
1240: WHEN FND_API.G_EXC_ERROR THEN
1241: IF l_debug_level > 0 THEN
1242: OE_DEBUG_PUB.Add('Expected Error in Remove_Unchanged_Lines:'
1243: ||sqlerrm, 2);
1244: END IF;

Line 1245: x_return_status := FND_API.G_RET_STS_ERROR;

1241: IF l_debug_level > 0 THEN
1242: OE_DEBUG_PUB.Add('Expected Error in Remove_Unchanged_Lines:'
1243: ||sqlerrm, 2);
1244: END IF;
1245: x_return_status := FND_API.G_RET_STS_ERROR;
1246:
1247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1248: IF l_debug_level > 0 THEN
1249: OE_DEBUG_PUB.Add('Unexpected Error in Remove_unchanged_Lines:'

Line 1247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1243: ||sqlerrm, 2);
1244: END IF;
1245: x_return_status := FND_API.G_RET_STS_ERROR;
1246:
1247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1248: IF l_debug_level > 0 THEN
1249: OE_DEBUG_PUB.Add('Unexpected Error in Remove_unchanged_Lines:'
1250: ||sqlerrm, 1);
1251: END IF;

Line 1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1248: IF l_debug_level > 0 THEN
1249: OE_DEBUG_PUB.Add('Unexpected Error in Remove_unchanged_Lines:'
1250: ||sqlerrm, 1);
1251: END IF;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253:
1254: WHEN OTHERS THEN
1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1256: IF l_debug_level > 0 THEN

Line 1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1251: END IF;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253:
1254: WHEN OTHERS THEN
1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1256: IF l_debug_level > 0 THEN
1257: OE_DEBUG_PUB.Add('Other error in Remove_Unchanged_Lines:'
1258: ||sqlerrm,1);
1259: END IF;

Line 1314: x_return_status := FND_API.G_RET_STS_SUCCESS;

1310:
1311: BEGIN
1312:
1313: Print_Time('Entering OE_CONFIG_TSO_PVT.Remove_Unchanged_Components...');
1314: x_return_status := FND_API.G_RET_STS_SUCCESS;
1315:
1316: --{ bug3611488 starts
1317: IF p_top_model_line_id IS NOT NULL THEN
1318:

Line 1335: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1331: ,x_msg_count => x_msg_count
1332: ,x_msg_data => x_msg_data
1333: ,x_return_status => x_return_status );
1334:
1335: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1336: IF l_debug_level > 0 THEN
1337: OE_DEBUG_PUB.Add ('Error in Remove_Unchanged_Lines!',3);
1338: END IF;
1339: END IF;

Line 1364: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1360: ,x_msg_count => x_msg_count
1361: ,x_msg_data => x_msg_data
1362: ,x_return_status => x_return_status );
1363:
1364: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1365: IF l_debug_level > 0 THEN
1366: OE_DEBUG_PUB.Add('ERROR during Remove_Unchanged_Lines!',3);
1367: END IF;
1368: END IF;

Line 1500: RAISE FND_API.G_EXC_ERROR;

1496: l_config_mode := 'R';
1497: ELSE
1498: FND_Message.Set_Name('ONT', 'ONT_CONFIG_USE_CZ_NOT_IB');
1499: OE_Msg_Pub.add;
1500: RAISE FND_API.G_EXC_ERROR;
1501: END IF;
1502: END;
1503: ELSE
1504: l_config_mode := 'R';

Line 1614: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1610: );
1611: OE_MSG_PUB.Transfer_Msg_Stack;
1612: Print_Time('After CZ_PUB.Generate_Config_Trees:'||x_return_status);
1613:
1614: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1615: IF l_debug_level >0 THEN
1616: OE_DEBUG_PUB.Add('Error in Generate_Config_Trees',2);
1617: END IF;
1618: RAISE FND_API.G_EXC_ERROR;

Line 1618: RAISE FND_API.G_EXC_ERROR;

1614: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1615: IF l_debug_level >0 THEN
1616: OE_DEBUG_PUB.Add('Error in Generate_Config_Trees',2);
1617: END IF;
1618: RAISE FND_API.G_EXC_ERROR;
1619: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1620: IF l_debug_level > 0 THEN
1621: OE_DEBUG_PUB.Add('Unexpected Error in Gen_Config_trees',1);
1622: END IF;

Line 1619: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1615: IF l_debug_level >0 THEN
1616: OE_DEBUG_PUB.Add('Error in Generate_Config_Trees',2);
1617: END IF;
1618: RAISE FND_API.G_EXC_ERROR;
1619: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1620: IF l_debug_level > 0 THEN
1621: OE_DEBUG_PUB.Add('Unexpected Error in Gen_Config_trees',1);
1622: END IF;
1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1619: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1620: IF l_debug_level > 0 THEN
1621: OE_DEBUG_PUB.Add('Unexpected Error in Gen_Config_trees',1);
1622: END IF;
1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1624: END IF;
1625:
1626: ---------now create model lines -----------------
1627:

Line 1686: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1682: OE_DEBUG_PUB.Add('After Calling Process Order:'
1683: ||x_return_status,3);
1684: END IF;
1685:
1686: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1687: IF l_debug_level > 0 THEN
1688: OE_DEBUG_PUB.Add('Error in Process Order.',2);
1689: END IF;
1690: RAISE FND_API.G_EXC_ERROR;

Line 1690: RAISE FND_API.G_EXC_ERROR;

1686: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1687: IF l_debug_level > 0 THEN
1688: OE_DEBUG_PUB.Add('Error in Process Order.',2);
1689: END IF;
1690: RAISE FND_API.G_EXC_ERROR;
1691: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1692: IF l_debug_level > 0 THEN
1693: OE_DEBUG_PUB.Add('Unexpected Error in Process order.',1);
1694: END IF;

Line 1691: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1687: IF l_debug_level > 0 THEN
1688: OE_DEBUG_PUB.Add('Error in Process Order.',2);
1689: END IF;
1690: RAISE FND_API.G_EXC_ERROR;
1691: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1692: IF l_debug_level > 0 THEN
1693: OE_DEBUG_PUB.Add('Unexpected Error in Process order.',1);
1694: END IF;
1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1691: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1692: IF l_debug_level > 0 THEN
1693: OE_DEBUG_PUB.Add('Unexpected Error in Process order.',1);
1694: END IF;
1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1696: END IF;
1697:
1698: ------------------now create child lines-------------------
1699: FOR I IN 1..l_line_tbl.count LOOP

Line 1735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1731: OE_DEBUG_PUB.Add('After Calling Process Config..'
1732: ||x_return_status,3);
1733: END IF;
1734:
1735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1736: IF l_debug_level >0 THEN
1737: OE_DEBUG_PUB.Add('Error in Process Config..',2);
1738: END IF;
1739: RAISE FND_API.G_EXC_ERROR;

Line 1739: RAISE FND_API.G_EXC_ERROR;

1735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1736: IF l_debug_level >0 THEN
1737: OE_DEBUG_PUB.Add('Error in Process Config..',2);
1738: END IF;
1739: RAISE FND_API.G_EXC_ERROR;
1740: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1741: IF l_debug_level > 0 THEN
1742: OE_DEBUG_PUB.Add('Unexpected Error in Process Config..',1);
1743: END IF;

Line 1740: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1736: IF l_debug_level >0 THEN
1737: OE_DEBUG_PUB.Add('Error in Process Config..',2);
1738: END IF;
1739: RAISE FND_API.G_EXC_ERROR;
1740: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1741: IF l_debug_level > 0 THEN
1742: OE_DEBUG_PUB.Add('Unexpected Error in Process Config..',1);
1743: END IF;
1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1740: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1741: IF l_debug_level > 0 THEN
1742: OE_DEBUG_PUB.Add('Unexpected Error in Process Config..',1);
1743: END IF;
1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1745: END IF;
1746:
1747: END LOOP;
1748: Print_Time ('Exiting OE_CONFIG_TSO_PVT.populate_tso_order_lines..');

Line 1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1771: WHEN OTHERS THEN
1772: IF l_debug_level > 0 THEN
1773: OE_DEBUG_PUB.Add('Error during select errmsg:'||sqlerrm,1);
1774: END IF;
1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1776:
1777: END;
1778:
1779: Print_Time('Before Calling CZ_PUB.Add_To_Config_Tree:');

Line 1800: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1796: );
1797:
1798: Print_Time('After CZ_PUB.Add_To_Config_Tree:'||x_return_status);
1799:
1800: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1801: IF l_debug_level > 0 THEN
1802: OE_DEBUG_PUB.Add ('Error in Add_to_config_tree',2);
1803: END IF;
1804: RAISE FND_API.G_EXC_ERROR;

Line 1804: RAISE FND_API.G_EXC_ERROR;

1800: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1801: IF l_debug_level > 0 THEN
1802: OE_DEBUG_PUB.Add ('Error in Add_to_config_tree',2);
1803: END IF;
1804: RAISE FND_API.G_EXC_ERROR;
1805: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1806: IF l_debug_level > 0 THEN
1807: OE_DEBUG_PUB.Add ('Unexpected Error in Add_to_config_tree',1);
1808: END IF;

Line 1805: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1801: IF l_debug_level > 0 THEN
1802: OE_DEBUG_PUB.Add ('Error in Add_to_config_tree',2);
1803: END IF;
1804: RAISE FND_API.G_EXC_ERROR;
1805: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1806: IF l_debug_level > 0 THEN
1807: OE_DEBUG_PUB.Add ('Unexpected Error in Add_to_config_tree',1);
1808: END IF;
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1805: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1806: IF l_debug_level > 0 THEN
1807: OE_DEBUG_PUB.Add ('Unexpected Error in Add_to_config_tree',1);
1808: END IF;
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: END IF;
1811:
1812: IF l_debug_level > 0 THEN
1813: OE_DEBUG_PUB.Add('HeaderID:'||l_config_model_rec.config_hdr_id,3);

Line 1837: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1833: IF l_debug_level > 0 THEN
1834: OE_DEBUG_PUB.Add('After Process_Config:'||x_return_status,3);
1835: END IF;
1836:
1837: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1838: IF l_debug_level > 0 THEN
1839: OE_DEBUG_PUB.Add('Error in Process_Config',2);
1840: END IF;
1841: RAISE FND_API.G_EXC_ERROR;

Line 1841: RAISE FND_API.G_EXC_ERROR;

1837: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1838: IF l_debug_level > 0 THEN
1839: OE_DEBUG_PUB.Add('Error in Process_Config',2);
1840: END IF;
1841: RAISE FND_API.G_EXC_ERROR;
1842: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1843: IF l_debug_level > 0 THEN
1844: OE_DEBUG_PUB.Add('Unexpected Error in Process_Config',1);
1845: END IF;

Line 1842: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1838: IF l_debug_level > 0 THEN
1839: OE_DEBUG_PUB.Add('Error in Process_Config',2);
1840: END IF;
1841: RAISE FND_API.G_EXC_ERROR;
1842: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1843: IF l_debug_level > 0 THEN
1844: OE_DEBUG_PUB.Add('Unexpected Error in Process_Config',1);
1845: END IF;
1846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1842: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1843: IF l_debug_level > 0 THEN
1844: OE_DEBUG_PUB.Add('Unexpected Error in Process_Config',1);
1845: END IF;
1846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1847: END IF;
1848:
1849: END IF; --if l_config_mode = a
1850:

Line 1859: WHEN FND_API.G_EXC_ERROR THEN

1855: Print_Time ('Exiting OE_CONFIG_TSO_PVT.populate_tso_order_lines...');
1856:
1857: EXCEPTION
1858:
1859: WHEN FND_API.G_EXC_ERROR THEN
1860: IF l_debug_level > 0 THEN
1861: OE_DEBUG_PUB.Add('Expected Error in populate_tso_order_lines:'
1862: ||sqlerrm, 2);
1863: END IF;

Line 1869: x_return_status := FND_API.G_RET_STS_ERROR;

1865: oe_debug_pub.add('RMV: 2 Msg count:'||x_msg_count);
1866: OE_MSG_PUB.Count_And_Get
1867: ( p_count => x_msg_count
1868: ,p_data => x_msg_data );
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870:
1871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1872: IF l_debug_level > 0 THEN
1873: OE_DEBUG_PUB.Add('Unexpected Error in populate_tso_order_lines'

Line 1871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1867: ( p_count => x_msg_count
1868: ,p_data => x_msg_data );
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870:
1871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1872: IF l_debug_level > 0 THEN
1873: OE_DEBUG_PUB.Add('Unexpected Error in populate_tso_order_lines'
1874: ||sqlerrm, 1);
1875: END IF;

Line 1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1881:
1882: OE_MSG_PUB.Count_And_Get
1883: ( p_count => x_msg_count
1884: ,p_data => x_msg_data );
1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1886:
1887: WHEN OTHERS THEN
1888:
1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1886:
1887: WHEN OTHERS THEN
1888:
1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1890: IF l_debug_level > 0 THEN
1891: oe_debug_pub.add('RMV: 4 Msg count: '|| sqlerrm );
1892: END IF;
1893:

Line 1958: x_return_status := FND_API.G_RET_STS_SUCCESS;

1954: oe_debug_pub.add('p_Extended_Attrib_Tbl : ' || p_Extended_Attrib_Tbl.count,2);
1955: END IF;
1956: -- All validations will be performed here.
1957:
1958: x_return_status := FND_API.G_RET_STS_SUCCESS;
1959:
1960: IF p_caller = 'P' THEN
1961:
1962: -- p_header_id and p_sold_to_org_id should be mutually exclusive. (Not required for the group call)

Line 1972: x_return_status := FND_API.G_RET_STS_ERROR;

1968: -- Set retun status and raise an error.
1969: -- Message should be seeded for this.
1970:
1971: FND_MESSAGE.Set_Name('ONT','ONT_TSO_HEAD_CUST_MISSING');
1972: x_return_status := FND_API.G_RET_STS_ERROR;
1973: oe_debug_pub.add('Unable to process since both header and customer is null',1);
1974: END IF;
1975:
1976: -- p_instance and p_x_line table should be exclusive. (not required for the group call)

Line 1989: x_return_status := FND_API.G_RET_STS_ERROR;

1985: -- If no data is passed, raise an error and set the return status.
1986:
1987: FND_MESSAGE.Set_Name('ONT','ONT_TSO_INS_ORD_MISSING');
1988: oe_debug_pub.add('Unable to process since both line and instance table are populated',1);
1989: x_return_status := FND_API.G_RET_STS_ERROR;
1990: END IF;
1991:
1992:
1993: -- All selected instances should belong to same sold_to

Line 2008: x_return_status := FND_API.G_RET_STS_ERROR;

2004: OR nvl(p_instance_tbl(I).action,p_macd_action) <> nvl(p_macd_action, p_instance_tbl(I).action)
2005: THEN
2006:
2007: FND_MESSAGE.Set_Name('ONT','ONT_TSO_INVALID_DATA_API_CALL');
2008: x_return_status := FND_API.G_RET_STS_ERROR;
2009: oe_debug_pub.add('Invalid Datea 2',3);
2010: -- Invalid data is passed, do not proceed further. Raise error.
2011: ELSE
2012:

Line 2026: x_return_status := FND_API.G_RET_STS_ERROR;

2022: END IF; -- action
2023: IF nvl(p_instance_tbl(1).action,p_macd_action) <> nvl(p_macd_action, p_instance_tbl(1).action) THEN
2024:
2025: FND_MESSAGE.Set_Name('ONT','ONT_TSO_INVALID_DATA_API_CALL');
2026: x_return_status := FND_API.G_RET_STS_ERROR;
2027: oe_debug_pub.add('Invalid Datea 3',3);
2028: Raise FND_API.G_EXC_ERROR;
2029: END IF;
2030:

Line 2028: Raise FND_API.G_EXC_ERROR;

2024:
2025: FND_MESSAGE.Set_Name('ONT','ONT_TSO_INVALID_DATA_API_CALL');
2026: x_return_status := FND_API.G_RET_STS_ERROR;
2027: oe_debug_pub.add('Invalid Datea 3',3);
2028: Raise FND_API.G_EXC_ERROR;
2029: END IF;
2030:
2031: End IF; -- count
2032:

Line 2042: x_return_status := FND_API.G_RET_STS_ERROR;

2038: IF nvl(p_x_line_tbl(I).operation,p_macd_action) <> nvl(p_macd_action, p_x_line_tbl(I).operation)
2039: THEN
2040: -- Invalid data is passed, do not proceed further. Raise error.
2041: FND_MESSAGE.Set_Name('ONT','ONT_TSO_INVALID_DATA_API_CALL');
2042: x_return_status := FND_API.G_RET_STS_ERROR;
2043: oe_debug_pub.add('Invalid Datea 4',3);
2044: Raise FND_API.G_EXC_ERROR;
2045: ELSE
2046:

Line 2044: Raise FND_API.G_EXC_ERROR;

2040: -- Invalid data is passed, do not proceed further. Raise error.
2041: FND_MESSAGE.Set_Name('ONT','ONT_TSO_INVALID_DATA_API_CALL');
2042: x_return_status := FND_API.G_RET_STS_ERROR;
2043: oe_debug_pub.add('Invalid Datea 4',3);
2044: Raise FND_API.G_EXC_ERROR;
2045: ELSE
2046:
2047: IF p_x_line_tbl(I).operation is not null then
2048: L_perform_action := TRUE;

Line 2058: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2054: End IF; -- Table count
2055: END IF; -- Public Validation.
2056:
2057:
2058: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2059: oe_debug_pub.add('Unable to process due to error',2);
2060: Raise FND_API.G_EXC_ERROR;
2061: END IF;
2062: IF l_debug_level > 0 THEN

Line 2060: Raise FND_API.G_EXC_ERROR;

2056:
2057:
2058: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2059: oe_debug_pub.add('Unable to process due to error',2);
2060: Raise FND_API.G_EXC_ERROR;
2061: END IF;
2062: IF l_debug_level > 0 THEN
2063: oe_debug_pub.add('Main Logic Starts from here',2);
2064: END IF;

Line 2085: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2081: IF l_debug_level > 0 THEN
2082: oe_debug_pub.add('After calling Create_header::' || p_x_header_id ||'::' || x_return_status,2);
2083: END IF;
2084:
2085: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2086: IF l_debug_level > 0 THEN
2087: oe_debug_pub.add('Unexpected error in creating Order Header for sold to: ' || p_sold_to_org_id,2);
2088: END IF;
2089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2085: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2086: IF l_debug_level > 0 THEN
2087: oe_debug_pub.add('Unexpected error in creating Order Header for sold to: ' || p_sold_to_org_id,2);
2088: END IF;
2089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2090: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2091: IF l_debug_level > 0 THEN
2092: oe_debug_pub.add('Expected error in creating Order Header for sold to: ' || p_sold_to_org_id,2);
2093: END IF;

Line 2090: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2086: IF l_debug_level > 0 THEN
2087: oe_debug_pub.add('Unexpected error in creating Order Header for sold to: ' || p_sold_to_org_id,2);
2088: END IF;
2089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2090: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2091: IF l_debug_level > 0 THEN
2092: oe_debug_pub.add('Expected error in creating Order Header for sold to: ' || p_sold_to_org_id,2);
2093: END IF;
2094: RAISE FND_API.G_EXC_ERROR;

Line 2094: RAISE FND_API.G_EXC_ERROR;

2090: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2091: IF l_debug_level > 0 THEN
2092: oe_debug_pub.add('Expected error in creating Order Header for sold to: ' || p_sold_to_org_id,2);
2093: END IF;
2094: RAISE FND_API.G_EXC_ERROR;
2095: END IF;
2096:
2097:
2098: -- The procedure populate_tso_order_lines will take care of creating model lines and child lines with the given instance table.

Line 2127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2123: IF l_debug_level > 0 THEN
2124: oe_debug_pub.add('After calling populate_tso_order_lines ' || x_return_status,2);
2125: END IF;
2126:
2127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2129: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2130: RAISE FND_API.G_EXC_ERROR;
2131: END IF;

Line 2128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2124: oe_debug_pub.add('After calling populate_tso_order_lines ' || x_return_status,2);
2125: END IF;
2126:
2127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2129: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2130: RAISE FND_API.G_EXC_ERROR;
2131: END IF;
2132: END IF;

Line 2129: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2125: END IF;
2126:
2127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2129: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2130: RAISE FND_API.G_EXC_ERROR;
2131: END IF;
2132: END IF;
2133:

Line 2130: RAISE FND_API.G_EXC_ERROR;

2126:
2127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2129: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2130: RAISE FND_API.G_EXC_ERROR;
2131: END IF;
2132: END IF;
2133:
2134: ELSIF p_x_header_id is not null THEN

Line 2166: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2162:
2163:
2164: END IF; -- Sold to org.
2165:
2166: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2168: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2169: RAISE FND_API.G_EXC_ERROR;
2170: END IF;

Line 2167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2163:
2164: END IF; -- Sold to org.
2165:
2166: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2168: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2169: RAISE FND_API.G_EXC_ERROR;
2170: END IF;
2171: -- We are done with TSO line creation logic. Processing logic follows.

Line 2168: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2164: END IF; -- Sold to org.
2165:
2166: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2168: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2169: RAISE FND_API.G_EXC_ERROR;
2170: END IF;
2171: -- We are done with TSO line creation logic. Processing logic follows.
2172: IF p_macd_action is not null

Line 2169: RAISE FND_API.G_EXC_ERROR;

2165:
2166: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2168: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2169: RAISE FND_API.G_EXC_ERROR;
2170: END IF;
2171: -- We are done with TSO line creation logic. Processing logic follows.
2172: IF p_macd_action is not null
2173: OR l_perform_action THEN

Line 2196: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2192:
2193: IF l_debug_level > 0 THEN
2194: oe_debug_pub.add('After calling Populate_MACD_action ' || x_return_status,2);
2195:
2196: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2198: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2199: RAISE FND_API.G_EXC_ERROR;
2200: END IF;

Line 2197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2193: IF l_debug_level > 0 THEN
2194: oe_debug_pub.add('After calling Populate_MACD_action ' || x_return_status,2);
2195:
2196: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2198: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2199: RAISE FND_API.G_EXC_ERROR;
2200: END IF;
2201: END IF; -- action

Line 2198: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2194: oe_debug_pub.add('After calling Populate_MACD_action ' || x_return_status,2);
2195:
2196: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2198: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2199: RAISE FND_API.G_EXC_ERROR;
2200: END IF;
2201: END IF; -- action
2202:

Line 2199: RAISE FND_API.G_EXC_ERROR;

2195:
2196: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2198: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2199: RAISE FND_API.G_EXC_ERROR;
2200: END IF;
2201: END IF; -- action
2202:
2203: END IF;

Line 2244: WHEN FND_API.G_EXC_ERROR THEN

2240: oe_debug_pub.add('Exiting oe_config_tso_pvt.Process_MACD_Order ' || x_return_status,1);
2241: END IF;
2242: EXCEPTION
2243:
2244: WHEN FND_API.G_EXC_ERROR THEN
2245: oe_msg_pub.count_and_get
2246: ( p_count => x_msg_count
2247: , p_data => x_msg_data);
2248:

Line 2253: x_return_status := FND_API.G_RET_STS_ERROR;

2249: IF l_debug_level > 0 THEN
2250: OE_DEBUG_PUB.Add('Expected Error in Process_MACD_Order:'
2251: ||sqlerrm,3);
2252: END IF;
2253: x_return_status := FND_API.G_RET_STS_ERROR;
2254:
2255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2256: oe_msg_pub.count_and_get
2257: ( p_count => x_msg_count

Line 2255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2251: ||sqlerrm,3);
2252: END IF;
2253: x_return_status := FND_API.G_RET_STS_ERROR;
2254:
2255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2256: oe_msg_pub.count_and_get
2257: ( p_count => x_msg_count
2258: , p_data => x_msg_data);
2259:

Line 2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2260: IF l_debug_level > 0 THEN
2261: OE_DEBUG_PUB.Add('Unexpected Error Process_MACD_Order:'
2262: ||sqlerrm,3);
2263: END IF;
2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265:
2266: WHEN OTHERS THEN
2267: oe_msg_pub.count_and_get
2268: ( p_count => x_msg_count

Line 2271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2267: oe_msg_pub.count_and_get
2268: ( p_count => x_msg_count
2269: , p_data => x_msg_data);
2270:
2271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2272: IF l_debug_level > 0 THEN
2273: OE_DEBUG_PUB.Add('Other error in Process_MACD_Order:'
2274: ||sqlerrm,1);
2275: END IF;

Line 2307: x_return_status := FND_API.G_RET_STS_SUCCESS;

2303:
2304: IF l_debug_level > 0 THEN
2305: oe_debug_pub.add( 'ENTERING OE_TSO_CONFIG_PVT.Create_Header' , 1 ) ;
2306: END IF;
2307: x_return_status := FND_API.G_RET_STS_SUCCESS;
2308:
2309: -- Use the default control record to call header procedure.
2310: -- Populate the header record with the input data and an operation.
2311:

Line 2324: ( p_validation_level =>FND_API.G_VALID_LEVEL_NONE

2320: -- Call Oe_Order_Pvt.Header
2321: -- Add debug messages.
2322:
2323: Oe_Order_Pvt.Header
2324: ( p_validation_level =>FND_API.G_VALID_LEVEL_NONE
2325: , p_init_msg_list => FND_API.G_TRUE
2326: , p_control_rec =>l_control_rec
2327: , p_x_header_rec =>l_header_rec
2328: , p_x_old_header_rec =>l_old_header_rec

Line 2325: , p_init_msg_list => FND_API.G_TRUE

2321: -- Add debug messages.
2322:
2323: Oe_Order_Pvt.Header
2324: ( p_validation_level =>FND_API.G_VALID_LEVEL_NONE
2325: , p_init_msg_list => FND_API.G_TRUE
2326: , p_control_rec =>l_control_rec
2327: , p_x_header_rec =>l_header_rec
2328: , p_x_old_header_rec =>l_old_header_rec
2329: , x_return_status =>x_return_status );

Line 2333: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2329: , x_return_status =>x_return_status );
2330:
2331: -- Handle the return status.
2332:
2333: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2335: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2336: RAISE FND_API.G_EXC_ERROR;
2337: END IF;

Line 2334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2330:
2331: -- Handle the return status.
2332:
2333: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2335: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2336: RAISE FND_API.G_EXC_ERROR;
2337: END IF;
2338:

Line 2335: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2331: -- Handle the return status.
2332:
2333: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2335: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2336: RAISE FND_API.G_EXC_ERROR;
2337: END IF;
2338:
2339: -- Load OUT parameters.

Line 2336: RAISE FND_API.G_EXC_ERROR;

2332:
2333: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2335: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2336: RAISE FND_API.G_EXC_ERROR;
2337: END IF;
2338:
2339: -- Load OUT parameters.
2340:

Line 2352: WHEN FND_API.G_EXC_ERROR THEN

2348: , p_data => x_msg_data);
2349:
2350: EXCEPTION
2351:
2352: WHEN FND_API.G_EXC_ERROR THEN
2353: IF l_debug_level > 0 THEN
2354: OE_DEBUG_PUB.Add('Expected Error in Create_Header:'
2355: ||sqlerrm,3);
2356: END IF;

Line 2357: x_return_status := FND_API.G_RET_STS_ERROR;

2353: IF l_debug_level > 0 THEN
2354: OE_DEBUG_PUB.Add('Expected Error in Create_Header:'
2355: ||sqlerrm,3);
2356: END IF;
2357: x_return_status := FND_API.G_RET_STS_ERROR;
2358:
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2360: IF l_debug_level > 0 THEN
2361: OE_DEBUG_PUB.Add('Unexpected Error Create_Header:'

Line 2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2355: ||sqlerrm,3);
2356: END IF;
2357: x_return_status := FND_API.G_RET_STS_ERROR;
2358:
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2360: IF l_debug_level > 0 THEN
2361: OE_DEBUG_PUB.Add('Unexpected Error Create_Header:'
2362: ||sqlerrm,3);
2363: END IF;

Line 2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2360: IF l_debug_level > 0 THEN
2361: OE_DEBUG_PUB.Add('Unexpected Error Create_Header:'
2362: ||sqlerrm,3);
2363: END IF;
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365:
2366: WHEN OTHERS THEN
2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2368: IF l_debug_level > 0 THEN

Line 2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2363: END IF;
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365:
2366: WHEN OTHERS THEN
2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2368: IF l_debug_level > 0 THEN
2369: OE_DEBUG_PUB.Add('Other error in Create_Header:'
2370: ||sqlerrm,1);
2371: END IF;

Line 2481: IF x_return_status=FND_API.G_RET_STS_ERROR THEN

2477: x_msg_data => x_msg_data,
2478: x_return_status => x_return_status);
2479:
2480: -- Handle the return status from the call. Raise an exception accordingly.
2481: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
2482: RAISE FND_API.G_EXC_ERROR;
2483: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
2484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2485: END IF;

Line 2482: RAISE FND_API.G_EXC_ERROR;

2478: x_return_status => x_return_status);
2479:
2480: -- Handle the return status from the call. Raise an exception accordingly.
2481: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
2482: RAISE FND_API.G_EXC_ERROR;
2483: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
2484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2485: END IF;
2486:

Line 2483: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN

2479:
2480: -- Handle the return status from the call. Raise an exception accordingly.
2481: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
2482: RAISE FND_API.G_EXC_ERROR;
2483: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
2484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2485: END IF;
2486:
2487: -- Delete the parent table and also clear the top model so that we do not carry the value.

Line 2484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2480: -- Handle the return status from the call. Raise an exception accordingly.
2481: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
2482: RAISE FND_API.G_EXC_ERROR;
2483: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
2484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2485: END IF;
2486:
2487: -- Delete the parent table and also clear the top model so that we do not carry the value.
2488:

Line 2525: IF x_return_status=FND_API.G_RET_STS_ERROR THEN

2521: x_msg_count =>x_msg_count,
2522: x_msg_data => x_msg_data,
2523: x_return_status => x_return_status);
2524: -- Handle the return status from the call. Raise an exception accordingly.
2525: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
2526: RAISE FND_API.G_EXC_ERROR;
2527: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
2528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2529: END IF;

Line 2526: RAISE FND_API.G_EXC_ERROR;

2522: x_msg_data => x_msg_data,
2523: x_return_status => x_return_status);
2524: -- Handle the return status from the call. Raise an exception accordingly.
2525: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
2526: RAISE FND_API.G_EXC_ERROR;
2527: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
2528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2529: END IF;
2530:

Line 2527: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN

2523: x_return_status => x_return_status);
2524: -- Handle the return status from the call. Raise an exception accordingly.
2525: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
2526: RAISE FND_API.G_EXC_ERROR;
2527: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
2528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2529: END IF;
2530:
2531: l_no_parent_instance_tbl.delete;

Line 2528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2524: -- Handle the return status from the call. Raise an exception accordingly.
2525: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
2526: RAISE FND_API.G_EXC_ERROR;
2527: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN
2528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2529: END IF;
2530:
2531: l_no_parent_instance_tbl.delete;
2532:

Line 2544: WHEN FND_API.G_EXC_ERROR THEN

2540: );
2541:
2542: EXCEPTION
2543:
2544: WHEN FND_API.G_EXC_ERROR THEN
2545: IF l_debug_level > 0 THEN
2546: OE_DEBUG_PUB.Add('Expected Error in Create_TSO_Order_Lines:'
2547: ||sqlerrm,3);
2548: END IF;

Line 2549: x_return_status := FND_API.G_RET_STS_ERROR;

2545: IF l_debug_level > 0 THEN
2546: OE_DEBUG_PUB.Add('Expected Error in Create_TSO_Order_Lines:'
2547: ||sqlerrm,3);
2548: END IF;
2549: x_return_status := FND_API.G_RET_STS_ERROR;
2550:
2551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2552: IF l_debug_level > 0 THEN
2553: OE_DEBUG_PUB.Add('Unexpected Error Create_TSO_Order_Lines:'

Line 2551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2547: ||sqlerrm,3);
2548: END IF;
2549: x_return_status := FND_API.G_RET_STS_ERROR;
2550:
2551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2552: IF l_debug_level > 0 THEN
2553: OE_DEBUG_PUB.Add('Unexpected Error Create_TSO_Order_Lines:'
2554: ||sqlerrm,3);
2555: END IF;

Line 2556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2552: IF l_debug_level > 0 THEN
2553: OE_DEBUG_PUB.Add('Unexpected Error Create_TSO_Order_Lines:'
2554: ||sqlerrm,3);
2555: END IF;
2556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2557:
2558: WHEN OTHERS THEN
2559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2560: IF l_debug_level > 0 THEN

Line 2559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2555: END IF;
2556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2557:
2558: WHEN OTHERS THEN
2559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2560: IF l_debug_level > 0 THEN
2561: OE_DEBUG_PUB.Add('Other error in Create_TSO_Order_Lines:'
2562: ||sqlerrm,1);
2563: END IF;

Line 2630: x_return_status := FND_API.G_RET_STS_SUCCESS;

2626: --for all records returned by IB, we remember this and pass the
2627: --G_CONFIG_INTSTANCE_TBL to Process_Config to improve performance
2628:
2629: oe_debug_pub.add('Entering Populate_macd_action procedure',1);
2630: x_return_status := FND_API.G_RET_STS_SUCCESS;
2631: IF p_instance_tbl.count > 0 THEN
2632:
2633: l_instance_tbl := p_instance_tbl;
2634: I := l_instance_tbl.FIRST;

Line 2673: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2669: x_component_code => l_component_code,
2670: x_return_status => x_return_status);
2671:
2672: oe_debug_pub.add('After Validate Action' || x_return_status,2);
2673: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2675: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2676: RAISE FND_API.G_EXC_ERROR;
2677: END IF;

Line 2674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2670: x_return_status => x_return_status);
2671:
2672: oe_debug_pub.add('After Validate Action' || x_return_status,2);
2673: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2675: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2676: RAISE FND_API.G_EXC_ERROR;
2677: END IF;
2678: l_config_item_rec.config_item_id := l_config_item_id;

Line 2675: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2671:
2672: oe_debug_pub.add('After Validate Action' || x_return_status,2);
2673: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2675: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2676: RAISE FND_API.G_EXC_ERROR;
2677: END IF;
2678: l_config_item_rec.config_item_id := l_config_item_id;
2679: l_config_item_rec.component_code := l_component_code;

Line 2676: RAISE FND_API.G_EXC_ERROR;

2672: oe_debug_pub.add('After Validate Action' || x_return_status,2);
2673: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2675: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2676: RAISE FND_API.G_EXC_ERROR;
2677: END IF;
2678: l_config_item_rec.config_item_id := l_config_item_id;
2679: l_config_item_rec.component_code := l_component_code;
2680:

Line 2728: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2724: x_component_code => l_component_code,
2725: x_return_status => x_return_status);
2726:
2727: oe_debug_pub.add(' 1 After Validate Action' || x_return_status,2);
2728: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2730: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2731: RAISE FND_API.G_EXC_ERROR;
2732: END IF;

Line 2729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2725: x_return_status => x_return_status);
2726:
2727: oe_debug_pub.add(' 1 After Validate Action' || x_return_status,2);
2728: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2730: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2731: RAISE FND_API.G_EXC_ERROR;
2732: END IF;
2733: l_config_item_rec.config_item_id := l_config_item_id;

Line 2730: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2726:
2727: oe_debug_pub.add(' 1 After Validate Action' || x_return_status,2);
2728: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2730: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2731: RAISE FND_API.G_EXC_ERROR;
2732: END IF;
2733: l_config_item_rec.config_item_id := l_config_item_id;
2734: l_config_item_rec.component_code := l_component_code;

Line 2731: RAISE FND_API.G_EXC_ERROR;

2727: oe_debug_pub.add(' 1 After Validate Action' || x_return_status,2);
2728: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2730: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2731: RAISE FND_API.G_EXC_ERROR;
2732: END IF;
2733: l_config_item_rec.config_item_id := l_config_item_id;
2734: l_config_item_rec.component_code := l_component_code;
2735:

Line 2799: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2795: OE_MSG_PUB.Transfer_Msg_Stack;
2796: oe_debug_pub.add('After calling CZ_CF_API.VALIDATE: ' || x_return_status,2);
2797: oe_debug_pub.add('x_msg_data: ' || x_msg_data,2);
2798:
2799: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2801: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2802: RAISE FND_API.G_EXC_ERROR;
2803: END IF;

Line 2800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2796: oe_debug_pub.add('After calling CZ_CF_API.VALIDATE: ' || x_return_status,2);
2797: oe_debug_pub.add('x_msg_data: ' || x_msg_data,2);
2798:
2799: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2801: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2802: RAISE FND_API.G_EXC_ERROR;
2803: END IF;
2804: -- Handle the return status from the call. Raise an exception accordingly.

Line 2801: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2797: oe_debug_pub.add('x_msg_data: ' || x_msg_data,2);
2798:
2799: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2801: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2802: RAISE FND_API.G_EXC_ERROR;
2803: END IF;
2804: -- Handle the return status from the call. Raise an exception accordingly.
2805:

Line 2802: RAISE FND_API.G_EXC_ERROR;

2798:
2799: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2801: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2802: RAISE FND_API.G_EXC_ERROR;
2803: END IF;
2804: -- Handle the return status from the call. Raise an exception accordingly.
2805:
2806: -- extract data from xml message.

Line 2837: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2833: IF l_debug_level > 0 THEN
2834: oe_debug_pub.add('AFTER CALLING PARSE_XML: '||x_RETURN_STATUS , 2 );
2835: END IF;
2836:
2837: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2839: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2840: RAISE FND_API.G_EXC_ERROR;
2841: END IF;

Line 2838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2834: oe_debug_pub.add('AFTER CALLING PARSE_XML: '||x_RETURN_STATUS , 2 );
2835: END IF;
2836:
2837: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2839: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2840: RAISE FND_API.G_EXC_ERROR;
2841: END IF;
2842: -- Need to call the process_config api to synch up the order linesto onfiguration changes resulted due to the batch validation call.

Line 2839: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2835: END IF;
2836:
2837: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2839: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2840: RAISE FND_API.G_EXC_ERROR;
2841: END IF;
2842: -- Need to call the process_config api to synch up the order linesto onfiguration changes resulted due to the batch validation call.
2843: /*

Line 2840: RAISE FND_API.G_EXC_ERROR;

2836:
2837: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2839: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2840: RAISE FND_API.G_EXC_ERROR;
2841: END IF;
2842: -- Need to call the process_config api to synch up the order linesto onfiguration changes resulted due to the batch validation call.
2843: /*
2844: Begin

Line 2854: RAISE FND_API.G_EXC_ERROR;

2850:
2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: oe_debug_pub.add(' Line SELECT: '|| SQLERRM , 1 ) ;
2854: RAISE FND_API.G_EXC_ERROR;
2855: -- Exception handler
2856:
2857: End;
2858: */

Line 2872: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2868: ,x_msg_data => x_msg_data
2869: ,x_return_status => x_return_status);
2870:
2871: oe_debug_pub.add('After calling Process Config: ' || x_return_status,2);
2872: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2874: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2875: RAISE FND_API.G_EXC_ERROR;
2876: END IF;

Line 2873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2869: ,x_return_status => x_return_status);
2870:
2871: oe_debug_pub.add('After calling Process Config: ' || x_return_status,2);
2872: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2874: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2875: RAISE FND_API.G_EXC_ERROR;
2876: END IF;
2877: -- Delete the parent table and also clear the top model so that we do not carry the value.

Line 2874: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2870:
2871: oe_debug_pub.add('After calling Process Config: ' || x_return_status,2);
2872: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2874: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2875: RAISE FND_API.G_EXC_ERROR;
2876: END IF;
2877: -- Delete the parent table and also clear the top model so that we do not carry the value.
2878:

Line 2875: RAISE FND_API.G_EXC_ERROR;

2871: oe_debug_pub.add('After calling Process Config: ' || x_return_status,2);
2872: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2874: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2875: RAISE FND_API.G_EXC_ERROR;
2876: END IF;
2877: -- Delete the parent table and also clear the top model so that we do not carry the value.
2878:
2879: l_top_model_line_Id := null;

Line 2974: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2970:
2971:
2972: -- Handle the exception of the process order here. If there were no exception then process the macd action.
2973:
2974: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2976: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2977: RAISE FND_API.G_EXC_ERROR;
2978: END IF;

Line 2975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2971:
2972: -- Handle the exception of the process order here. If there were no exception then process the macd action.
2973:
2974: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2976: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2977: RAISE FND_API.G_EXC_ERROR;
2978: END IF;
2979:

Line 2976: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2972: -- Handle the exception of the process order here. If there were no exception then process the macd action.
2973:
2974: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2976: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2977: RAISE FND_API.G_EXC_ERROR;
2978: END IF;
2979:
2980: I := l_line_tbl.FIRST;

Line 2977: RAISE FND_API.G_EXC_ERROR;

2973:
2974: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2976: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2977: RAISE FND_API.G_EXC_ERROR;
2978: END IF;
2979:
2980: I := l_line_tbl.FIRST;
2981:

Line 3015: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3011: P_macd_action => nvl(p_macd_action, l_line_tbl(I).operation),
3012: X_return_status => x_return_status);
3013:
3014: oe_debug_pub.add('3 After calling Validate_line_action' || x_return_status,2);
3015: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3017: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3018: RAISE FND_API.G_EXC_ERROR;
3019: END IF;

Line 3016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3012: X_return_status => x_return_status);
3013:
3014: oe_debug_pub.add('3 After calling Validate_line_action' || x_return_status,2);
3015: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3017: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3018: RAISE FND_API.G_EXC_ERROR;
3019: END IF;
3020: -- Handle exceptions.

Line 3017: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3013:
3014: oe_debug_pub.add('3 After calling Validate_line_action' || x_return_status,2);
3015: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3017: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3018: RAISE FND_API.G_EXC_ERROR;
3019: END IF;
3020: -- Handle exceptions.
3021:

Line 3018: RAISE FND_API.G_EXC_ERROR;

3014: oe_debug_pub.add('3 After calling Validate_line_action' || x_return_status,2);
3015: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3017: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3018: RAISE FND_API.G_EXC_ERROR;
3019: END IF;
3020: -- Handle exceptions.
3021:
3022: l_config_item_rec.config_item_id := l_line_tbl(I).configuration_id;

Line 3068: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3064: p_config_item_id => l_line_tbl(j).configuration_id,
3065: p_macd_action => nvl(p_macd_action,l_line_tbl(j).operation),
3066: x_return_status => x_return_status);
3067: oe_debug_pub.add('4 After calling Validate_line_action' || x_return_status,2);
3068: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3070: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3071: RAISE FND_API.G_EXC_ERROR;
3072: END IF;

Line 3069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3065: p_macd_action => nvl(p_macd_action,l_line_tbl(j).operation),
3066: x_return_status => x_return_status);
3067: oe_debug_pub.add('4 After calling Validate_line_action' || x_return_status,2);
3068: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3070: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3071: RAISE FND_API.G_EXC_ERROR;
3072: END IF;
3073:

Line 3070: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3066: x_return_status => x_return_status);
3067: oe_debug_pub.add('4 After calling Validate_line_action' || x_return_status,2);
3068: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3070: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3071: RAISE FND_API.G_EXC_ERROR;
3072: END IF;
3073:
3074: l_config_item_rec.config_item_id := l_line_tbl(j).configuration_id;

Line 3071: RAISE FND_API.G_EXC_ERROR;

3067: oe_debug_pub.add('4 After calling Validate_line_action' || x_return_status,2);
3068: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3070: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3071: RAISE FND_API.G_EXC_ERROR;
3072: END IF;
3073:
3074: l_config_item_rec.config_item_id := l_line_tbl(j).configuration_id;
3075: l_config_item_rec.component_code := L_line_tbl(J).component_code;

Line 3130: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3126: ,x_msg_count => x_msg_count
3127: ,x_msg_data => x_msg_data);
3128:
3129: oe_debug_pub.add('2 After calling CZ_CF_API.VALIDATE' || x_return_status,2);
3130: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3132: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3133: RAISE FND_API.G_EXC_ERROR;
3134: END IF;

Line 3131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3127: ,x_msg_data => x_msg_data);
3128:
3129: oe_debug_pub.add('2 After calling CZ_CF_API.VALIDATE' || x_return_status,2);
3130: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3132: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3133: RAISE FND_API.G_EXC_ERROR;
3134: END IF;
3135: -- Handle the return status from the call. Raise an exception accordingly.

Line 3132: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3128:
3129: oe_debug_pub.add('2 After calling CZ_CF_API.VALIDATE' || x_return_status,2);
3130: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3132: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3133: RAISE FND_API.G_EXC_ERROR;
3134: END IF;
3135: -- Handle the return status from the call. Raise an exception accordingly.
3136:

Line 3133: RAISE FND_API.G_EXC_ERROR;

3129: oe_debug_pub.add('2 After calling CZ_CF_API.VALIDATE' || x_return_status,2);
3130: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3132: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3133: RAISE FND_API.G_EXC_ERROR;
3134: END IF;
3135: -- Handle the return status from the call. Raise an exception accordingly.
3136:
3137: IF (l_config_xml_msg.COUNT > 0) THEN

Line 3156: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3152: x_return_status => x_return_status );
3153:
3154: END IF;
3155:
3156: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3158: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3159: RAISE FND_API.G_EXC_ERROR;
3160: END IF;

Line 3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3153:
3154: END IF;
3155:
3156: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3158: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3159: RAISE FND_API.G_EXC_ERROR;
3160: END IF;
3161: -- Need to call the process_config api to synch up the order lines to onfiguration changes

Line 3158: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3154: END IF;
3155:
3156: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3158: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3159: RAISE FND_API.G_EXC_ERROR;
3160: END IF;
3161: -- Need to call the process_config api to synch up the order lines to onfiguration changes
3162: -- resulted due to the batch validation call.

Line 3159: RAISE FND_API.G_EXC_ERROR;

3155:
3156: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3158: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3159: RAISE FND_API.G_EXC_ERROR;
3160: END IF;
3161: -- Need to call the process_config api to synch up the order lines to onfiguration changes
3162: -- resulted due to the batch validation call.
3163: /*

Line 3191: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3187:
3188: oe_debug_pub.add('After calling Process Config ' || x_return_status,2);
3189:
3190: -- Delete the parent table and also clear the top model so that we do not carry the value.
3191: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3193: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3194: RAISE FND_API.G_EXC_ERROR;
3195: END IF;

Line 3192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3188: oe_debug_pub.add('After calling Process Config ' || x_return_status,2);
3189:
3190: -- Delete the parent table and also clear the top model so that we do not carry the value.
3191: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3193: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3194: RAISE FND_API.G_EXC_ERROR;
3195: END IF;
3196:

Line 3193: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3189:
3190: -- Delete the parent table and also clear the top model so that we do not carry the value.
3191: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3193: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3194: RAISE FND_API.G_EXC_ERROR;
3195: END IF;
3196:
3197: l_top_model_line_Id := null;

Line 3194: RAISE FND_API.G_EXC_ERROR;

3190: -- Delete the parent table and also clear the top model so that we do not carry the value.
3191: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3193: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3194: RAISE FND_API.G_EXC_ERROR;
3195: END IF;
3196:
3197: l_top_model_line_Id := null;
3198: l_parent_exists_instance_tbl.delete;

Line 3215: WHEN FND_API.G_EXC_ERROR THEN

3211: , p_data => x_msg_data
3212: );
3213: Oe_debug_pub.add('Before exiting populate macd action : ' || x_return_status,1);
3214: Exception
3215: WHEN FND_API.G_EXC_ERROR THEN
3216: IF l_debug_level > 0 THEN
3217: OE_DEBUG_PUB.Add('Expected Error in Populate_macd_action:'
3218: ||sqlerrm,3);
3219: END IF;

Line 3220: x_return_status := FND_API.G_RET_STS_ERROR;

3216: IF l_debug_level > 0 THEN
3217: OE_DEBUG_PUB.Add('Expected Error in Populate_macd_action:'
3218: ||sqlerrm,3);
3219: END IF;
3220: x_return_status := FND_API.G_RET_STS_ERROR;
3221:
3222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3223: IF l_debug_level > 0 THEN
3224: OE_DEBUG_PUB.Add('Unexpected Error Populate_macd_action:'

Line 3222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3218: ||sqlerrm,3);
3219: END IF;
3220: x_return_status := FND_API.G_RET_STS_ERROR;
3221:
3222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3223: IF l_debug_level > 0 THEN
3224: OE_DEBUG_PUB.Add('Unexpected Error Populate_macd_action:'
3225: ||sqlerrm,3);
3226: END IF;

Line 3227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3223: IF l_debug_level > 0 THEN
3224: OE_DEBUG_PUB.Add('Unexpected Error Populate_macd_action:'
3225: ||sqlerrm,3);
3226: END IF;
3227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3228:
3229: WHEN OTHERS THEN
3230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3231: IF l_debug_level > 0 THEN

Line 3230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3226: END IF;
3227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3228:
3229: WHEN OTHERS THEN
3230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3231: IF l_debug_level > 0 THEN
3232: OE_DEBUG_PUB.Add('Other error in Populate_macd_action:'
3233: ||sqlerrm,1);
3234: END IF;

Line 3318: WHEN FND_API.G_EXC_ERROR THEN

3314: End;
3315: END IF;
3316: oe_debug_pub.add('Exiting IS_Container_Present: ' || x_top_model_line_id,2);
3317: Exception
3318: WHEN FND_API.G_EXC_ERROR THEN
3319: IF l_debug_level > 0 THEN
3320: OE_DEBUG_PUB.Add('Expected Error in IS_Container_Present::'
3321: ||sqlerrm,3);
3322: END IF;

Line 3324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3320: OE_DEBUG_PUB.Add('Expected Error in IS_Container_Present::'
3321: ||sqlerrm,3);
3322: END IF;
3323:
3324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3325: IF l_debug_level > 0 THEN
3326: OE_DEBUG_PUB.Add('Unexpected Error IS_Container_Present::'
3327: ||sqlerrm,3);
3328: END IF;

Line 3367: x_return_status := FND_API.G_RET_STS_SUCCESS;

3363: -- This is because CZ will not support REVERT action in this phase.
3364:
3365: oe_debug_pub.add('Entering validate action: ' || p_macd_action,2);
3366:
3367: x_return_status := FND_API.G_RET_STS_SUCCESS;
3368:
3369:
3370: IF p_macd_action in ('DELETE', 'DISCONTINUE') then
3371:

Line 3394: RAISE FND_API.G_EXC_ERROR;

3390:
3391: IF l_baseline_rev_nbr > 0 AND
3392: p_macd_action = 'DELETE' THEN
3393: oe_debug_pub.add('Before raising error',2);
3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;
3396:
3397: Exception
3398: WHEN NO_DATA_FOUND THEN

Line 3401: RAISE FND_API.G_EXC_ERROR;

3397: Exception
3398: WHEN NO_DATA_FOUND THEN
3399: IF p_macd_action = 'DISCONTINUE' THEN
3400: oe_debug_pub.add('Before raising error no data found',2);
3401: RAISE FND_API.G_EXC_ERROR;
3402: END IF;
3403: End;
3404:
3405: End if;

Line 3423: WHEN FND_API.G_EXC_ERROR THEN

3419: END;
3420: oe_debug_pub.add('component_code ' || x_component_code,1);
3421: oe_debug_pub.add('Before exiting Validate action' || x_return_status,1);
3422: Exception
3423: WHEN FND_API.G_EXC_ERROR THEN
3424: IF l_debug_level > 0 THEN
3425: OE_DEBUG_PUB.Add('Expected Error in validate_action:'
3426: ||sqlerrm,3);
3427: END IF;

Line 3428: x_return_status := FND_API.G_RET_STS_ERROR;

3424: IF l_debug_level > 0 THEN
3425: OE_DEBUG_PUB.Add('Expected Error in validate_action:'
3426: ||sqlerrm,3);
3427: END IF;
3428: x_return_status := FND_API.G_RET_STS_ERROR;
3429:
3430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3431: IF l_debug_level > 0 THEN
3432: OE_DEBUG_PUB.Add('Unexpected Error validate_action:'

Line 3430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3426: ||sqlerrm,3);
3427: END IF;
3428: x_return_status := FND_API.G_RET_STS_ERROR;
3429:
3430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3431: IF l_debug_level > 0 THEN
3432: OE_DEBUG_PUB.Add('Unexpected Error validate_action:'
3433: ||sqlerrm,3);
3434: END IF;

Line 3435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3431: IF l_debug_level > 0 THEN
3432: OE_DEBUG_PUB.Add('Unexpected Error validate_action:'
3433: ||sqlerrm,3);
3434: END IF;
3435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3436:
3437: WHEN OTHERS THEN
3438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3439: IF l_debug_level > 0 THEN

Line 3438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3434: END IF;
3435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3436:
3437: WHEN OTHERS THEN
3438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3439: IF l_debug_level > 0 THEN
3440: OE_DEBUG_PUB.Add('Other error in validate_action:'
3441: ||sqlerrm,1);
3442: END IF;

Line 3473: x_return_status := FND_API.G_RET_STS_SUCCESS;

3469: -- line with a baseline rev number > 0 , OM will error out.
3470: -- This is because CZ will not support REVERT action in this phase.
3471:
3472: oe_debug_pub.add('Enetering validate line action ' || p_macd_action,2);
3473: x_return_status := FND_API.G_RET_STS_SUCCESS;
3474:
3475: If p_macd_action in ('DELETE', 'DISCONTINUE') then
3476:
3477: Begin

Line 3495: RAISE FND_API.G_EXC_ERROR;

3491: oe_debug_pub.add('Base line rev number : ' || l_baseline_rev_nbr,2);
3492: IF l_baseline_rev_nbr > 0 AND
3493: p_macd_action = 'DELETE' THEN
3494: oe_debug_pub.add('Base line rev number greater than 0',2);
3495: RAISE FND_API.G_EXC_ERROR;
3496: END IF;
3497:
3498: Exception
3499: WHEN NO_DATA_FOUND THEN

Line 3506: WHEN FND_API.G_EXC_ERROR THEN

3502:
3503: End if;
3504: oe_debug_pub.add('Exiting validate_line_action',2);
3505: Exception
3506: WHEN FND_API.G_EXC_ERROR THEN
3507: IF l_debug_level > 0 THEN
3508: OE_DEBUG_PUB.Add('Expected Error in Validate_line_action:'
3509: ||sqlerrm,3);
3510: END IF;

Line 3511: x_return_status := FND_API.G_RET_STS_ERROR;

3507: IF l_debug_level > 0 THEN
3508: OE_DEBUG_PUB.Add('Expected Error in Validate_line_action:'
3509: ||sqlerrm,3);
3510: END IF;
3511: x_return_status := FND_API.G_RET_STS_ERROR;
3512:
3513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3514: IF l_debug_level > 0 THEN
3515: OE_DEBUG_PUB.Add('Unexpected Error Validate_line_action:'

Line 3513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3509: ||sqlerrm,3);
3510: END IF;
3511: x_return_status := FND_API.G_RET_STS_ERROR;
3512:
3513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3514: IF l_debug_level > 0 THEN
3515: OE_DEBUG_PUB.Add('Unexpected Error Validate_line_action:'
3516: ||sqlerrm,3);
3517: END IF;

Line 3518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3514: IF l_debug_level > 0 THEN
3515: OE_DEBUG_PUB.Add('Unexpected Error Validate_line_action:'
3516: ||sqlerrm,3);
3517: END IF;
3518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3519:
3520: WHEN OTHERS THEN
3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: IF l_debug_level > 0 THEN

Line 3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3517: END IF;
3518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3519:
3520: WHEN OTHERS THEN
3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: IF l_debug_level > 0 THEN
3523: OE_DEBUG_PUB.Add('Other error in validate_action:'
3524: ||sqlerrm,1);
3525: END IF;