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 946: , p_init_msg_list => FND_API.G_FALSE

942: l_x_line_tbl := p_line_tbl;
943: l_x_header_rec:=p_header_rec;
944: OE_Order_PVT.Process_order
945: ( p_api_version_number => 1.0
946: , p_init_msg_list => FND_API.G_FALSE
947: , x_return_status => x_return_status
948: , x_msg_count => x_msg_count
949: , x_msg_data => x_msg_data
950: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF

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

947: , x_return_status => x_return_status
948: , x_msg_count => x_msg_count
949: , x_msg_data => x_msg_data
950: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
951: -- , p_validation_level => FND_API.G_VALID_LEVEL_NONE
952: , p_x_header_rec => l_x_header_rec
953: , p_x_Header_Adj_tbl => l_x_Header_Adj_tbl
954: , p_x_Header_Scredit_tbl => l_x_Header_Scredit_tbl
955: , p_x_line_tbl => l_x_line_tbl

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

1223: --in validation, we will need to ask the system to default the tax code and date
1224: --if we default, we will to tell users about this.
1225: 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
1226: oe_debug_pub.add('Retro:Old tax code is no longer valid, redaulting a new one');
1227: x_line_rec.tax_code:=FND_API.G_MISS_CHAR;
1228: stmt:=7.61;
1229: x_line_rec.tax_rate:=FND_API.G_MISS_NUM;
1230: stmt:=7.62;
1231: x_line_rec.tax_date:=FND_API.G_MISS_DATE;

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

1225: 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
1226: oe_debug_pub.add('Retro:Old tax code is no longer valid, redaulting a new one');
1227: x_line_rec.tax_code:=FND_API.G_MISS_CHAR;
1228: stmt:=7.61;
1229: x_line_rec.tax_rate:=FND_API.G_MISS_NUM;
1230: stmt:=7.62;
1231: x_line_rec.tax_date:=FND_API.G_MISS_DATE;
1232: END IF;
1233:

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

1227: x_line_rec.tax_code:=FND_API.G_MISS_CHAR;
1228: stmt:=7.61;
1229: x_line_rec.tax_rate:=FND_API.G_MISS_NUM;
1230: stmt:=7.62;
1231: x_line_rec.tax_date:=FND_API.G_MISS_DATE;
1232: END IF;
1233:
1234: /******************************************************
1235: --Line info need to be defaulted

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

1233:
1234: /******************************************************
1235: --Line info need to be defaulted
1236: *******************************************************/
1237: x_line_rec.LINE_TYPE_ID:=FND_API.G_MISS_NUM;
1238: stmt:=7.63;
1239: x_line_rec.line_id:=FND_API.G_MISS_NUM;
1240: stmt:=7.64;
1241: x_line_rec.line_number:=FND_API.G_MISS_NUM;

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

1235: --Line info need to be defaulted
1236: *******************************************************/
1237: x_line_rec.LINE_TYPE_ID:=FND_API.G_MISS_NUM;
1238: stmt:=7.63;
1239: x_line_rec.line_id:=FND_API.G_MISS_NUM;
1240: stmt:=7.64;
1241: x_line_rec.line_number:=FND_API.G_MISS_NUM;
1242: stmt:=7.65;
1243: x_line_rec.open_flag:=FND_API.G_MISS_CHAR;

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

1237: x_line_rec.LINE_TYPE_ID:=FND_API.G_MISS_NUM;
1238: stmt:=7.63;
1239: x_line_rec.line_id:=FND_API.G_MISS_NUM;
1240: stmt:=7.64;
1241: x_line_rec.line_number:=FND_API.G_MISS_NUM;
1242: stmt:=7.65;
1243: x_line_rec.open_flag:=FND_API.G_MISS_CHAR;
1244: stmt:=7.66;
1245: x_line_rec.booked_flag:=FND_API.G_MISS_CHAR;

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

1239: x_line_rec.line_id:=FND_API.G_MISS_NUM;
1240: stmt:=7.64;
1241: x_line_rec.line_number:=FND_API.G_MISS_NUM;
1242: stmt:=7.65;
1243: x_line_rec.open_flag:=FND_API.G_MISS_CHAR;
1244: stmt:=7.66;
1245: x_line_rec.booked_flag:=FND_API.G_MISS_CHAR;
1246: stmt:=7.67;
1247:

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

1241: x_line_rec.line_number:=FND_API.G_MISS_NUM;
1242: stmt:=7.65;
1243: x_line_rec.open_flag:=FND_API.G_MISS_CHAR;
1244: stmt:=7.66;
1245: x_line_rec.booked_flag:=FND_API.G_MISS_CHAR;
1246: stmt:=7.67;
1247:
1248: -- x_line_rec.ship_to_org_id:=FND_API.G_MISS_NUM; -- Commented for bug 5612169
1249:

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

1244: stmt:=7.66;
1245: x_line_rec.booked_flag:=FND_API.G_MISS_CHAR;
1246: stmt:=7.67;
1247:
1248: -- x_line_rec.ship_to_org_id:=FND_API.G_MISS_NUM; -- Commented for bug 5612169
1249:
1250: If l_debug_level > 0 Then
1251: oe_debug_pub.add('Retro:leaving prepare line');
1252: End If;

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

1276: x_header_rec.conversion_type_code:=p_conversion_type_code;
1277: x_header_rec.operation :=OE_Globals.G_OPR_CREATE;
1278: x_header_rec.ordered_date :=SYSDATE;
1279: --Should pric list get defaulted? Or just plain copy?
1280: x_header_rec.price_list_id :=FND_API.G_MISS_NUM;
1281: x_header_rec.header_id :=FND_API.G_MISS_NUM;
1282: x_header_rec.version_number :=1;
1283: x_header_rec.invoice_to_org_id :=FND_API.G_MISS_NUM;
1284: x_header_rec.open_flag :='Y';

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

1277: x_header_rec.operation :=OE_Globals.G_OPR_CREATE;
1278: x_header_rec.ordered_date :=SYSDATE;
1279: --Should pric list get defaulted? Or just plain copy?
1280: x_header_rec.price_list_id :=FND_API.G_MISS_NUM;
1281: x_header_rec.header_id :=FND_API.G_MISS_NUM;
1282: x_header_rec.version_number :=1;
1283: x_header_rec.invoice_to_org_id :=FND_API.G_MISS_NUM;
1284: x_header_rec.open_flag :='Y';
1285: x_header_rec.booked_flag :='N';

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

1279: --Should pric list get defaulted? Or just plain copy?
1280: x_header_rec.price_list_id :=FND_API.G_MISS_NUM;
1281: x_header_rec.header_id :=FND_API.G_MISS_NUM;
1282: x_header_rec.version_number :=1;
1283: x_header_rec.invoice_to_org_id :=FND_API.G_MISS_NUM;
1284: x_header_rec.open_flag :='Y';
1285: x_header_rec.booked_flag :='N';
1286: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1287: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;

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

1282: x_header_rec.version_number :=1;
1283: x_header_rec.invoice_to_org_id :=FND_API.G_MISS_NUM;
1284: x_header_rec.open_flag :='Y';
1285: x_header_rec.booked_flag :='N';
1286: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1287: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1288: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1289: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1290: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;

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

1283: x_header_rec.invoice_to_org_id :=FND_API.G_MISS_NUM;
1284: x_header_rec.open_flag :='Y';
1285: x_header_rec.booked_flag :='N';
1286: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1287: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1288: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1289: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1290: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;
1291: x_header_rec.salesrep_id :=FND_API.G_MISS_NUM;

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

1284: x_header_rec.open_flag :='Y';
1285: x_header_rec.booked_flag :='N';
1286: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1287: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1288: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1289: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1290: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;
1291: x_header_rec.salesrep_id :=FND_API.G_MISS_NUM;
1292: x_header_rec.flow_status_code :='ENTERED';

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

1285: x_header_rec.booked_flag :='N';
1286: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1287: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1288: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1289: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1290: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;
1291: x_header_rec.salesrep_id :=FND_API.G_MISS_NUM;
1292: x_header_rec.flow_status_code :='ENTERED';
1293: x_header_rec.order_source_id :=G_RETROBILL_ORDER_SOURCE_ID;

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

1286: x_header_rec.ship_to_org_id :=FND_API.G_MISS_NUM;
1287: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1288: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1289: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1290: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;
1291: x_header_rec.salesrep_id :=FND_API.G_MISS_NUM;
1292: x_header_rec.flow_status_code :='ENTERED';
1293: x_header_rec.order_source_id :=G_RETROBILL_ORDER_SOURCE_ID;
1294: x_header_rec.orig_sys_document_ref :=p_retrobill_request_rec.retrobill_request_id;

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

1287: x_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
1288: x_header_rec.tax_exempt_number :=FND_API.G_MISS_CHAR;
1289: x_header_rec.tax_exempt_reason_code:=FND_API.G_MISS_CHAR;
1290: x_header_rec.payment_term_id :=FND_API.G_MISS_NUM;
1291: x_header_rec.salesrep_id :=FND_API.G_MISS_NUM;
1292: x_header_rec.flow_status_code :='ENTERED';
1293: x_header_rec.order_source_id :=G_RETROBILL_ORDER_SOURCE_ID;
1294: x_header_rec.orig_sys_document_ref :=p_retrobill_request_rec.retrobill_request_id;
1295: x_header_rec.cust_po_number :=p_cust_po_number; -- Bug# 6603714

Line 1592: l_line_rec.line_type_id :=FND_API.G_MISS_NUM;

1588: l_line_rec.unit_selling_percent :=I.UNIT_SELLING_PERCENT;
1589: l_line_rec.line_category_code :='ORDER';
1590: l_line_rec.calculate_price_flag :='N';
1591: --set following to miss char such that redefault can take place.
1592: l_line_rec.line_type_id :=FND_API.G_MISS_NUM;
1593: l_line_rec.operation :=OE_GLOBALS.G_OPR_UPDATE;
1594: l_debit := 'Y';
1595: j:=j+1;
1596:

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

1659: -- set the pricing recursion, so that pricing will not get triggered
1660: -- again due to the Oe_Order_Pub.Lines call.
1661: oe_globals.g_pricing_recursion := 'Y';
1662:
1663: Oe_Order_Pvt.Lines(p_validation_level=> FND_API.G_VALID_LEVEL_NONE,
1664: p_control_rec => l_control_rec,
1665: p_x_line_tbl => l_line_tbl,
1666: p_x_old_line_tbl => l_old_line_tbl,
1667: x_return_status => l_return_status);

Line 1969: Raise FND_API.G_EXC_ERROR;

1965: WHEN OTHERS THEN
1966: IF l_debug_level > 0 THEN
1967: oe_debug_pub.add('RETRO:ERROR in creating offset adjustments'||sqlerrm);
1968: END IF;
1969: Raise FND_API.G_EXC_ERROR;
1970: END Insert_diff_Adj;
1971:
1972: Procedure Update_Diff_Adj AS
1973: Begin

Line 2097: --Raise FND_API.G_EXC_ERROR;

2093: WHEN OTHERS THEN
2094:
2095: oe_debug_pub.add('Retro:ERROR in updating adjustments'||sqlerrm);
2096:
2097: --Raise FND_API.G_EXC_ERROR;
2098: End;
2099:
2100: --bug3654144 Adding a new procedure to insert adjustment lines corresponding to new modifiers returns by pricing engine.
2101: PROCEDURE Insert_New_Adj As

Line 2640: Raise FND_API.G_EXC_ERROR;

2636: WHEN OTHERS THEN
2637: IF l_debug_level > 0 THEN
2638: oe_debug_pub.add('RETRO:ERROR in creating new offset adjustments'||sqlerrm);
2639: END IF;
2640: Raise FND_API.G_EXC_ERROR;
2641: END Insert_New_Adj;
2642:
2643: --bug3654144 new procedure added
2644: -- This procedure selects the adjustments which were copied over to oe_price_adjustments

Line 2693: Raise FND_API.G_EXC_ERROR;

2689: WHEN OTHERS THEN
2690: IF l_debug_level > 0 THEN
2691: oe_debug_pub.add('RETRO:ERROR in creating offset adjustments'||sqlerrm);
2692: END IF;
2693: Raise FND_API.G_EXC_ERROR;
2694: END;
2695: l_last_line_id := invalid_price_adj.line_id;
2696: END IF;
2697:

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

2920: -- This call should come back with a message OE_ORDER_BOOKED
2921: -- if booking completed successfully and if booking was deferred,
2922: -- message OE_ORDER_BOOK_DEFERRED is added to the stack.
2923: -- If booking was not successful, it should come back with a
2924: -- return status of FND_API.G_RET_STS_ERROR or
2925: -- FND_API.G_RET_STS_UNEXP_ERROR
2926: OE_Order_Book_Util.Complete_Book_Eligible
2927: ( p_api_version_number => 1.0
2928: , p_init_msg_list => FND_API.G_FALSE

Line 2925: -- FND_API.G_RET_STS_UNEXP_ERROR

2921: -- if booking completed successfully and if booking was deferred,
2922: -- message OE_ORDER_BOOK_DEFERRED is added to the stack.
2923: -- If booking was not successful, it should come back with a
2924: -- return status of FND_API.G_RET_STS_ERROR or
2925: -- FND_API.G_RET_STS_UNEXP_ERROR
2926: OE_Order_Book_Util.Complete_Book_Eligible
2927: ( p_api_version_number => 1.0
2928: , p_init_msg_list => FND_API.G_FALSE
2929: , p_header_id => k.header_id

Line 2928: , p_init_msg_list => FND_API.G_FALSE

2924: -- return status of FND_API.G_RET_STS_ERROR or
2925: -- FND_API.G_RET_STS_UNEXP_ERROR
2926: OE_Order_Book_Util.Complete_Book_Eligible
2927: ( p_api_version_number => 1.0
2928: , p_init_msg_list => FND_API.G_FALSE
2929: , p_header_id => k.header_id
2930: , x_return_status => l_return_status
2931: , x_msg_count => l_msg_count
2932: , x_msg_data => l_msg_data);

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

2937: ,x_msg_count=>l_msg_count
2938: ,x_msg_data=>l_msg_data);*/
2939: IF l_debug_level > 0 THEN
2940: --skubendr{
2941: IF (l_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
2942: Display_Message(l_msg_count,l_msg_data);
2943: END IF;
2944: --skubendr}
2945: END IF;

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

2944: --skubendr}
2945: END IF;
2946:
2947: --bug5003256 start
2948: IF (l_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
2949: SELECT count(*) INTO l_book_line_count
2950: FROM oe_order_lines_all
2951: WHERE header_id = k.header_id;
2952: x_error_count := x_error_count + l_book_line_count;

Line 2985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2981: ,x_line_Tbl => l_Line_Tbl);
2982: oe_debug_pub.add('Retro:return status from price_line:'||l_Return_Status);
2983:
2984: --bug5003256 start
2985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2986: x_error_count := x_error_count + l_line_tbl.count;
2987: END IF;
2988: --bug5003256 end
2989:

Line 3063: x_return_status:=FND_API.G_RET_STS_SUCCESS;

3059: --bug5003256 end
3060: l_cust_po_number VARCHAR2(50); -- Bug# 6603714
3061: Begin
3062: stmt:=1;
3063: x_return_status:=FND_API.G_RET_STS_SUCCESS;
3064: --GSCC (instead of initializing in the spec)
3065: G_FIRST_LINE_DELETED := 'N';
3066: G_FIRST_LINE_PL_ASSIGNED := 'N';
3067: --GSCC not initializing during declaration

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

3108: Call_Process_Order(p_header_rec =>l_header_rec,
3109: p_line_tbl =>l_line_tbl,
3110: x_created_header_id=>lx_header_id,
3111: x_return_status =>lx_return_status);
3112: IF(lx_return_status=FND_API.G_RET_STS_SUCCESS and lx_header_id is not NULL) THEN
3113: Oe_retrobill_Pvt.Delete_Order(lx_header_id, l_header_deleted);
3114: --bug5003256
3115: ELSE
3116: x_error_count := x_error_count + l_line_tbl.count;

Line 3148: If lx_return_status = FND_API.G_RET_STS_SUCCESS AND

3144: END;
3145:
3146:
3147:
3148: If lx_return_status = FND_API.G_RET_STS_SUCCESS AND
3149: NOT l_header_deleted Then --bug5003256
3150: l_to_be_exe_hdr_id_tbl(i):=lx_header_id;
3151: i:=i+1;
3152: End If;

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

3194: Call_Process_Order(p_header_rec=>l_header_rec,
3195: p_line_tbl=>l_line_tbl,
3196: x_created_header_id=>lx_header_id,
3197: x_return_status=>lx_return_status);
3198: IF(lx_return_status=FND_API.G_RET_STS_SUCCESS and lx_header_id is not NULL) THEN
3199: oe_retrobill_pvt.delete_order(lx_header_id, l_header_deleted); --bug5003256
3200: --bug5003256
3201: ELSE
3202: x_error_count := x_error_count + l_line_tbl.count;

Line 3209: If lx_return_status = FND_API.G_RET_STS_SUCCESS AND

3205:
3206: oe_debug_pub.add('Praveen: Price List Id' || G_FIRST_LINE_PRICE_LIST_ID);
3207: oe_debug_pub.add('Praveen: First Line Deleted' || G_FIRST_LINE_DELETED);
3208:
3209: If lx_return_status = FND_API.G_RET_STS_SUCCESS AND
3210: NOT l_header_deleted Then --bug5003256
3211: l_to_be_exe_hdr_id_tbl(i):=lx_header_id;
3212: End If;
3213: BEGIN

Line 3247: , p_init_msg_list => FND_API.G_FALSE

3243:
3244: WHILE i IS NOT NULL LOOP
3245: OE_Order_Book_Util.Complete_Book_Eligible
3246: ( p_api_version_number => 1.0
3247: , p_init_msg_list => FND_API.G_FALSE
3248: , p_header_id => l_to_be_exe_hdr_id_tbl(i)
3249: , x_return_status => lx_return_status
3250: , x_msg_count => l_msg_count
3251: , x_msg_data => l_msg_data);

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

3251: , x_msg_data => l_msg_data);
3252: IF l_debug_level > 0 THEN
3253: oe_debug_pub.add('Retro:Direct Execution without preview');
3254: --skubendr{
3255: IF (lx_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
3256: Display_Message(l_msg_count,l_msg_data);
3257: END IF;
3258: --skubendr}
3259: END IF;

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

3258: --skubendr}
3259: END IF;
3260:
3261: --bug5003256 start
3262: IF (lx_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
3263: SELECT count(*) INTO l_book_line_count
3264: FROM oe_order_lines_all
3265: WHERE header_id = l_to_be_exe_hdr_id_tbl(i);
3266:

Line 3294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3290:
3291: IF G_CURRENT_RETROBILL_REQUEST_ID IS NULL THEN
3292: oe_debug_pub.add('Retro:previouly previewed request, request id can not be NULL!');
3293: l_msg:='Retro:previouly previewed request, request id can not be NULL!';
3294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3295: END IF;
3296:
3297: --retrobilled request parameters
3298: Update_Row(p_retrobill_request_rec=>l_retrobill_request_rec);

Line 3308: When FND_API.G_EXC_UNEXPECTED_ERROR Then

3304:
3305: oe_msg_pub.count_and_get(p_count => x_msg_count,p_data=> x_msg_data);
3306: Exception
3307:
3308: When FND_API.G_EXC_UNEXPECTED_ERROR Then
3309: OE_MSG_PUB.Add_Exc_Msg
3310: ( G_PKG_NAME ,
3311: l_msg
3312: );

Line 3313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3309: OE_MSG_PUB.Add_Exc_Msg
3310: ( G_PKG_NAME ,
3311: l_msg
3312: );
3313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3314: oe_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
3315: x_created_retrobill_request_id:=NULL;
3316: --bug5003256
3317: x_error_count := -1;

Line 3321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3317: x_error_count := -1;
3318: When Others Then
3319: oe_debug_pub.add('Exception occured in process_retrobill_requests:'||SQLERRM);
3320: oe_debug_pub.add('Statement number:'||stmt);
3321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3322: x_retrun_status_text:='OE_RETROBILL_PVT.Process_Retrobill_Request'||SQLERRM;
3323: oe_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
3324: x_created_retrobill_request_id:=NULL;
3325: --bug5003256

Line 3561: l_return_status := FND_API.G_RET_STS_ERROR;

3557: FROM oe_transaction_types_all
3558: WHERE transaction_type_id = p_order_type_id;
3559: EXCEPTION
3560: WHEN NO_DATA_FOUND THEN
3561: l_return_status := FND_API.G_RET_STS_ERROR;
3562: fnd_file.put_line(FND_FILE.OUTPUT,'Could not set org context');
3563: retcode := -1;
3564: RETURN;
3565: END;

Line 3572: l_return_status := FND_API.G_RET_STS_ERROR;

3568: IF l_debug_level > 0 THEN
3569: oe_debug_pub.add('Context is set for org_id : '|| mo_global.get_current_org_id);
3570: END IF;
3571: ELSE
3572: l_return_status := FND_API.G_RET_STS_ERROR;
3573: fnd_file.put_line(FND_FILE.OUTPUT,'Could not set org context');
3574: retcode := -1;
3575: RETURN;
3576: END IF;

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

3593: x_retrobill_request_id=>l_retrobill_request_id,
3594: x_error_count => l_error_count --bug5003256
3595: );
3596:
3597: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3598: OE_MSG_PUB.save_messages (l_concurrent_request_id);
3599: commit;
3600: fnd_file.put_line(FND_FILE.OUTPUT,'Sucessful completion');
3601: errbuf := FND_MESSAGE.GET;

Line 3744: RAISE FND_API.G_EXC_ERROR;

3740: FROM oe_order_lines_all where line_id=p_line_rec.reference_line_id;
3741: EXCEPTION
3742: WHEN OTHERS THEN
3743: -- THis is impossible
3744: RAISE FND_API.G_EXC_ERROR;
3745: END;
3746:
3747: IF l_debug_level > 0 THEN
3748: oe_debug_pub.add('original Price:'||l_orig_selling_price,3);

Line 3806: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3802: IF l_debug_level > 0 THEN
3803: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||
3804: L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
3805: END IF;
3806: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3807: RAISE FND_API.G_EXC_ERROR;
3808: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3810: END IF;

Line 3807: RAISE FND_API.G_EXC_ERROR;

3803: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||
3804: L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
3805: END IF;
3806: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3807: RAISE FND_API.G_EXC_ERROR;
3808: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3810: END IF;
3811: i := l_line_tbl.next(i);

Line 3808: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3804: L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
3805: END IF;
3806: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3807: RAISE FND_API.G_EXC_ERROR;
3808: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3810: END IF;
3811: i := l_line_tbl.next(i);
3812: END LOOP;

Line 3809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3805: END IF;
3806: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3807: RAISE FND_API.G_EXC_ERROR;
3808: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3810: END IF;
3811: i := l_line_tbl.next(i);
3812: END LOOP;
3813:

Line 3974: , p_init_msg_list => FND_API.G_TRUE

3970: l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3971:
3972: OE_ORDER_PVT.Process_order
3973: ( p_api_version_number => 1.0
3974: , p_init_msg_list => FND_API.G_TRUE
3975: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3976: , x_return_status => l_return_status
3977: , x_msg_count => l_msg_count
3978: , x_msg_data => l_msg_data

Line 3975: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

3971:
3972: OE_ORDER_PVT.Process_order
3973: ( p_api_version_number => 1.0
3974: , p_init_msg_list => FND_API.G_TRUE
3975: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3976: , x_return_status => l_return_status
3977: , x_msg_count => l_msg_count
3978: , x_msg_data => l_msg_data
3979: , p_control_rec => l_control_rec

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

3994: , p_x_Line_Adj_Att_tbl => l_Line_Adj_Att_tbl
3995: , p_x_Line_Adj_Assoc_tbl => l_Line_Adj_Assoc_tbl
3996: );
3997:
3998: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3999: oe_debug_pub.add('Deleted Header:'||l_retrobill_header_rec.header_id);
4000: l_headers_processed := l_headers_processed+1;
4001: END IF;
4002: ELSE