DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on FND_MESSAGE

Line 496: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');

492: ELSE
493: IF l_debug_level > 0 THEN
494: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
495: END IF;
496: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
497: OE_MSG_PUB.ADD;
498: RAISE NO_DATA_FOUND;
499: END IF;
500: end commenting for bug# 5032978 */

Line 649: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');

645: x_msg_data => l_hold_msg_data);
646: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
647: l_hold_result_out = FND_API.G_TRUE )
648: THEN
649: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
650: OE_MSG_PUB.ADD;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'A Line level Invoicing hold or generic hold found ( 1 ) , Return status : '||X_RETURN_STATUS , 1 ) ;

Line 672: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');

668:
669: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
670: l_hold_result_out = FND_API.G_TRUE )
671: THEN
672: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
673: OE_MSG_PUB.ADD;
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: IF l_debug_level > 0 THEN
676: oe_debug_pub.add( 'A Header level Invoicing hold or generic hold found ( 2 ) , Return status '||X_RETURN_STATUS , 1 ) ;

Line 2136: FND_MESSAGE.SET_NAME('ONT','OE_MANUAL_INVOICE_OVERSHIP_QTY');

2132: -- Issue Message here. (overshipment above tolerance should be invoiced manually)
2133: IF l_debug_level > 0 THEN
2134: oe_debug_pub.add( 'QUANTITY TO INVOICE AT ( 4 ) = ' || TO_CHAR ( X_REGULAR_QTY_TO_INVOICE ) , 5 ) ;
2135: END IF;
2136: FND_MESSAGE.SET_NAME('ONT','OE_MANUAL_INVOICE_OVERSHIP_QTY');
2137: OE_MSG_PUB.ADD;
2138: IF l_debug_level > 0 THEN
2139: oe_debug_pub.add( 'EXIT CALCUALTE_QTY_TO_INVOICE ( 4 ) : '||X_REGULAR_QTY_TO_INVOICE , 5 ) ;
2140: END IF;

Line 2399: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');

2395: oe_debug_pub.add( 'VALIDATING REQUIRED ATTRIBUTES' , 5 ) ;
2396: END IF;
2397: -- Check For all Required Attributes
2398: IF p_interface_line_rec.Batch_Source_Name IS NULL THEN
2399: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Batch_Source_Name');
2401: OE_MSG_PUB.ADD;
2402: IF l_debug_level > 0 THEN
2403: oe_debug_pub.add( 'REQUIRED ATTRIBUTE BATCH SOURCE NAME IS MISSING' , 1 ) ;

Line 2400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Batch_Source_Name');

2396: END IF;
2397: -- Check For all Required Attributes
2398: IF p_interface_line_rec.Batch_Source_Name IS NULL THEN
2399: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Batch_Source_Name');
2401: OE_MSG_PUB.ADD;
2402: IF l_debug_level > 0 THEN
2403: oe_debug_pub.add( 'REQUIRED ATTRIBUTE BATCH SOURCE NAME IS MISSING' , 1 ) ;
2404: END IF;

Line 2407: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');

2403: oe_debug_pub.add( 'REQUIRED ATTRIBUTE BATCH SOURCE NAME IS MISSING' , 1 ) ;
2404: END IF;
2405: RETURN FALSE;
2406: ELSIF p_interface_line_rec.Set_Of_Books_Id IS NULL THEN
2407: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Set_Of_Books_Id');
2409: OE_MSG_PUB.ADD;
2410: IF l_debug_level > 0 THEN
2411: oe_debug_pub.add( 'REQUIRED ATTRIBUTE SET OF BOOKS ID IS MISSING ' , 1 ) ;

Line 2408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Set_Of_Books_Id');

2404: END IF;
2405: RETURN FALSE;
2406: ELSIF p_interface_line_rec.Set_Of_Books_Id IS NULL THEN
2407: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Set_Of_Books_Id');
2409: OE_MSG_PUB.ADD;
2410: IF l_debug_level > 0 THEN
2411: oe_debug_pub.add( 'REQUIRED ATTRIBUTE SET OF BOOKS ID IS MISSING ' , 1 ) ;
2412: END IF;

Line 2415: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');

2411: oe_debug_pub.add( 'REQUIRED ATTRIBUTE SET OF BOOKS ID IS MISSING ' , 1 ) ;
2412: END IF;
2413: RETURN FALSE;
2414: ELSIF p_interface_line_rec.Line_Type IS NULL THEN
2415: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2416: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Line_Type');
2417: OE_MSG_PUB.ADD;
2418: IF l_debug_level > 0 THEN
2419: oe_debug_pub.add( 'REQUIRED ATTRIBUTE LINE TYPE IS MISSING' , 1 ) ;

Line 2416: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Line_Type');

2412: END IF;
2413: RETURN FALSE;
2414: ELSIF p_interface_line_rec.Line_Type IS NULL THEN
2415: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2416: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Line_Type');
2417: OE_MSG_PUB.ADD;
2418: IF l_debug_level > 0 THEN
2419: oe_debug_pub.add( 'REQUIRED ATTRIBUTE LINE TYPE IS MISSING' , 1 ) ;
2420: END IF;

Line 2423: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');

2419: oe_debug_pub.add( 'REQUIRED ATTRIBUTE LINE TYPE IS MISSING' , 1 ) ;
2420: END IF;
2421: RETURN FALSE;
2422: ELSIF p_interface_line_rec.Description IS NULL THEN
2423: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Description');
2425: OE_MSG_PUB.ADD;
2426: IF l_debug_level > 0 THEN
2427: oe_debug_pub.add( 'REQUIRED ATTRIBUTE DESCRIPTION IS MISSING' , 1 ) ;

Line 2424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Description');

2420: END IF;
2421: RETURN FALSE;
2422: ELSIF p_interface_line_rec.Description IS NULL THEN
2423: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Description');
2425: OE_MSG_PUB.ADD;
2426: IF l_debug_level > 0 THEN
2427: oe_debug_pub.add( 'REQUIRED ATTRIBUTE DESCRIPTION IS MISSING' , 1 ) ;
2428: END IF;

Line 2431: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');

2427: oe_debug_pub.add( 'REQUIRED ATTRIBUTE DESCRIPTION IS MISSING' , 1 ) ;
2428: END IF;
2429: RETURN FALSE;
2430: ELSIF p_interface_line_rec.Currency_Code IS NULL THEN
2431: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2432: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Currency_Code');
2433: OE_MSG_PUB.ADD;
2434: IF l_debug_level > 0 THEN
2435: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CURRENCY CODE IS MISSING' , 1 ) ;

Line 2432: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Currency_Code');

2428: END IF;
2429: RETURN FALSE;
2430: ELSIF p_interface_line_rec.Currency_Code IS NULL THEN
2431: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2432: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Currency_Code');
2433: OE_MSG_PUB.ADD;
2434: IF l_debug_level > 0 THEN
2435: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CURRENCY CODE IS MISSING' , 1 ) ;
2436: END IF;

Line 2439: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');

2435: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CURRENCY CODE IS MISSING' , 1 ) ;
2436: END IF;
2437: RETURN FALSE;
2438: ELSIF p_interface_line_rec.Conversion_Type IS NULL THEN
2439: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Conversion_Type');
2441: OE_MSG_PUB.ADD;
2442: IF l_debug_level > 0 THEN
2443: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CONVERSION TYPE IS MISSING' , 1 ) ;

Line 2440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Conversion_Type');

2436: END IF;
2437: RETURN FALSE;
2438: ELSIF p_interface_line_rec.Conversion_Type IS NULL THEN
2439: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Conversion_Type');
2441: OE_MSG_PUB.ADD;
2442: IF l_debug_level > 0 THEN
2443: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CONVERSION TYPE IS MISSING' , 1 ) ;
2444: END IF;

Line 2449: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');

2445: RETURN FALSE;
2446: ELSIF p_line_rec.commitment_id IS NULL AND
2447: (p_interface_line_rec.Cust_Trx_Type_Id IS NULL OR
2448: p_interface_line_rec.Cust_Trx_Type_Id = 0) THEN
2449: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Cust_Trx_Type_Id');
2451: OE_MSG_PUB.ADD;
2452: IF l_debug_level > 0 THEN
2453: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CUSTOMER TRX TYPE ID IS MISSING' , 1 ) ;

Line 2450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Cust_Trx_Type_Id');

2446: ELSIF p_line_rec.commitment_id IS NULL AND
2447: (p_interface_line_rec.Cust_Trx_Type_Id IS NULL OR
2448: p_interface_line_rec.Cust_Trx_Type_Id = 0) THEN
2449: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Cust_Trx_Type_Id');
2451: OE_MSG_PUB.ADD;
2452: IF l_debug_level > 0 THEN
2453: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CUSTOMER TRX TYPE ID IS MISSING' , 1 ) ;
2454: END IF;

Line 2463: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');

2459: oe_debug_pub.add( 'REQUIRED ATTRIBUTE ACCOUNTING RULE DURATION IS MISSING' , 1 ) ;
2460: END IF;
2461: RETURN FALSE;
2462: ELSIF p_interface_line_rec.customer_bank_account_id = -1 THEN
2463: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
2464: OE_MSG_PUB.ADD;
2465: IF l_debug_level > 0 THEN
2466: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CUSTOMER CREDIT CARD BANK ACCOUNT IS MISSING' , 1 ) ;
2467: END IF;

Line 2471: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAY_METHOD');

2467: END IF;
2468: RETURN FALSE;
2469: ELSIF p_interface_line_rec.customer_bank_account_id > 0
2470: AND p_interface_line_rec.receipt_method_id IS NULL THEN
2471: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAY_METHOD');
2472: OE_MSG_PUB.ADD;
2473: IF l_debug_level > 0 THEN
2474: oe_debug_pub.add( 'REQUIRED ATTRIBUTE PAYMENT METHOD IS MISSING' , 1 ) ;
2475: END IF;

Line 4967: FND_MESSAGE.SET_NAME('ONT','ONT_FREIGHT_ITEM_REQUIRED');

4963:
4964: EXCEPTION
4965: WHEN NO_DATA_FOUND THEN
4966: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4967: FND_MESSAGE.SET_NAME('ONT','ONT_FREIGHT_ITEM_REQUIRED');
4968: OE_MSG_PUB.ADD;
4969: END IF;
4970:
4971: RAISE FND_API.G_EXC_ERROR;

Line 6634: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ACCT_RULE_DURATION');

6630: --p_x_interface_line_rec.rule_end_date := p_line_rec.service_end_date;
6631: IF p_x_interface_line_rec.accounting_rule_duration IS NULL THEN
6632: IF p_line_rec.service_start_date IS NULL OR p_line_rec.service_end_date IS NULL THEN
6633: -- bug# 4190312 post message and complete with status INCOMPLETE
6634: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ACCT_RULE_DURATION');
6635: OE_MSG_PUB.ADD;
6636: IF l_debug_level > 0 THEN
6637: oe_debug_pub.add( 'SERVICE START DATE OR SERVICE END DATE IS NULL' , 3 ) ;
6638: END IF;

Line 6674: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');

6670: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := l_acct_rule_duration;
6671: ELSE
6672: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6673: -- post message
6674: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6675: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6676: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);
6677: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name); OE_MSG_PUB.ADD;
6678: IF l_debug_level > 0 THEN

Line 6675: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);

6671: ELSE
6672: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6673: -- post message
6674: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6675: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6676: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);
6677: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name); OE_MSG_PUB.ADD;
6678: IF l_debug_level > 0 THEN
6679: oe_debug_pub.add('Atleast one or more dates ('||l_unmapped_date||') within the date range that are not associated with any adjustment period.');

Line 6676: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);

6672: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6673: -- post message
6674: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6675: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6676: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);
6677: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name); OE_MSG_PUB.ADD;
6678: IF l_debug_level > 0 THEN
6679: oe_debug_pub.add('Atleast one or more dates ('||l_unmapped_date||') within the date range that are not associated with any adjustment period.');
6680: END IF;

Line 6677: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name); OE_MSG_PUB.ADD;

6673: -- post message
6674: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6675: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6676: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);
6677: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name); OE_MSG_PUB.ADD;
6678: IF l_debug_level > 0 THEN
6679: oe_debug_pub.add('Atleast one or more dates ('||l_unmapped_date||') within the date range that are not associated with any adjustment period.');
6680: END IF;
6681: END IF;

Line 6686: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');

6682: EXCEPTION
6683: WHEN OTHERS THEN
6684: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6685: -- Modified for bug# 4190312
6686: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6687: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6688: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);
6689: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6690: OE_MSG_PUB.ADD;

Line 6687: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);

6683: WHEN OTHERS THEN
6684: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6685: -- Modified for bug# 4190312
6686: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6687: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6688: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);
6689: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6690: OE_MSG_PUB.ADD;
6691: IF l_debug_level > 0 THEN

Line 6688: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);

6684: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6685: -- Modified for bug# 4190312
6686: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6687: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6688: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);
6689: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6690: OE_MSG_PUB.ADD;
6691: IF l_debug_level > 0 THEN
6692: oe_debug_pub.add( 'ERROR IN GL_CALENDAR_PKG.Get_Num_Periods_In_Date_Range ; ERROR => '||SQLERRM , 1 ) ;

Line 6689: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);

6685: -- Modified for bug# 4190312
6686: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6687: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6688: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);
6689: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6690: OE_MSG_PUB.ADD;
6691: IF l_debug_level > 0 THEN
6692: oe_debug_pub.add( 'ERROR IN GL_CALENDAR_PKG.Get_Num_Periods_In_Date_Range ; ERROR => '||SQLERRM , 1 ) ;
6693: END IF;

Line 6896: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');

6892: END;
6893: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6894: l_parent_line_id := l_order_line_id;
6895: ELSE
6896: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
6897: OE_MSG_PUB.ADD;
6898: END IF;
6899: ELSE -- not a customer product
6900: l_parent_line_id := p_line_rec.service_reference_line_id;

Line 7880: fnd_message.set_token('DELIVERY_NAME', this_del_name);

7876: END IF;
7877: OPEN cur_get_del_id(this_del_name);
7878: FETCH cur_get_del_id Into this_del_id;
7879: IF (cur_get_del_id%NOTFOUND ) THEN
7880: fnd_message.set_token('DELIVERY_NAME', this_del_name);
7881: fnd_message.set_name('OE', 'WSH_AR_INVALID_DEL_NAME');
7882: err_msg := fnd_message.get;
7883: IF l_debug_level > 0 THEN
7884: oe_debug_pub.add( ERR_MSG ) ;

Line 7881: fnd_message.set_name('OE', 'WSH_AR_INVALID_DEL_NAME');

7877: OPEN cur_get_del_id(this_del_name);
7878: FETCH cur_get_del_id Into this_del_id;
7879: IF (cur_get_del_id%NOTFOUND ) THEN
7880: fnd_message.set_token('DELIVERY_NAME', this_del_name);
7881: fnd_message.set_name('OE', 'WSH_AR_INVALID_DEL_NAME');
7882: err_msg := fnd_message.get;
7883: IF l_debug_level > 0 THEN
7884: oe_debug_pub.add( ERR_MSG ) ;
7885: END IF;

Line 7882: err_msg := fnd_message.get;

7878: FETCH cur_get_del_id Into this_del_id;
7879: IF (cur_get_del_id%NOTFOUND ) THEN
7880: fnd_message.set_token('DELIVERY_NAME', this_del_name);
7881: fnd_message.set_name('OE', 'WSH_AR_INVALID_DEL_NAME');
7882: err_msg := fnd_message.get;
7883: IF l_debug_level > 0 THEN
7884: oe_debug_pub.add( ERR_MSG ) ;
7885: END IF;
7886: CLOSE cur_get_del_id;

Line 8215: FND_MESSAGE.SET_NAME('ONT','ONT_RMA_NO_CREDIT');

8211: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;
8212: END IF;
8213: --Customer Acceptance
8214: IF l_line_rejected AND p_line_rec.line_category_code = 'RETURN' THEN
8215: FND_MESSAGE.SET_NAME('ONT','ONT_RMA_NO_CREDIT');
8216: OE_MSG_PUB.ADD;
8217: END IF;
8218: --Customer Acceptance
8219: RETURN;

Line 8245: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');

8241: ,p_x_interface_line_rec
8242: ,'RFR-PENDING'
8243: ,x_return_status);
8244: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8245: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
8246: OE_MSG_PUB.ADD;
8247: END IF;
8248: END IF;
8249: IF l_debug_level > 0 THEN

Line 8358: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');

8354: ,p_x_interface_line_rec
8355: ,'RFR-PENDING'
8356: ,x_return_status);
8357: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8358: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
8359: OE_MSG_PUB.ADD;
8360: END IF;
8361: ELSE
8362: Update_Invoice_Attributes(p_line_rec

Line 8590: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');

8586: END IF;
8587: x_return_status := FND_API.G_RET_STS_ERROR;
8588: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
8589: l_line_rec.line_id := null;
8590: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
8591: OE_MSG_PUB.Add;
8592: RAISE FND_API.G_EXC_ERROR;
8593: */
8594:

Line 8607: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');

8603: ROLLBACK TO INVOICE_INTERFACE;
8604: END IF;
8605: x_result_out := NULL;
8606: x_return_status := 'DEFERRED';
8607: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
8608: OE_MSG_PUB.Add;
8609: RETURN;
8610: --- bug# 7600960 : end
8611:

Line 8889: FND_MESSAGE.SET_NAME('ONT','ONT_RMA_NO_CREDIT');

8885: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;
8886: END IF;
8887: --Customer Acceptance
8888: IF l_line_rejected AND l_line_rec.line_category_code = 'RETURN' THEN
8889: FND_MESSAGE.SET_NAME('ONT','ONT_RMA_NO_CREDIT');
8890: OE_MSG_PUB.ADD;
8891: END IF;
8892: --Customer Acceptance
8893: RETURN;

Line 9075: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_DELIVERY');

9071: INTO l_delivery_name
9072: FROM wsh_new_deliveries dl
9073: WHERE dl.delivery_id = l_delivery_line_id;
9074: END IF;
9075: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_DELIVERY');
9076: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);
9077: OE_MSG_PUB.ADD;
9078: END IF;
9079: IF l_debug_level > 0 THEN

Line 9076: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);

9072: FROM wsh_new_deliveries dl
9073: WHERE dl.delivery_id = l_delivery_line_id;
9074: END IF;
9075: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_DELIVERY');
9076: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);
9077: OE_MSG_PUB.ADD;
9078: END IF;
9079: IF l_debug_level > 0 THEN
9080: oe_debug_pub.add( 'INTERFACE STATUS : '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;

Line 9245: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');

9241: ,l_interface_line_rec
9242: ,'RFR-PENDING'
9243: ,x_return_status);
9244: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
9245: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
9246: OE_MSG_PUB.ADD;
9247: END IF;
9248: IF l_debug_level > 0 THEN
9249: oe_debug_pub.add( 'RFR: L_LINE_REC.INTERFACE_STATUS '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;