DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on FND_MESSAGE

Line 1225: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');

1221: -- Code here to raise error as not able to find the orig_sys_document_ref
1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_HEADERS_INTERFACE' ) ;
1224: END IF;
1225: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1226: fnd_message.set_token ('TABLE', 'oe_headers_interface');
1227: oe_msg_pub.add;
1228: End;
1229:

Line 1226: fnd_message.set_token ('TABLE', 'oe_headers_interface');

1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_HEADERS_INTERFACE' ) ;
1224: END IF;
1225: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1226: fnd_message.set_token ('TABLE', 'oe_headers_interface');
1227: oe_msg_pub.add;
1228: End;
1229:
1230:

Line 1277: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');

1273: -- Code here to raise error as not able to find the header id
1274: IF l_debug_level > 0 THEN
1275: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_ORDER_HEADERS' ) ;
1276: END IF;
1277: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1278: fnd_message.set_token ('TABLE', 'oe_order_headers');
1279: oe_msg_pub.add;
1280: End;
1281:

Line 1278: fnd_message.set_token ('TABLE', 'oe_order_headers');

1274: IF l_debug_level > 0 THEN
1275: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_ORDER_HEADERS' ) ;
1276: END IF;
1277: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1278: fnd_message.set_token ('TABLE', 'oe_order_headers');
1279: oe_msg_pub.add;
1280: End;
1281:
1282: End If;

Line 1347: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');

1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;
1344: IF l_debug_level > 0 THEN
1345: oe_debug_pub.add( 'QUERY FROM OE_ORDER_HEADERS_ALL TABLE FAILED. ACK. NOT SEND: ' || sqlerrm) ;
1346: END IF;
1347: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1348: fnd_message.set_token ('TABLE', 'oe_order_headers');
1349: oe_msg_pub.add;
1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1351: --RETURN;

Line 1348: fnd_message.set_token ('TABLE', 'oe_order_headers');

1344: IF l_debug_level > 0 THEN
1345: oe_debug_pub.add( 'QUERY FROM OE_ORDER_HEADERS_ALL TABLE FAILED. ACK. NOT SEND: ' || sqlerrm) ;
1346: END IF;
1347: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1348: fnd_message.set_token ('TABLE', 'oe_order_headers');
1349: oe_msg_pub.add;
1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1351: --RETURN;
1352: End;

Line 1443: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');

1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --FND_API.G_RET_STS_SUCCESS;
1440: IF l_debug_level > 0 THEN
1441: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1442: END IF;
1443: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1444: fnd_message.set_token ('TABLE', 'oe_order_lines');
1445: oe_msg_pub.add;
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: --RETURN;

Line 1444: fnd_message.set_token ('TABLE', 'oe_order_lines');

1440: IF l_debug_level > 0 THEN
1441: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1442: END IF;
1443: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1444: fnd_message.set_token ('TABLE', 'oe_order_lines');
1445: oe_msg_pub.add;
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: --RETURN;
1448: End;

Line 1505: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');

1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;--FND_API.G_RET_STS_SUCCESS;
1502: IF l_debug_level > 0 THEN
1503: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1504: END IF;
1505: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1506: fnd_message.set_token ('TABLE', 'oe_order_lines');
1507: oe_msg_pub.add;
1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1509: --RETURN;

Line 1506: fnd_message.set_token ('TABLE', 'oe_order_lines');

1502: IF l_debug_level > 0 THEN
1503: oe_debug_pub.add( 'QUERY FROM OE_ORDER_LINES_ALL TABLE FAILED. ACK. NOT SEND' ) ;
1504: END IF;
1505: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1506: fnd_message.set_token ('TABLE', 'oe_order_lines');
1507: oe_msg_pub.add;
1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1509: --RETURN;
1510: End;

Line 1685: -- fnd_message.set_name ('ONT', 'OE_OI_TP_NOT_FOUND');

1681: oe_debug_pub.add( 'OEXPACKB: EXITING IS_DELIVERY_REQUIRED WITH NO_DATA_FOUND' ) ;
1682: END IF;
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1684: -- start bug 3711152
1685: -- fnd_message.set_name ('ONT', 'OE_OI_TP_NOT_FOUND');
1686: -- fnd_message.set_token ('CUST_ID', p_customer_id);
1687: -- oe_msg_pub.add;
1688: -- end bug 3711152
1689: WHEN OTHERS THEN

Line 1686: -- fnd_message.set_token ('CUST_ID', p_customer_id);

1682: END IF;
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1684: -- start bug 3711152
1685: -- fnd_message.set_name ('ONT', 'OE_OI_TP_NOT_FOUND');
1686: -- fnd_message.set_token ('CUST_ID', p_customer_id);
1687: -- oe_msg_pub.add;
1688: -- end bug 3711152
1689: WHEN OTHERS THEN
1690: IF l_debug_level > 0 THEN

Line 3108: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_SUCCESS_GEN');

3104: END IF;
3105:
3106: IF l_message_text IS NULL THEN
3107: IF l_processing_stage = 'IMPORT_SUCCESS' THEN
3108: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_SUCCESS_GEN');
3109: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN
3110: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_FAILURE');
3111: END IF;
3112: l_txn_token := Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_subtype);

Line 3110: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_FAILURE');

3106: IF l_message_text IS NULL THEN
3107: IF l_processing_stage = 'IMPORT_SUCCESS' THEN
3108: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_SUCCESS_GEN');
3109: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN
3110: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_FAILURE');
3111: END IF;
3112: l_txn_token := Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_subtype);
3113:
3114: If l_txn_token IS NOT NULL Then

Line 3115: fnd_message.set_token ('TRANSACTION',l_txn_token || ' -');

3111: END IF;
3112: l_txn_token := Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_subtype);
3113:
3114: If l_txn_token IS NOT NULL Then
3115: fnd_message.set_token ('TRANSACTION',l_txn_token || ' -');
3116: Else
3117: fnd_message.set_token ('TRANSACTION', '');
3118: End If;
3119: l_message_text := fnd_message.get;

Line 3117: fnd_message.set_token ('TRANSACTION', '');

3113:
3114: If l_txn_token IS NOT NULL Then
3115: fnd_message.set_token ('TRANSACTION',l_txn_token || ' -');
3116: Else
3117: fnd_message.set_token ('TRANSACTION', '');
3118: End If;
3119: l_message_text := fnd_message.get;
3120: END IF;
3121:

Line 3119: l_message_text := fnd_message.get;

3115: fnd_message.set_token ('TRANSACTION',l_txn_token || ' -');
3116: Else
3117: fnd_message.set_token ('TRANSACTION', '');
3118: End If;
3119: l_message_text := fnd_message.get;
3120: END IF;
3121:
3122: END IF; -- end of branch on subscriber list
3123:

Line 3772: FND_MESSAGE.SET_NAME('ONT', 'ONT_3A8_RESPONSE_COL_MISMATCH');

3768: ELSE -- columns does not match and quantity <> 0
3769: IF l_debug_level > 0 THEN
3770: oe_debug_pub.add( '3A8 response received, columns does not match and qty <> 0, Raise an error', 3 ) ;
3771: END IF;
3772: FND_MESSAGE.SET_NAME('ONT', 'ONT_3A8_RESPONSE_COL_MISMATCH');
3773: OE_MSG_PUB.Add;
3774: RAISE FND_API.G_EXC_ERROR;
3775: END IF; -- check for columns
3776: END IF; -- check for independent/response 3A8