DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_WF dependencies on FND_MESSAGE

Line 934: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');

930: oe_debug_pub.add( 'SELECT OF THE DATA FAILED FOR THE DOCUMENT' ) ;
931: oe_debug_pub.add( 'L_PARTY_ID in when no data found => ' || L_PARTY_ID ) ;
932: END IF;
933: if l_order_imported = G_WFR_INCOMPLETE Then
934: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
935: fnd_message.set_token ('OPT_TABLE', 'in oe_headers_interface');
936: fnd_message.set_token ('DOC_ID', l_orig_sys_document_ref);
937: oe_msg_pub.add;
938: else

Line 935: fnd_message.set_token ('OPT_TABLE', 'in oe_headers_interface');

931: oe_debug_pub.add( 'L_PARTY_ID in when no data found => ' || L_PARTY_ID ) ;
932: END IF;
933: if l_order_imported = G_WFR_INCOMPLETE Then
934: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
935: fnd_message.set_token ('OPT_TABLE', 'in oe_headers_interface');
936: fnd_message.set_token ('DOC_ID', l_orig_sys_document_ref);
937: oe_msg_pub.add;
938: else
939: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');

Line 936: fnd_message.set_token ('DOC_ID', l_orig_sys_document_ref);

932: END IF;
933: if l_order_imported = G_WFR_INCOMPLETE Then
934: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
935: fnd_message.set_token ('OPT_TABLE', 'in oe_headers_interface');
936: fnd_message.set_token ('DOC_ID', l_orig_sys_document_ref);
937: oe_msg_pub.add;
938: else
939: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
940: fnd_message.set_token ('OPT_TABLE', 'in oe_order_headers');

Line 939: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');

935: fnd_message.set_token ('OPT_TABLE', 'in oe_headers_interface');
936: fnd_message.set_token ('DOC_ID', l_orig_sys_document_ref);
937: oe_msg_pub.add;
938: else
939: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
940: fnd_message.set_token ('OPT_TABLE', 'in oe_order_headers');
941: fnd_message.set_token ('DOC_ID', l_header_id);
942: oe_msg_pub.add;
943: end if;

Line 940: fnd_message.set_token ('OPT_TABLE', 'in oe_order_headers');

936: fnd_message.set_token ('DOC_ID', l_orig_sys_document_ref);
937: oe_msg_pub.add;
938: else
939: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
940: fnd_message.set_token ('OPT_TABLE', 'in oe_order_headers');
941: fnd_message.set_token ('DOC_ID', l_header_id);
942: oe_msg_pub.add;
943: end if;
944: null;

Line 941: fnd_message.set_token ('DOC_ID', l_header_id);

937: oe_msg_pub.add;
938: else
939: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
940: fnd_message.set_token ('OPT_TABLE', 'in oe_order_headers');
941: fnd_message.set_token ('DOC_ID', l_header_id);
942: oe_msg_pub.add;
943: end if;
944: null;
945: End;

Line 1095: fnd_message.set_name ('ONT', 'OE_OI_CUST_SITE_NOT_FOUND');

1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
1093: p_x_result := 'COMPLETE:ERROR';
1094: p_x_result := FND_API.G_RET_STS_ERROR;
1095: fnd_message.set_name ('ONT', 'OE_OI_CUST_SITE_NOT_FOUND');
1096: fnd_message.set_token ('CUST_ID', l_party_id);
1097: oe_msg_pub.add;
1098: OE_STANDARD_WF.Save_Messages;
1099: OE_STANDARD_WF.Clear_Msg_Context;

Line 1096: fnd_message.set_token ('CUST_ID', l_party_id);

1092: WHEN NO_DATA_FOUND THEN
1093: p_x_result := 'COMPLETE:ERROR';
1094: p_x_result := FND_API.G_RET_STS_ERROR;
1095: fnd_message.set_name ('ONT', 'OE_OI_CUST_SITE_NOT_FOUND');
1096: fnd_message.set_token ('CUST_ID', l_party_id);
1097: oe_msg_pub.add;
1098: OE_STANDARD_WF.Save_Messages;
1099: OE_STANDARD_WF.Clear_Msg_Context;
1100: WHEN OTHERS THEN

Line 1336: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');

1332: p_x_result := FND_API.G_RET_STS_ERROR;
1333: ELSE
1334: p_x_result := 'N';
1335: END IF;
1336: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
1337: fnd_message.set_token ('OPT_TABLE', '');
1338: fnd_message.set_token ('DOC_ID', nvl(l_orig_sys_document_ref,p_itemkey));
1339: oe_msg_pub.add;
1340: OE_STANDARD_WF.Save_Messages;

Line 1337: fnd_message.set_token ('OPT_TABLE', '');

1333: ELSE
1334: p_x_result := 'N';
1335: END IF;
1336: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
1337: fnd_message.set_token ('OPT_TABLE', '');
1338: fnd_message.set_token ('DOC_ID', nvl(l_orig_sys_document_ref,p_itemkey));
1339: oe_msg_pub.add;
1340: OE_STANDARD_WF.Save_Messages;
1341: OE_STANDARD_WF.Clear_Msg_Context;

Line 1338: fnd_message.set_token ('DOC_ID', nvl(l_orig_sys_document_ref,p_itemkey));

1334: p_x_result := 'N';
1335: END IF;
1336: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
1337: fnd_message.set_token ('OPT_TABLE', '');
1338: fnd_message.set_token ('DOC_ID', nvl(l_orig_sys_document_ref,p_itemkey));
1339: oe_msg_pub.add;
1340: OE_STANDARD_WF.Save_Messages;
1341: OE_STANDARD_WF.Clear_Msg_Context;
1342: WHEN OTHERS THEN

Line 2573: fnd_message.set_name('ONT', 'OE_OI_IFACE');

2569: TRUE);
2570: -- by setting the last argument to TRUE, we ensure that no error is thrown if the attr is not found
2571:
2572: IF l_processing_stage = 'INBOUND_IFACE' THEN
2573: fnd_message.set_name('ONT', 'OE_OI_IFACE');
2574:
2575: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2576: l_message_text := fnd_message.get;
2577: l_doc_status := 'ACTIVE';

Line 2575: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');

2571:
2572: IF l_processing_stage = 'INBOUND_IFACE' THEN
2573: fnd_message.set_name('ONT', 'OE_OI_IFACE');
2574:
2575: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2576: l_message_text := fnd_message.get;
2577: l_doc_status := 'ACTIVE';
2578: ELSIF l_processing_stage = 'PRE_IMPORT' THEN
2579:

Line 2576: l_message_text := fnd_message.get;

2572: IF l_processing_stage = 'INBOUND_IFACE' THEN
2573: fnd_message.set_name('ONT', 'OE_OI_IFACE');
2574:
2575: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2576: l_message_text := fnd_message.get;
2577: l_doc_status := 'ACTIVE';
2578: ELSIF l_processing_stage = 'PRE_IMPORT' THEN
2579:
2580: If l_import_mode = 'ASYNCHRONOUS' Then

Line 2581: fnd_message.set_name('ONT', 'OE_OI_IMPORT_MODE_ASYNC');

2577: l_doc_status := 'ACTIVE';
2578: ELSIF l_processing_stage = 'PRE_IMPORT' THEN
2579:
2580: If l_import_mode = 'ASYNCHRONOUS' Then
2581: fnd_message.set_name('ONT', 'OE_OI_IMPORT_MODE_ASYNC');
2582: Elsif l_import_mode = 'SYNCHRONOUS' Then
2583: fnd_message.set_name('ONT', 'OE_OI_IMPORT_MODE_SYNC');
2584: End If;
2585:

Line 2583: fnd_message.set_name('ONT', 'OE_OI_IMPORT_MODE_SYNC');

2579:
2580: If l_import_mode = 'ASYNCHRONOUS' Then
2581: fnd_message.set_name('ONT', 'OE_OI_IMPORT_MODE_ASYNC');
2582: Elsif l_import_mode = 'SYNCHRONOUS' Then
2583: fnd_message.set_name('ONT', 'OE_OI_IMPORT_MODE_SYNC');
2584: End If;
2585:
2586: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2587:

Line 2586: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');

2582: Elsif l_import_mode = 'SYNCHRONOUS' Then
2583: fnd_message.set_name('ONT', 'OE_OI_IMPORT_MODE_SYNC');
2584: End If;
2585:
2586: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2587:
2588: l_message_text := fnd_message.get;
2589: l_doc_status := 'ACTIVE';
2590:

Line 2588: l_message_text := fnd_message.get;

2584: End If;
2585:
2586: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2587:
2588: l_message_text := fnd_message.get;
2589: l_doc_status := 'ACTIVE';
2590:
2591: ELSIF l_processing_stage = 'IMPORT_SUCCESS' THEN
2592: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) Then

Line 2593: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL');

2589: l_doc_status := 'ACTIVE';
2590:
2591: ELSIF l_processing_stage = 'IMPORT_SUCCESS' THEN
2592: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) Then
2593: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL');
2594:
2595: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) Then
2596: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CPO');
2597:

Line 2596: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CPO');

2592: If (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POI) Then
2593: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL');
2594:
2595: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) Then
2596: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CPO');
2597:
2598: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) Then
2599: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CHO');
2600: End if;

Line 2599: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CHO');

2595: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CPO) Then
2596: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CPO');
2597:
2598: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CHO) Then
2599: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CHO');
2600: End if;
2601: l_doc_status := 'SUCCESS';
2602: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN
2603: fnd_message.set_name('ONT', 'OE_OI_IMPORT_FAILURE');

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

2599: l_message_text := fnd_message.get_string('ONT', 'OE_OI_IMPORT_SUCCESSFUL_CHO');
2600: End if;
2601: l_doc_status := 'SUCCESS';
2602: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN
2603: fnd_message.set_name('ONT', 'OE_OI_IMPORT_FAILURE');
2604: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2605:
2606: l_message_text := fnd_message.get;
2607: l_doc_status := 'ERROR';

Line 2604: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');

2600: End if;
2601: l_doc_status := 'SUCCESS';
2602: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN
2603: fnd_message.set_name('ONT', 'OE_OI_IMPORT_FAILURE');
2604: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2605:
2606: l_message_text := fnd_message.get;
2607: l_doc_status := 'ERROR';
2608: ELSIF l_processing_stage = 'OUTBOUND_SENT' THEN

Line 2606: l_message_text := fnd_message.get;

2602: ELSIF l_processing_stage = 'IMPORT_FAILURE' THEN
2603: fnd_message.set_name('ONT', 'OE_OI_IMPORT_FAILURE');
2604: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2605:
2606: l_message_text := fnd_message.get;
2607: l_doc_status := 'ERROR';
2608: ELSIF l_processing_stage = 'OUTBOUND_SENT' THEN
2609:
2610: l_setup_status := wf_engine.GetActivityAttrText (p_itemtype,

Line 2625: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');

2621: Exception
2622: When Others Then
2623: null;
2624: End;
2625: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2626: fnd_message.set_token ('TRANSACTION', l_standard_desc);
2627: l_message_text := fnd_message.get;
2628: Else
2629: IF (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA) Then

Line 2626: fnd_message.set_token ('TRANSACTION', l_standard_desc);

2622: When Others Then
2623: null;
2624: End;
2625: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2626: fnd_message.set_token ('TRANSACTION', l_standard_desc);
2627: l_message_text := fnd_message.get;
2628: Else
2629: IF (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA) Then
2630: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');

Line 2627: l_message_text := fnd_message.get;

2623: null;
2624: End;
2625: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2626: fnd_message.set_token ('TRANSACTION', l_standard_desc);
2627: l_message_text := fnd_message.get;
2628: Else
2629: IF (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA) Then
2630: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2631: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));

Line 2630: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');

2626: fnd_message.set_token ('TRANSACTION', l_standard_desc);
2627: l_message_text := fnd_message.get;
2628: Else
2629: IF (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA) Then
2630: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2631: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2632:
2633: l_message_text := fnd_message.get;
2634: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO) Then --SSO

Line 2631: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));

2627: l_message_text := fnd_message.get;
2628: Else
2629: IF (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA) Then
2630: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2631: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2632:
2633: l_message_text := fnd_message.get;
2634: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO) Then --SSO
2635:

Line 2633: l_message_text := fnd_message.get;

2629: IF (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA) Then
2630: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2631: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2632:
2633: l_message_text := fnd_message.get;
2634: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO) Then --SSO
2635:
2636: l_message_text := fnd_message.get_string('ONT', 'OE_SO_SHOW_SO_SENT');
2637: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO) Then --CSO

Line 2636: l_message_text := fnd_message.get_string('ONT', 'OE_SO_SHOW_SO_SENT');

2632:
2633: l_message_text := fnd_message.get;
2634: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO) Then --SSO
2635:
2636: l_message_text := fnd_message.get_string('ONT', 'OE_SO_SHOW_SO_SENT');
2637: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO) Then --CSO
2638: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2639: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2640:

Line 2638: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');

2634: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_SSO) Then --SSO
2635:
2636: l_message_text := fnd_message.get_string('ONT', 'OE_SO_SHOW_SO_SENT');
2637: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO) Then --CSO
2638: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2639: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2640:
2641: l_message_text := fnd_message.get;
2642: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO) Then --CBODO

Line 2639: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));

2635:
2636: l_message_text := fnd_message.get_string('ONT', 'OE_SO_SHOW_SO_SENT');
2637: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO) Then --CSO
2638: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2639: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2640:
2641: l_message_text := fnd_message.get;
2642: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO) Then --CBODO
2643: fnd_message.set_name ('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');

Line 2641: l_message_text := fnd_message.get;

2637: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CSO) Then --CSO
2638: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2639: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2640:
2641: l_message_text := fnd_message.get;
2642: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO) Then --CBODO
2643: fnd_message.set_name ('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2644: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2645:

Line 2643: fnd_message.set_name ('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');

2639: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2640:
2641: l_message_text := fnd_message.get;
2642: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO) Then --CBODO
2643: fnd_message.set_name ('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2644: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2645:
2646: l_message_text := fnd_message.get;
2647: End If;

Line 2644: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));

2640:
2641: l_message_text := fnd_message.get;
2642: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO) Then --CBODO
2643: fnd_message.set_name ('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2644: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2645:
2646: l_message_text := fnd_message.get;
2647: End If;
2648: End If;

Line 2646: l_message_text := fnd_message.get;

2642: Elsif (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_CBODO) Then --CBODO
2643: fnd_message.set_name ('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2644: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2645:
2646: l_message_text := fnd_message.get;
2647: End If;
2648: End If;
2649: l_doc_status := 'SUCCESS';
2650: ELSIF l_processing_stage = 'OUTBOUND_SETUP' THEN

Line 2658: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_SETUP');

2654: p_actid,
2655: 'PROCESSING_STATUS',
2656: TRUE);
2657: IF l_setup_status = 'SUCCESS' THEN
2658: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_SETUP');
2659: l_doc_status := 'ACTIVE';
2660: ELSIF l_setup_status = 'ERROR' THEN
2661: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_SETUP_ERR');
2662: l_doc_status := 'ERROR';

Line 2661: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_SETUP_ERR');

2657: IF l_setup_status = 'SUCCESS' THEN
2658: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_SETUP');
2659: l_doc_status := 'ACTIVE';
2660: ELSIF l_setup_status = 'ERROR' THEN
2661: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_SETUP_ERR');
2662: l_doc_status := 'ERROR';
2663: END IF;
2664: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2665:

Line 2664: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');

2660: ELSIF l_setup_status = 'ERROR' THEN
2661: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_SETUP_ERR');
2662: l_doc_status := 'ERROR';
2663: END IF;
2664: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2665:
2666: l_message_text := fnd_message.get;
2667:
2668: ELSIF l_processing_stage = 'OUTBOUND_TRIGGERED' THEN

Line 2666: l_message_text := fnd_message.get;

2662: l_doc_status := 'ERROR';
2663: END IF;
2664: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type)|| ' -');
2665:
2666: l_message_text := fnd_message.get;
2667:
2668: ELSIF l_processing_stage = 'OUTBOUND_TRIGGERED' THEN
2669: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_TRIGGERED');
2670: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));

Line 2669: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_TRIGGERED');

2665:
2666: l_message_text := fnd_message.get;
2667:
2668: ELSIF l_processing_stage = 'OUTBOUND_TRIGGERED' THEN
2669: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_TRIGGERED');
2670: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2671:
2672: l_message_text := fnd_message.get;
2673:

Line 2670: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));

2666: l_message_text := fnd_message.get;
2667:
2668: ELSIF l_processing_stage = 'OUTBOUND_TRIGGERED' THEN
2669: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_TRIGGERED');
2670: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2671:
2672: l_message_text := fnd_message.get;
2673:
2674: l_doc_status := 'ACTIVE';

Line 2672: l_message_text := fnd_message.get;

2668: ELSIF l_processing_stage = 'OUTBOUND_TRIGGERED' THEN
2669: fnd_message.set_name('ONT', 'OE_OI_OUTBOUND_TRIGGERED');
2670: fnd_message.set_token ('TRANSACTION', Oe_Acknowledgment_Pub.EM_Transaction_Type (p_txn_code => l_transaction_type));
2671:
2672: l_message_text := fnd_message.get;
2673:
2674: l_doc_status := 'ACTIVE';
2675: END IF;
2676: