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.

APPS.OE_RETROBILL_PVT dependencies on FND_API

Line 961: , p_init_msg_list => FND_API.G_FALSE

957: l_x_header_rec:=p_header_rec;
958: l_x_Line_price_Att_tbl := p_Line_price_Att_tbl; --8736629
959: OE_Order_PVT.Process_order
960: ( p_api_version_number => 1.0
961: , p_init_msg_list => FND_API.G_FALSE
962: , x_return_status => x_return_status
963: , x_msg_count => x_msg_count
964: , x_msg_data => x_msg_data
965: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF

Line 966: -- , p_validation_level => FND_API.G_VALID_LEVEL_NONE

962: , x_return_status => x_return_status
963: , x_msg_count => x_msg_count
964: , x_msg_data => x_msg_data
965: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
966: -- , p_validation_level => FND_API.G_VALID_LEVEL_NONE
967: , p_x_header_rec => l_x_header_rec
968: , p_x_Header_Adj_tbl => l_x_Header_Adj_tbl
969: , p_x_Header_Scredit_tbl => l_x_Header_Scredit_tbl
970: , p_x_line_tbl => l_x_line_tbl

Line 1246: x_line_rec.tax_code:=FND_API.G_MISS_CHAR;

1242: --in validation, we will need to ask the system to default the tax code and date
1243: --if we default, we will to tell users about this.
1244: IF NOT IS_TAX_CODE_VALID(p_header_id=>x_line_rec.header_id,p_line_id=>x_line_rec.line_id,p_tax_code=>x_line_rec.tax_code,p_tax_date=>x_line_rec.tax_date, p_org_id=>x_line_rec.org_id) THEN
1245: oe_debug_pub.add('Retro:Old tax code is no longer valid, redaulting a new one');
1246: x_line_rec.tax_code:=FND_API.G_MISS_CHAR;
1247: stmt:=7.61;
1248: x_line_rec.tax_rate:=FND_API.G_MISS_NUM;
1249: stmt:=7.62;
1250: x_line_rec.tax_date:=FND_API.G_MISS_DATE;

Line 1248: x_line_rec.tax_rate:=FND_API.G_MISS_NUM;

1244: IF NOT IS_TAX_CODE_VALID(p_header_id=>x_line_rec.header_id,p_line_id=>x_line_rec.line_id,p_tax_code=>x_line_rec.tax_code,p_tax_date=>x_line_rec.tax_date, p_org_id=>x_line_rec.org_id) THEN
1245: oe_debug_pub.add('Retro:Old tax code is no longer valid, redaulting a new one');
1246: x_line_rec.tax_code:=FND_API.G_MISS_CHAR;
1247: stmt:=7.61;
1248: x_line_rec.tax_rate:=FND_API.G_MISS_NUM;
1249: stmt:=7.62;
1250: x_line_rec.tax_date:=FND_API.G_MISS_DATE;
1251: END IF;
1252:

Line 1250: x_line_rec.tax_date:=FND_API.G_MISS_DATE;

1246: x_line_rec.tax_code:=FND_API.G_MISS_CHAR;
1247: stmt:=7.61;
1248: x_line_rec.tax_rate:=FND_API.G_MISS_NUM;
1249: stmt:=7.62;
1250: x_line_rec.tax_date:=FND_API.G_MISS_DATE;
1251: END IF;
1252:
1253: /******************************************************
1254: --Line info need to be defaulted

Line 1256: x_line_rec.LINE_TYPE_ID:=FND_API.G_MISS_NUM;

1252:
1253: /******************************************************
1254: --Line info need to be defaulted
1255: *******************************************************/
1256: x_line_rec.LINE_TYPE_ID:=FND_API.G_MISS_NUM;
1257: stmt:=7.63;
1258: x_line_rec.line_id:=FND_API.G_MISS_NUM;
1259: stmt:=7.64;
1260: x_line_rec.line_number:=FND_API.G_MISS_NUM;

Line 1258: x_line_rec.line_id:=FND_API.G_MISS_NUM;

1254: --Line info need to be defaulted
1255: *******************************************************/
1256: x_line_rec.LINE_TYPE_ID:=FND_API.G_MISS_NUM;
1257: stmt:=7.63;
1258: x_line_rec.line_id:=FND_API.G_MISS_NUM;
1259: stmt:=7.64;
1260: x_line_rec.line_number:=FND_API.G_MISS_NUM;
1261: stmt:=7.65;
1262: x_line_rec.open_flag:=FND_API.G_MISS_CHAR;

Line 1260: x_line_rec.line_number:=FND_API.G_MISS_NUM;

1256: x_line_rec.LINE_TYPE_ID:=FND_API.G_MISS_NUM;
1257: stmt:=7.63;
1258: x_line_rec.line_id:=FND_API.G_MISS_NUM;
1259: stmt:=7.64;
1260: x_line_rec.line_number:=FND_API.G_MISS_NUM;
1261: stmt:=7.65;
1262: x_line_rec.open_flag:=FND_API.G_MISS_CHAR;
1263: stmt:=7.66;
1264: x_line_rec.booked_flag:=FND_API.G_MISS_CHAR;

Line 1262: x_line_rec.open_flag:=FND_API.G_MISS_CHAR;

1258: x_line_rec.line_id:=FND_API.G_MISS_NUM;
1259: stmt:=7.64;
1260: x_line_rec.line_number:=FND_API.G_MISS_NUM;
1261: stmt:=7.65;
1262: x_line_rec.open_flag:=FND_API.G_MISS_CHAR;
1263: stmt:=7.66;
1264: x_line_rec.booked_flag:=FND_API.G_MISS_CHAR;
1265: stmt:=7.67;
1266:

Line 1264: x_line_rec.booked_flag:=FND_API.G_MISS_CHAR;

1260: x_line_rec.line_number:=FND_API.G_MISS_NUM;
1261: stmt:=7.65;
1262: x_line_rec.open_flag:=FND_API.G_MISS_CHAR;
1263: stmt:=7.66;
1264: x_line_rec.booked_flag:=FND_API.G_MISS_CHAR;
1265: stmt:=7.67;
1266:
1267: -- x_line_rec.ship_to_org_id:=FND_API.G_MISS_NUM; -- Commented for bug 5612169
1268:

Line 1267: -- x_line_rec.ship_to_org_id:=FND_API.G_MISS_NUM; -- Commented for bug 5612169

1263: stmt:=7.66;
1264: x_line_rec.booked_flag:=FND_API.G_MISS_CHAR;
1265: stmt:=7.67;
1266:
1267: -- x_line_rec.ship_to_org_id:=FND_API.G_MISS_NUM; -- Commented for bug 5612169
1268:
1269: If l_debug_level > 0 Then
1270: oe_debug_pub.add('Retro: leaving prepare line');
1271: End If;

Line 1299: x_header_rec.price_list_id :=FND_API.G_MISS_NUM;

1295: x_header_rec.conversion_type_code:=p_conversion_type_code;
1296: x_header_rec.operation :=OE_Globals.G_OPR_CREATE;
1297: x_header_rec.ordered_date :=SYSDATE;
1298: --Should pric list get defaulted? Or just plain copy?
1299: x_header_rec.price_list_id :=FND_API.G_MISS_NUM;
1300: x_header_rec.header_id :=FND_API.G_MISS_NUM;
1301: x_header_rec.version_number :=1;
1302: x_header_rec.invoice_to_org_id :=FND_API.G_MISS_NUM;
1303: x_header_rec.open_flag :='Y';

Line 1300: x_header_rec.header_id :=FND_API.G_MISS_NUM;

1296: x_header_rec.operation :=OE_Globals.G_OPR_CREATE;
1297: x_header_rec.ordered_date :=SYSDATE;
1298: --Should pric list get defaulted? Or just plain copy?
1299: x_header_rec.price_list_id :=FND_API.G_MISS_NUM;
1300: x_header_rec.header_id :=FND_API.G_MISS_NUM;
1301: x_header_rec.version_number :=1;
1302: x_header_rec.invoice_to_org_id :=FND_API.G_MISS_NUM;
1303: x_header_rec.open_flag :='Y';
1304: x_header_rec.booked_flag :='N';

Line 1302: x_header_rec.invoice_to_org_id :=FND_API.G_MISS_NUM;

1298: --Should pric list get defaulted? Or just plain copy?
1299: x_header_rec.price_list_id :=FND_API.G_MISS_NUM;
1300: x_header_rec.header_id :=FND_API.G_MISS_NUM;
1301: x_header_rec.version_number :=1;
1302: x_header_rec.invoice_to_org_id :=FND_API.G_MISS_NUM;
1303: x_header_rec.open_flag :='Y';
1304: x_header_rec.booked_flag :='N';
1305: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1306: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;

Line 1305: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;

1301: x_header_rec.version_number :=1;
1302: x_header_rec.invoice_to_org_id :=FND_API.G_MISS_NUM;
1303: x_header_rec.open_flag :='Y';
1304: x_header_rec.booked_flag :='N';
1305: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1306: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1307: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1308: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1309: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;

Line 1306: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;

1302: x_header_rec.invoice_to_org_id :=FND_API.G_MISS_NUM;
1303: x_header_rec.open_flag :='Y';
1304: x_header_rec.booked_flag :='N';
1305: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1306: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1307: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1308: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1309: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;
1310: x_header_rec.salesrep_id :=FND_API.G_MISS_NUM;

Line 1307: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;

1303: x_header_rec.open_flag :='Y';
1304: x_header_rec.booked_flag :='N';
1305: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1306: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1307: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1308: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1309: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;
1310: x_header_rec.salesrep_id :=FND_API.G_MISS_NUM;
1311: x_header_rec.flow_status_code :='ENTERED';

Line 1308: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;

1304: x_header_rec.booked_flag :='N';
1305: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1306: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1307: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1308: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1309: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;
1310: x_header_rec.salesrep_id :=FND_API.G_MISS_NUM;
1311: x_header_rec.flow_status_code :='ENTERED';
1312: x_header_rec.order_source_id :=G_RETROBILL_ORDER_SOURCE_ID;

Line 1309: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;

1305: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1306: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1307: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1308: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1309: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;
1310: x_header_rec.salesrep_id :=FND_API.G_MISS_NUM;
1311: x_header_rec.flow_status_code :='ENTERED';
1312: x_header_rec.order_source_id :=G_RETROBILL_ORDER_SOURCE_ID;
1313: x_header_rec.orig_sys_document_ref :=p_retrobill_request_rec.retrobill_request_id;

Line 1310: x_header_rec.salesrep_id :=FND_API.G_MISS_NUM;

1306: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1307: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1308: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1309: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;
1310: x_header_rec.salesrep_id :=FND_API.G_MISS_NUM;
1311: x_header_rec.flow_status_code :='ENTERED';
1312: x_header_rec.order_source_id :=G_RETROBILL_ORDER_SOURCE_ID;
1313: x_header_rec.orig_sys_document_ref :=p_retrobill_request_rec.retrobill_request_id;
1314: x_header_rec.cust_po_number :=p_cust_po_number; -- Bug# 6603714

Line 1925: -- l_line_rec.line_type_id :=FND_API.G_MISS_NUM; -- bug# 8751523 : Commented this assignment

1921: l_line_rec.unit_selling_percent :=I.UNIT_SELLING_PERCENT;
1922: l_line_rec.line_category_code :='ORDER';
1923: l_line_rec.calculate_price_flag :='N';
1924: --set following to miss char such that redefault can take place.
1925: -- l_line_rec.line_type_id :=FND_API.G_MISS_NUM; -- bug# 8751523 : Commented this assignment
1926: l_line_rec.operation :=OE_GLOBALS.G_OPR_UPDATE;
1927: l_debit := 'Y';
1928: j:=j+1;
1929:

Line 1999: Oe_Order_Pvt.Lines(p_validation_level=> FND_API.G_VALID_LEVEL_NONE,

1995: -- set the pricing recursion, so that pricing will not get triggered
1996: -- again due to the Oe_Order_Pub.Lines call.
1997: oe_globals.g_pricing_recursion := 'Y';
1998:
1999: Oe_Order_Pvt.Lines(p_validation_level=> FND_API.G_VALID_LEVEL_NONE,
2000: p_control_rec => l_control_rec,
2001: p_x_line_tbl => l_line_tbl,
2002: p_x_old_line_tbl => l_old_line_tbl,
2003: x_return_status => l_return_status);

Line 2307: Raise FND_API.G_EXC_ERROR;

2303: WHEN OTHERS THEN
2304: IF l_debug_level > 0 THEN
2305: oe_debug_pub.add('RETRO:ERROR in creating offset adjustments'||sqlerrm);
2306: END IF;
2307: Raise FND_API.G_EXC_ERROR;
2308: END Insert_diff_Adj;
2309:
2310: Procedure Update_Diff_Adj AS
2311: Begin

Line 2435: --Raise FND_API.G_EXC_ERROR;

2431: WHEN OTHERS THEN
2432:
2433: oe_debug_pub.add('Retro:ERROR in updating adjustments'||sqlerrm);
2434:
2435: --Raise FND_API.G_EXC_ERROR;
2436: End;
2437:
2438: --bug3654144 Adding a new procedure to insert adjustment lines corresponding to new modifiers returns by pricing engine.
2439: PROCEDURE Insert_New_Adj As

Line 2978: Raise FND_API.G_EXC_ERROR;

2974: WHEN OTHERS THEN
2975: IF l_debug_level > 0 THEN
2976: oe_debug_pub.add('RETRO:ERROR in creating new offset adjustments'||sqlerrm);
2977: END IF;
2978: Raise FND_API.G_EXC_ERROR;
2979: END Insert_New_Adj;
2980:
2981: --bug3654144 new procedure added
2982: -- This procedure selects the adjustments which were copied over to oe_price_adjustments

Line 3031: Raise FND_API.G_EXC_ERROR;

3027: WHEN OTHERS THEN
3028: IF l_debug_level > 0 THEN
3029: oe_debug_pub.add('RETRO:ERROR in creating offset adjustments'||sqlerrm);
3030: END IF;
3031: Raise FND_API.G_EXC_ERROR;
3032: END;
3033: l_last_line_id := invalid_price_adj.line_id;
3034: END IF;
3035:

Line 3262: -- return status of FND_API.G_RET_STS_ERROR or

3258: -- This call should come back with a message OE_ORDER_BOOKED
3259: -- if booking completed successfully and if booking was deferred,
3260: -- message OE_ORDER_BOOK_DEFERRED is added to the stack.
3261: -- If booking was not successful, it should come back with a
3262: -- return status of FND_API.G_RET_STS_ERROR or
3263: -- FND_API.G_RET_STS_UNEXP_ERROR
3264: OE_Order_Book_Util.Complete_Book_Eligible
3265: ( p_api_version_number => 1.0
3266: , p_init_msg_list => FND_API.G_FALSE

Line 3263: -- FND_API.G_RET_STS_UNEXP_ERROR

3259: -- if booking completed successfully and if booking was deferred,
3260: -- message OE_ORDER_BOOK_DEFERRED is added to the stack.
3261: -- If booking was not successful, it should come back with a
3262: -- return status of FND_API.G_RET_STS_ERROR or
3263: -- FND_API.G_RET_STS_UNEXP_ERROR
3264: OE_Order_Book_Util.Complete_Book_Eligible
3265: ( p_api_version_number => 1.0
3266: , p_init_msg_list => FND_API.G_FALSE
3267: , p_header_id => k.header_id

Line 3266: , p_init_msg_list => FND_API.G_FALSE

3262: -- return status of FND_API.G_RET_STS_ERROR or
3263: -- FND_API.G_RET_STS_UNEXP_ERROR
3264: OE_Order_Book_Util.Complete_Book_Eligible
3265: ( p_api_version_number => 1.0
3266: , p_init_msg_list => FND_API.G_FALSE
3267: , p_header_id => k.header_id
3268: , x_return_status => l_return_status
3269: , x_msg_count => l_msg_count
3270: , x_msg_data => l_msg_data);

Line 3279: IF (l_return_status<>FND_API.G_RET_STS_SUCCESS) THEN

3275: ,x_msg_count=>l_msg_count
3276: ,x_msg_data=>l_msg_data);*/
3277: IF l_debug_level > 0 THEN
3278: --skubendr{
3279: IF (l_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
3280: Display_Message(l_msg_count,l_msg_data);
3281: END IF;
3282: --skubendr}
3283: END IF;

Line 3286: IF (l_return_status<>FND_API.G_RET_STS_SUCCESS) THEN

3282: --skubendr}
3283: END IF;
3284:
3285: --bug5003256 start
3286: IF (l_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
3287: SELECT count(*) INTO l_book_line_count
3288: FROM oe_order_lines_all
3289: WHERE header_id = k.header_id;
3290: x_error_count := x_error_count + l_book_line_count;

Line 3323: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3319: ,x_line_Tbl => l_Line_Tbl);
3320: oe_debug_pub.add('Retro:return status from price_line:'||l_Return_Status);
3321:
3322: --bug5003256 start
3323: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3324: x_error_count := x_error_count + l_line_tbl.count;
3325: END IF;
3326: --bug5003256 end
3327:

Line 3405: x_return_status:=FND_API.G_RET_STS_SUCCESS;

3401: l_Line_price_Att_tbl Oe_Order_Pub.Line_Price_Att_Tbl_Type; -- 8736629
3402: l_row_count NUMBER; -- 8736629
3403: Begin
3404: stmt:=1;
3405: x_return_status:=FND_API.G_RET_STS_SUCCESS;
3406: --GSCC (instead of initializing in the spec)
3407: G_FIRST_LINE_DELETED := 'N';
3408: G_FIRST_LINE_PL_ASSIGNED := 'N';
3409: --GSCC not initializing during declaration

Line 3455: IF(lx_return_status=FND_API.G_RET_STS_SUCCESS and lx_header_id is not NULL) THEN

3451: p_line_tbl =>l_line_tbl,
3452: p_Line_price_Att_tbl => l_Line_price_Att_tbl, -- 8736629
3453: x_created_header_id=>lx_header_id,
3454: x_return_status =>lx_return_status);
3455: IF(lx_return_status=FND_API.G_RET_STS_SUCCESS and lx_header_id is not NULL) THEN
3456: Oe_retrobill_Pvt.Delete_Order(lx_header_id, l_header_deleted);
3457: --bug 12922209
3458: IF l_header_deleted THEN
3459: oe_debug_pub.ADD('Retro Order Header created has been deleted');

Line 3501: If lx_return_status = FND_API.G_RET_STS_SUCCESS AND

3497: END;
3498:
3499:
3500:
3501: If lx_return_status = FND_API.G_RET_STS_SUCCESS AND
3502: NOT l_header_deleted Then --bug5003256
3503: l_to_be_exe_hdr_id_tbl(i):=lx_header_id;
3504: i:=i+1;
3505: End If;

Line 3575: IF(lx_return_status=FND_API.G_RET_STS_SUCCESS and lx_header_id is not NULL) THEN

3571: p_line_tbl=>l_line_tbl,
3572: p_Line_price_Att_tbl => l_Line_price_Att_tbl, -- 8736629
3573: x_created_header_id=>lx_header_id,
3574: x_return_status=>lx_return_status);
3575: IF(lx_return_status=FND_API.G_RET_STS_SUCCESS and lx_header_id is not NULL) THEN
3576: oe_retrobill_pvt.delete_order(lx_header_id, l_header_deleted); --bug5003256
3577: --bug 12922209 start
3578: IF l_header_deleted THEN
3579: oe_debug_pub.ADD('Retro Order Header created has been deleted');

Line 3594: If lx_return_status = FND_API.G_RET_STS_SUCCESS AND

3590:
3591: oe_debug_pub.add('Praveen: Price List Id' || G_FIRST_LINE_PRICE_LIST_ID);
3592: oe_debug_pub.add('Praveen: First Line Deleted' || G_FIRST_LINE_DELETED);
3593:
3594: If lx_return_status = FND_API.G_RET_STS_SUCCESS AND
3595: NOT l_header_deleted Then --bug5003256
3596: l_to_be_exe_hdr_id_tbl(i):=lx_header_id;
3597: End If;
3598: BEGIN

Line 3632: , p_init_msg_list => FND_API.G_FALSE

3628:
3629: WHILE i IS NOT NULL LOOP
3630: OE_Order_Book_Util.Complete_Book_Eligible
3631: ( p_api_version_number => 1.0
3632: , p_init_msg_list => FND_API.G_FALSE
3633: , p_header_id => l_to_be_exe_hdr_id_tbl(i)
3634: , x_return_status => lx_return_status
3635: , x_msg_count => l_msg_count
3636: , x_msg_data => l_msg_data);

Line 3640: IF (lx_return_status<>FND_API.G_RET_STS_SUCCESS) THEN

3636: , x_msg_data => l_msg_data);
3637: IF l_debug_level > 0 THEN
3638: oe_debug_pub.add('Retro:Direct Execution without preview');
3639: --skubendr{
3640: IF (lx_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
3641: Display_Message(l_msg_count,l_msg_data);
3642: END IF;
3643: --skubendr}
3644: END IF;

Line 3647: IF (lx_return_status<>FND_API.G_RET_STS_SUCCESS) THEN

3643: --skubendr}
3644: END IF;
3645:
3646: --bug5003256 start
3647: IF (lx_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
3648: SELECT count(*) INTO l_book_line_count
3649: FROM oe_order_lines_all
3650: WHERE header_id = l_to_be_exe_hdr_id_tbl(i);
3651:

Line 3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3675:
3676: IF G_CURRENT_RETROBILL_REQUEST_ID IS NULL THEN
3677: oe_debug_pub.add('Retro:previouly previewed request, request id can not be NULL!');
3678: l_msg:='Retro:previouly previewed request, request id can not be NULL!';
3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3680: END IF;
3681:
3682: --retrobilled request parameters
3683: Update_Row(p_retrobill_request_rec=>l_retrobill_request_rec);

Line 3694: When FND_API.G_EXC_UNEXPECTED_ERROR Then

3690:
3691: oe_msg_pub.count_and_get(p_count => x_msg_count,p_data=> x_msg_data);
3692: Exception
3693:
3694: When FND_API.G_EXC_UNEXPECTED_ERROR Then
3695: OE_MSG_PUB.Add_Exc_Msg
3696: ( G_PKG_NAME ,
3697: l_msg
3698: );

Line 3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3695: OE_MSG_PUB.Add_Exc_Msg
3696: ( G_PKG_NAME ,
3697: l_msg
3698: );
3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3700: oe_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
3701: x_created_retrobill_request_id:=NULL;
3702: --bug5003256
3703: x_error_count := -1;

Line 3707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3703: x_error_count := -1;
3704: When Others Then
3705: oe_debug_pub.add('Exception occured in process_retrobill_requests:'||SQLERRM);
3706: oe_debug_pub.add('Statement number:'||stmt);
3707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3708: x_retrun_status_text:='OE_RETROBILL_PVT.Process_Retrobill_Request'||SQLERRM;
3709: oe_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
3710: x_created_retrobill_request_id:=NULL;
3711: --bug5003256

Line 3952: l_return_status := FND_API.G_RET_STS_ERROR;

3948: FROM oe_transaction_types_all
3949: WHERE transaction_type_id = p_order_type_id;
3950: EXCEPTION
3951: WHEN NO_DATA_FOUND THEN
3952: l_return_status := FND_API.G_RET_STS_ERROR;
3953: fnd_file.put_line(FND_FILE.OUTPUT,'Could not set org context');
3954: retcode := -1;
3955: RETURN;
3956: END;

Line 3963: l_return_status := FND_API.G_RET_STS_ERROR;

3959: IF l_debug_level > 0 THEN
3960: oe_debug_pub.add('Context is set for org_id : '|| mo_global.get_current_org_id);
3961: END IF;
3962: ELSE
3963: l_return_status := FND_API.G_RET_STS_ERROR;
3964: fnd_file.put_line(FND_FILE.OUTPUT,'Could not set org context');
3965: retcode := -1;
3966: RETURN;
3967: END IF;

Line 3988: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3984: x_retrobill_request_id=>l_retrobill_request_id,
3985: x_error_count => l_error_count, --bug5003256
3986: x_ret_code =>l_ret_code); --bug12922209
3987:
3988: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3989: OE_MSG_PUB.save_messages (l_concurrent_request_id);
3990: commit;
3991: --fnd_file.put_line(FND_FILE.OUTPUT,'Sucessful completion');
3992: errbuf := FND_MESSAGE.GET;

Line 4145: RAISE FND_API.G_EXC_ERROR;

4141: FROM oe_order_lines_all where line_id=p_line_rec.reference_line_id;
4142: EXCEPTION
4143: WHEN OTHERS THEN
4144: -- THis is impossible
4145: RAISE FND_API.G_EXC_ERROR;
4146: END;
4147:
4148: IF l_debug_level > 0 THEN
4149: oe_debug_pub.add('original Price:'||l_orig_selling_price,3);

Line 4231: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4227: IF l_debug_level > 0 THEN
4228: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||
4229: L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
4230: END IF;
4231: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4232: RAISE FND_API.G_EXC_ERROR;
4233: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4235: END IF;

Line 4232: RAISE FND_API.G_EXC_ERROR;

4228: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||
4229: L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
4230: END IF;
4231: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4232: RAISE FND_API.G_EXC_ERROR;
4233: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4235: END IF;
4236: i := l_line_tbl.next(i);

Line 4233: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4229: L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
4230: END IF;
4231: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4232: RAISE FND_API.G_EXC_ERROR;
4233: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4235: END IF;
4236: i := l_line_tbl.next(i);
4237: END LOOP;

Line 4234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4230: END IF;
4231: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4232: RAISE FND_API.G_EXC_ERROR;
4233: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4235: END IF;
4236: i := l_line_tbl.next(i);
4237: END LOOP;
4238:

Line 4399: , p_init_msg_list => FND_API.G_TRUE

4395: l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4396:
4397: OE_ORDER_PVT.Process_order
4398: ( p_api_version_number => 1.0
4399: , p_init_msg_list => FND_API.G_TRUE
4400: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4401: , x_return_status => l_return_status
4402: , x_msg_count => l_msg_count
4403: , x_msg_data => l_msg_data

Line 4400: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

4396:
4397: OE_ORDER_PVT.Process_order
4398: ( p_api_version_number => 1.0
4399: , p_init_msg_list => FND_API.G_TRUE
4400: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4401: , x_return_status => l_return_status
4402: , x_msg_count => l_msg_count
4403: , x_msg_data => l_msg_data
4404: , p_control_rec => l_control_rec

Line 4423: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4419: , p_x_Line_Adj_Att_tbl => l_Line_Adj_Att_tbl
4420: , p_x_Line_Adj_Assoc_tbl => l_Line_Adj_Assoc_tbl
4421: );
4422:
4423: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4424: oe_debug_pub.add('Deleted Header:'||l_retrobill_header_rec.header_id);
4425: l_headers_processed := l_headers_processed+1;
4426: END IF;
4427: ELSE