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 1613: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1617: RAISE FND_API.G_EXC_ERROR;

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

Line 1618: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1685: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1689: RAISE FND_API.G_EXC_ERROR;

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

Line 1690: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1734: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1738: RAISE FND_API.G_EXC_ERROR;

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

Line 1739: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1799: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1803: RAISE FND_API.G_EXC_ERROR;

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

Line 1804: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1836: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1840: RAISE FND_API.G_EXC_ERROR;

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

Line 1841: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1858: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1868: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1957: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1971: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1988: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2007: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2025: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2027: Raise FND_API.G_EXC_ERROR;

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

Line 2041: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2043: Raise FND_API.G_EXC_ERROR;

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

Line 2057: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2059: Raise FND_API.G_EXC_ERROR;

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

Line 2084: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2089: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2093: RAISE FND_API.G_EXC_ERROR;

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

Line 2126: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2128: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2129: RAISE FND_API.G_EXC_ERROR;

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

Line 2165: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2168: RAISE FND_API.G_EXC_ERROR;

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

Line 2195: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2197: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2198: RAISE FND_API.G_EXC_ERROR;

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

Line 2243: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2252: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2306: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2323: ( p_validation_level =>FND_API.G_VALID_LEVEL_NONE

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

Line 2324: , p_init_msg_list => FND_API.G_TRUE

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

Line 2332: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2334: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2335: RAISE FND_API.G_EXC_ERROR;

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

Line 2351: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2356: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2480: IF x_return_status=FND_API.G_RET_STS_ERROR THEN

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

Line 2481: RAISE FND_API.G_EXC_ERROR;

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

Line 2482: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2524: IF x_return_status=FND_API.G_RET_STS_ERROR THEN

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

Line 2525: RAISE FND_API.G_EXC_ERROR;

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

Line 2526: ELSIF x_return_status=FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2543: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2548: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2629: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2672: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2674: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2675: RAISE FND_API.G_EXC_ERROR;

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

Line 2727: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2729: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2730: RAISE FND_API.G_EXC_ERROR;

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

Line 2798: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2800: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2801: RAISE FND_API.G_EXC_ERROR;

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

Line 2836: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2838: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2839: RAISE FND_API.G_EXC_ERROR;

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

Line 2853: RAISE FND_API.G_EXC_ERROR;

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

Line 2871: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2873: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2874: RAISE FND_API.G_EXC_ERROR;

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

Line 2973: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2975: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2976: RAISE FND_API.G_EXC_ERROR;

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

Line 3014: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3016: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 3017: RAISE FND_API.G_EXC_ERROR;

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

Line 3067: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3069: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 3070: RAISE FND_API.G_EXC_ERROR;

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

Line 3129: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3131: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 3132: RAISE FND_API.G_EXC_ERROR;

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

Line 3155: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3157: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 3158: RAISE FND_API.G_EXC_ERROR;

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

Line 3190: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3192: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 3193: RAISE FND_API.G_EXC_ERROR;

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

Line 3214: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3219: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3317: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3366: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3393: RAISE FND_API.G_EXC_ERROR;

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

Line 3400: RAISE FND_API.G_EXC_ERROR;

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

Line 3422: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3427: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3472: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3494: RAISE FND_API.G_EXC_ERROR;

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

Line 3505: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3510: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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