DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on FND_MESSAGE

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

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

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

1227: IF l_debug_level > 0 THEN
1228: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_HEADERS_INTERFACE' ) ;
1229: END IF;
1230: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1231: fnd_message.set_token ('TABLE', 'oe_headers_interface');
1232: oe_msg_pub.add;
1233: End;
1234:
1235:

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

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

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

1279: IF l_debug_level > 0 THEN
1280: oe_debug_pub.add( 'OEXPACKB: OTHERS IN SELECT FROM OE_ORDER_HEADERS' ) ;
1281: END IF;
1282: fnd_message.set_name ('ONT', 'OE_OI_ACK_DATA_NOT_FOUND');
1283: fnd_message.set_token ('TABLE', 'oe_order_headers');
1284: oe_msg_pub.add;
1285: End;
1286:
1287: End If;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1687: END IF;
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: -- start bug 3711152
1690: -- fnd_message.set_name ('ONT', 'OE_OI_TP_NOT_FOUND');
1691: -- fnd_message.set_token ('CUST_ID', p_customer_id);
1692: -- oe_msg_pub.add;
1693: -- end bug 3711152
1694: WHEN OTHERS THEN
1695: IF l_debug_level > 0 THEN

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

3220: END IF;
3221:
3222: IF l_message_text IS NULL THEN
3223: IF l_processing_stage = 'IMPORT_SUCCESS' THEN
3224: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_SUCCESS_GEN');
3225: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN
3226: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_FAILURE');
3227: END IF;
3228: l_txn_token := Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_subtype);

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

3222: IF l_message_text IS NULL THEN
3223: IF l_processing_stage = 'IMPORT_SUCCESS' THEN
3224: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_SUCCESS_GEN');
3225: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN
3226: fnd_message.set_name ('ONT', 'OE_OI_IMPORT_FAILURE');
3227: END IF;
3228: l_txn_token := Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_subtype);
3229:
3230: If l_txn_token IS NOT NULL Then

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

3227: END IF;
3228: l_txn_token := Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_subtype);
3229:
3230: If l_txn_token IS NOT NULL Then
3231: fnd_message.set_token ('TRANSACTION',l_txn_token || ' -');
3232: Else
3233: fnd_message.set_token ('TRANSACTION', '');
3234: End If;
3235: l_message_text := fnd_message.get;

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

3229:
3230: If l_txn_token IS NOT NULL Then
3231: fnd_message.set_token ('TRANSACTION',l_txn_token || ' -');
3232: Else
3233: fnd_message.set_token ('TRANSACTION', '');
3234: End If;
3235: l_message_text := fnd_message.get;
3236: END IF;
3237:

Line 3235: l_message_text := fnd_message.get;

3231: fnd_message.set_token ('TRANSACTION',l_txn_token || ' -');
3232: Else
3233: fnd_message.set_token ('TRANSACTION', '');
3234: End If;
3235: l_message_text := fnd_message.get;
3236: END IF;
3237:
3238: END IF; -- end of branch on subscriber list
3239:

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

3884: ELSE -- columns does not match and quantity <> 0
3885: IF l_debug_level > 0 THEN
3886: oe_debug_pub.add( '3A8 response received, columns does not match and qty <> 0, Raise an error', 3 ) ;
3887: END IF;
3888: FND_MESSAGE.SET_NAME('ONT', 'ONT_3A8_RESPONSE_COL_MISMATCH');
3889: OE_MSG_PUB.Add;
3890: RAISE FND_API.G_EXC_ERROR;
3891: END IF; -- check for columns
3892: END IF; -- check for independent/response 3A8