APPS.OE_INVOICE_PUB dependencies on FND_MESSAGE

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

698: ELSE
699: IF l_debug_level > 0 THEN
700: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
701: END IF;
702: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
703: OE_MSG_PUB.ADD;
704: RAISE NO_DATA_FOUND;
705: END IF;
706: end commenting for bug# 5032978 */

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

851: x_msg_data => l_hold_msg_data);
852: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
853: l_hold_result_out = FND_API.G_TRUE )
854: THEN
855: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
856: OE_MSG_PUB.ADD;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: IF l_debug_level > 0 THEN
859: oe_debug_pub.add( 'A Line level Invoicing hold or generic hold found ( 1 ) , Return status : '||X_RETURN_STATUS , 1 ) ;

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

874:
875: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
876: l_hold_result_out = FND_API.G_TRUE )
877: THEN
878: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
879: OE_MSG_PUB.ADD;
880: x_return_status := FND_API.G_RET_STS_ERROR;
881: IF l_debug_level > 0 THEN
882: oe_debug_pub.add( 'A Header level Invoicing hold or generic hold found ( 2 ) , Return status '||X_RETURN_STATUS , 1 ) ;

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

2349: -- Issue Message here. (overshipment above tolerance should be invoiced manually)
2350: IF l_debug_level > 0 THEN
2351: oe_debug_pub.add( 'QUANTITY TO INVOICE AT ( 4 ) = ' || TO_CHAR ( X_REGULAR_QTY_TO_INVOICE ) , 5 ) ;
2352: END IF;
2353: FND_MESSAGE.SET_NAME('ONT','OE_MANUAL_INVOICE_OVERSHIP_QTY');
2354: OE_MSG_PUB.ADD;
2355: IF l_debug_level > 0 THEN
2356: oe_debug_pub.add( 'EXIT CALCUALTE_QTY_TO_INVOICE ( 4 ) : '||X_REGULAR_QTY_TO_INVOICE , 5 ) ;
2357: END IF;

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

2612: oe_debug_pub.add( 'VALIDATING REQUIRED ATTRIBUTES' , 5 ) ;
2613: END IF;
2614: -- Check For all Required Attributes
2615: IF p_interface_line_rec.Batch_Source_Name IS NULL THEN
2616: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Batch_Source_Name');
2618: OE_MSG_PUB.ADD;
2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( 'REQUIRED ATTRIBUTE BATCH SOURCE NAME IS MISSING' , 1 ) ;

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

2613: END IF;
2614: -- Check For all Required Attributes
2615: IF p_interface_line_rec.Batch_Source_Name IS NULL THEN
2616: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Batch_Source_Name');
2618: OE_MSG_PUB.ADD;
2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( 'REQUIRED ATTRIBUTE BATCH SOURCE NAME IS MISSING' , 1 ) ;
2621: END IF;

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

2620: oe_debug_pub.add( 'REQUIRED ATTRIBUTE BATCH SOURCE NAME IS MISSING' , 1 ) ;
2621: END IF;
2622: RETURN FALSE;
2623: ELSIF p_interface_line_rec.Set_Of_Books_Id IS NULL THEN
2624: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2625: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Set_Of_Books_Id');
2626: OE_MSG_PUB.ADD;
2627: IF l_debug_level > 0 THEN
2628: oe_debug_pub.add( 'REQUIRED ATTRIBUTE SET OF BOOKS ID IS MISSING ' , 1 ) ;

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

2621: END IF;
2622: RETURN FALSE;
2623: ELSIF p_interface_line_rec.Set_Of_Books_Id IS NULL THEN
2624: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2625: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Set_Of_Books_Id');
2626: OE_MSG_PUB.ADD;
2627: IF l_debug_level > 0 THEN
2628: oe_debug_pub.add( 'REQUIRED ATTRIBUTE SET OF BOOKS ID IS MISSING ' , 1 ) ;
2629: END IF;

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

2628: oe_debug_pub.add( 'REQUIRED ATTRIBUTE SET OF BOOKS ID IS MISSING ' , 1 ) ;
2629: END IF;
2630: RETURN FALSE;
2631: ELSIF p_interface_line_rec.Line_Type IS NULL THEN
2632: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2633: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Line_Type');
2634: OE_MSG_PUB.ADD;
2635: IF l_debug_level > 0 THEN
2636: oe_debug_pub.add( 'REQUIRED ATTRIBUTE LINE TYPE IS MISSING' , 1 ) ;

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

2629: END IF;
2630: RETURN FALSE;
2631: ELSIF p_interface_line_rec.Line_Type IS NULL THEN
2632: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2633: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Line_Type');
2634: OE_MSG_PUB.ADD;
2635: IF l_debug_level > 0 THEN
2636: oe_debug_pub.add( 'REQUIRED ATTRIBUTE LINE TYPE IS MISSING' , 1 ) ;
2637: END IF;

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

2636: oe_debug_pub.add( 'REQUIRED ATTRIBUTE LINE TYPE IS MISSING' , 1 ) ;
2637: END IF;
2638: RETURN FALSE;
2639: ELSIF p_interface_line_rec.Description IS NULL THEN
2640: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2641: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Description');
2642: OE_MSG_PUB.ADD;
2643: IF l_debug_level > 0 THEN
2644: oe_debug_pub.add( 'REQUIRED ATTRIBUTE DESCRIPTION IS MISSING' , 1 ) ;

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

2637: END IF;
2638: RETURN FALSE;
2639: ELSIF p_interface_line_rec.Description IS NULL THEN
2640: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2641: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Description');
2642: OE_MSG_PUB.ADD;
2643: IF l_debug_level > 0 THEN
2644: oe_debug_pub.add( 'REQUIRED ATTRIBUTE DESCRIPTION IS MISSING' , 1 ) ;
2645: END IF;

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

2644: oe_debug_pub.add( 'REQUIRED ATTRIBUTE DESCRIPTION IS MISSING' , 1 ) ;
2645: END IF;
2646: RETURN FALSE;
2647: ELSIF p_interface_line_rec.Currency_Code IS NULL THEN
2648: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Currency_Code');
2650: OE_MSG_PUB.ADD;
2651: IF l_debug_level > 0 THEN
2652: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CURRENCY CODE IS MISSING' , 1 ) ;

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

2645: END IF;
2646: RETURN FALSE;
2647: ELSIF p_interface_line_rec.Currency_Code IS NULL THEN
2648: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Currency_Code');
2650: OE_MSG_PUB.ADD;
2651: IF l_debug_level > 0 THEN
2652: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CURRENCY CODE IS MISSING' , 1 ) ;
2653: END IF;

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

2652: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CURRENCY CODE IS MISSING' , 1 ) ;
2653: END IF;
2654: RETURN FALSE;
2655: ELSIF p_interface_line_rec.Conversion_Type IS NULL THEN
2656: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2657: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Conversion_Type');
2658: OE_MSG_PUB.ADD;
2659: IF l_debug_level > 0 THEN
2660: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CONVERSION TYPE IS MISSING' , 1 ) ;

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

2653: END IF;
2654: RETURN FALSE;
2655: ELSIF p_interface_line_rec.Conversion_Type IS NULL THEN
2656: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2657: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Conversion_Type');
2658: OE_MSG_PUB.ADD;
2659: IF l_debug_level > 0 THEN
2660: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CONVERSION TYPE IS MISSING' , 1 ) ;
2661: END IF;

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

2662: RETURN FALSE;
2663: ELSIF p_line_rec.commitment_id IS NULL AND
2664: (p_interface_line_rec.Cust_Trx_Type_Id IS NULL OR
2665: p_interface_line_rec.Cust_Trx_Type_Id = 0) THEN
2666: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2667: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Cust_Trx_Type_Id');
2668: OE_MSG_PUB.ADD;
2669: IF l_debug_level > 0 THEN
2670: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CUSTOMER TRX TYPE ID IS MISSING' , 1 ) ;

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

2663: ELSIF p_line_rec.commitment_id IS NULL AND
2664: (p_interface_line_rec.Cust_Trx_Type_Id IS NULL OR
2665: p_interface_line_rec.Cust_Trx_Type_Id = 0) THEN
2666: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2667: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Cust_Trx_Type_Id');
2668: OE_MSG_PUB.ADD;
2669: IF l_debug_level > 0 THEN
2670: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CUSTOMER TRX TYPE ID IS MISSING' , 1 ) ;
2671: END IF;

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

2676: oe_debug_pub.add( 'REQUIRED ATTRIBUTE ACCOUNTING RULE DURATION IS MISSING' , 1 ) ;
2677: END IF;
2678: RETURN FALSE;
2679: ELSIF p_interface_line_rec.customer_bank_account_id = -1 THEN
2680: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
2681: OE_MSG_PUB.ADD;
2682: IF l_debug_level > 0 THEN
2683: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CUSTOMER CREDIT CARD BANK ACCOUNT IS MISSING' , 1 ) ;
2684: END IF;

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

2684: END IF;
2685: RETURN FALSE;
2686: ELSIF p_interface_line_rec.customer_bank_account_id > 0
2687: AND p_interface_line_rec.receipt_method_id IS NULL THEN
2688: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAY_METHOD');
2689: OE_MSG_PUB.ADD;
2690: IF l_debug_level > 0 THEN
2691: oe_debug_pub.add( 'REQUIRED ATTRIBUTE PAYMENT METHOD IS MISSING' , 1 ) ;
2692: END IF;

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

2692: END IF;
2693: RETURN FALSE;
2694: -- bug 8494362 start
2695: ELSIF p_interface_line_rec.INTERFACE_LINE_CONTEXT IS NULL THEN
2696: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2697: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Interface Line Context');
2698: OE_MSG_PUB.ADD;
2699: IF l_debug_level > 0 THEN
2700: oe_debug_pub.add( 'REQUIRED ATTRIBUTE INTERFACE_LINE_CONTEXT IS MISSING' , 1 ) ;

Line 2697: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Interface Line Context');

2693: RETURN FALSE;
2694: -- bug 8494362 start
2695: ELSIF p_interface_line_rec.INTERFACE_LINE_CONTEXT IS NULL THEN
2696: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2697: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Interface Line Context');
2698: OE_MSG_PUB.ADD;
2699: IF l_debug_level > 0 THEN
2700: oe_debug_pub.add( 'REQUIRED ATTRIBUTE INTERFACE_LINE_CONTEXT IS MISSING' , 1 ) ;
2701: END IF;

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

5194:
5195: EXCEPTION
5196: WHEN NO_DATA_FOUND THEN
5197: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
5198: FND_MESSAGE.SET_NAME('ONT','ONT_FREIGHT_ITEM_REQUIRED');
5199: OE_MSG_PUB.ADD;
5200: END IF;
5201:
5202: RAISE FND_API.G_EXC_ERROR;

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

6903: --p_x_interface_line_rec.rule_end_date := p_line_rec.service_end_date;
6904: IF p_x_interface_line_rec.accounting_rule_duration IS NULL THEN
6905: IF p_line_rec.service_start_date IS NULL OR p_line_rec.service_end_date IS NULL THEN
6906: -- bug# 4190312 post message and complete with status INCOMPLETE
6907: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ACCT_RULE_DURATION');
6908: OE_MSG_PUB.ADD;
6909: IF l_debug_level > 0 THEN
6910: oe_debug_pub.add( 'SERVICE START DATE OR SERVICE END DATE IS NULL' , 3 ) ;
6911: END IF;

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

6951: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := l_acct_rule_duration;
6952: ELSE
6953: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6954: -- post message
6955: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6956: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6957: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6958: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6959: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);

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

6952: ELSE
6953: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6954: -- post message
6955: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6956: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6957: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6958: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6959: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6960: OE_MSG_PUB.ADD;

Line 6957: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165

6953: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6954: -- post message
6955: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6956: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6957: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6958: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6959: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6960: OE_MSG_PUB.ADD;
6961: IF l_debug_level > 0 THEN

Line 6958: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));

6954: -- post message
6955: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6956: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6957: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6958: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6959: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6960: OE_MSG_PUB.ADD;
6961: IF l_debug_level > 0 THEN
6962: 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 6959: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);

6955: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6956: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6957: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6958: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6959: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6960: OE_MSG_PUB.ADD;
6961: IF l_debug_level > 0 THEN
6962: oe_debug_pub.add('Atleast one or more dates ('||l_unmapped_date||') within the date range that are not associated with any adjustment period.');
6963: END IF;

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

6965: EXCEPTION
6966: WHEN OTHERS THEN
6967: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6968: -- Modified for bug# 4190312
6969: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6970: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6971: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6972: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6973: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);

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

6966: WHEN OTHERS THEN
6967: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6968: -- Modified for bug# 4190312
6969: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6970: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6971: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6972: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6973: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6974: OE_MSG_PUB.ADD;

Line 6971: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165

6967: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;
6968: -- Modified for bug# 4190312
6969: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6970: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6971: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6972: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6973: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6974: OE_MSG_PUB.ADD;
6975: IF l_debug_level > 0 THEN

Line 6972: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));

6968: -- Modified for bug# 4190312
6969: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6970: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6971: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6972: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6973: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6974: OE_MSG_PUB.ADD;
6975: IF l_debug_level > 0 THEN
6976: oe_debug_pub.add( 'ERROR IN GL_CALENDAR_PKG.Get_Num_Periods_In_Date_Range ; ERROR => '||SQLERRM , 1 ) ;

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

6969: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6970: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6971: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6972: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6973: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6974: OE_MSG_PUB.ADD;
6975: IF l_debug_level > 0 THEN
6976: oe_debug_pub.add( 'ERROR IN GL_CALENDAR_PKG.Get_Num_Periods_In_Date_Range ; ERROR => '||SQLERRM , 1 ) ;
6977: END IF;

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

7177: END;
7178: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
7179: l_parent_line_id := l_order_line_id;
7180: ELSE
7181: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
7182: OE_MSG_PUB.ADD;
7183: END IF;
7184: ELSE -- not a customer product
7185: l_parent_line_id := p_line_rec.service_reference_line_id;

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

8260: END IF;
8261: OPEN cur_get_del_id(this_del_name);
8262: FETCH cur_get_del_id Into this_del_id;
8263: IF (cur_get_del_id%NOTFOUND ) THEN
8264: fnd_message.set_token('DELIVERY_NAME', this_del_name);
8265: fnd_message.set_name('OE', 'WSH_AR_INVALID_DEL_NAME');
8266: err_msg := fnd_message.get;
8267: IF l_debug_level > 0 THEN
8268: oe_debug_pub.add( ERR_MSG ) ;

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

8261: OPEN cur_get_del_id(this_del_name);
8262: FETCH cur_get_del_id Into this_del_id;
8263: IF (cur_get_del_id%NOTFOUND ) THEN
8264: fnd_message.set_token('DELIVERY_NAME', this_del_name);
8265: fnd_message.set_name('OE', 'WSH_AR_INVALID_DEL_NAME');
8266: err_msg := fnd_message.get;
8267: IF l_debug_level > 0 THEN
8268: oe_debug_pub.add( ERR_MSG ) ;
8269: END IF;

Line 8266: err_msg := fnd_message.get;

8262: FETCH cur_get_del_id Into this_del_id;
8263: IF (cur_get_del_id%NOTFOUND ) THEN
8264: fnd_message.set_token('DELIVERY_NAME', this_del_name);
8265: fnd_message.set_name('OE', 'WSH_AR_INVALID_DEL_NAME');
8266: err_msg := fnd_message.get;
8267: IF l_debug_level > 0 THEN
8268: oe_debug_pub.add( ERR_MSG ) ;
8269: END IF;
8270: CLOSE cur_get_del_id;

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

8615: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;
8616: END IF;
8617: --Customer Acceptance
8618: IF l_line_rejected AND p_line_rec.line_category_code = 'RETURN' THEN
8619: FND_MESSAGE.SET_NAME('ONT','ONT_RMA_NO_CREDIT');
8620: OE_MSG_PUB.ADD;
8621: END IF;
8622: --Customer Acceptance
8623: RETURN;

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

8645: ,p_x_interface_line_rec
8646: ,'RFR-PENDING'
8647: ,x_return_status);
8648: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8649: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
8650: OE_MSG_PUB.ADD;
8651: END IF;
8652: END IF;
8653: IF l_debug_level > 0 THEN

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

8768: ,p_x_interface_line_rec
8769: ,'RFR-PENDING'
8770: ,x_return_status);
8771: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8772: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
8773: OE_MSG_PUB.ADD;
8774: END IF;
8775: ELSE
8776: Update_Invoice_Attributes(p_line_rec

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

9006: END IF;
9007: x_return_status := FND_API.G_RET_STS_ERROR;
9008: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
9009: l_line_rec.line_id := null;
9010: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
9011: OE_MSG_PUB.Add;
9012: RAISE FND_API.G_EXC_ERROR;
9013: */
9014:

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

9023: ROLLBACK TO INVOICE_INTERFACE;
9024: END IF;
9025: x_result_out := NULL;
9026: x_return_status := 'DEFERRED';
9027: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
9028: OE_MSG_PUB.Add;
9029: RETURN;
9030: --- bug# 7600960 : end
9031:

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

9445: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;
9446: END IF;
9447: --Customer Acceptance
9448: IF l_line_rejected AND l_line_rec.line_category_code = 'RETURN' THEN
9449: FND_MESSAGE.SET_NAME('ONT','ONT_RMA_NO_CREDIT');
9450: OE_MSG_PUB.ADD;
9451: END IF;
9452: --Customer Acceptance
9453: RETURN;

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

9631: INTO l_delivery_name
9632: FROM wsh_new_deliveries dl
9633: WHERE dl.delivery_id = l_delivery_line_id;
9634: END IF;
9635: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_DELIVERY');
9636: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);
9637: OE_MSG_PUB.ADD;
9638: END IF;
9639: IF l_debug_level > 0 THEN

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

9632: FROM wsh_new_deliveries dl
9633: WHERE dl.delivery_id = l_delivery_line_id;
9634: END IF;
9635: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_DELIVERY');
9636: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);
9637: OE_MSG_PUB.ADD;
9638: END IF;
9639: IF l_debug_level > 0 THEN
9640: oe_debug_pub.add( 'INTERFACE STATUS : '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;

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

9801: ,l_interface_line_rec
9802: ,'RFR-PENDING'
9803: ,x_return_status);
9804: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
9805: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
9806: OE_MSG_PUB.ADD;
9807: END IF;
9808: IF l_debug_level > 0 THEN
9809: oe_debug_pub.add( 'RFR: L_LINE_REC.INTERFACE_STATUS '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;