327: l_user_id NUMBER;
328: l_server_id NUMBER;
329: l_request_id NUMBER;
330: l_subject VARCHAR2(100);
331: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
332: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
333: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
334:
335: --
328: l_server_id NUMBER;
329: l_request_id NUMBER;
330: l_subject VARCHAR2(100);
331: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
332: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
333: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
334:
335: --
336: l_msg_count NUMBER;
329: l_request_id NUMBER;
330: l_subject VARCHAR2(100);
331: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
332: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
333: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
334:
335: --
336: l_msg_count NUMBER;
337: l_msg_data VARCHAR2(1000);
437:
438: -- Start the fulfillment request. The output request_id must be passed
439: -- to all subsequent calls made for this request.
440:
441: JTF_FM_REQUEST_GRP.Start_Request
442: (
443: p_api_version => l_api_version,
444: x_return_status => l_return_status,
445: x_msg_count => l_msg_count,
479:
480:
481: -- This call gets the XML string for the content(Master Document) with
482: -- the parameters as defined above
483: JTF_FM_REQUEST_GRP.Get_Content_XML
484: (
485: p_api_version => l_api_version,
486: x_return_status => l_return_status,
487: x_msg_count => l_msg_count,
531: -- Initialize Parameters for submitting the fulfillment request
532:
533: l_user_id := p_user_id;
534: -- Submit the fulfillment request
535: JTF_FM_REQUEST_GRP.Submit_Request
536: (p_api_version => l_api_version,
537: p_commit => l_commit,
538: x_return_status => l_return_status,
539: x_msg_count => l_msg_count,
608: p_encoded => FND_API.G_FALSE);
609: x_msg_data := l_msg_data;
610: end loop;
611: end if;
612: JTF_FM_REQUEST_GRP.Cancel_Request
613: (p_api_version => l_api_version,
614: p_commit => l_commit,
615: p_init_msg_list => FND_API.G_FALSE,
616: x_return_status => l_return_status,
631: x_msg_data := l_msg_data;
632: end loop;
633: end if;
634:
635: JTF_FM_REQUEST_GRP.Cancel_Request
636: (p_api_version => l_api_version,
637: p_commit => l_commit,
638: p_init_msg_list => FND_API.G_FALSE,
639: x_return_status => l_return_status,
655: x_msg_data := l_msg_data;
656: end loop;
657: end if;
658: -- cancel the request just sent
659: JTF_FM_REQUEST_GRP.Cancel_Request
660: (p_api_version => l_api_version,
661: p_commit => l_commit,
662: p_init_msg_list => FND_API.G_FALSE,
663: x_return_status => l_return_status,
719: l_server_id NUMBER;
720: l_request_id NUMBER;
721: l_subject VARCHAR2(100);
722: l_list_type VARCHAR2(100);
723: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
724: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
725: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
726:
727: --
720: l_request_id NUMBER;
721: l_subject VARCHAR2(100);
722: l_list_type VARCHAR2(100);
723: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
724: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
725: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
726:
727: --
728: l_msg_count NUMBER;
721: l_subject VARCHAR2(100);
722: l_list_type VARCHAR2(100);
723: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
724: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
725: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
726:
727: --
728: l_msg_count NUMBER;
729: l_msg_data VARCHAR2(1000);
731: l_content_xml1 VARCHAR2(1000);
732: l_content_xml VARCHAR2(10000);
733: l_content_nm VARCHAR2(100);
734:
735: l_mass_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
732: l_content_xml VARCHAR2(10000);
733: l_content_nm VARCHAR2(100);
734:
735: l_mass_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
733: l_content_nm VARCHAR2(100);
734:
735: l_mass_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
734:
735: l_mass_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
735: l_mass_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
744: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
744: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
745:
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
744: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
745:
746: l_content_no NUMBER;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
744: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
745:
746: l_content_no NUMBER;
747: l_content_type NUMBER;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
744: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
745:
746: l_content_no NUMBER;
747: l_content_type NUMBER;
748: l_content_type_text VARCHAR2(30);
836: end if;
837:
838: -- Start the fulfillment request. The output request_id must be passed
839: -- to all subsequent calls made for this request.
840: JTF_FM_REQUEST_GRP.Start_Request
841: (
842: p_api_version => l_api_version,
843: x_return_status => l_return_status,
844: x_msg_count => l_msg_count,
881: l_user_note := ' ';
882:
883: -- This call gets the XML string for the content(Master Document) with
884: -- the parameters as defined above
885: JTF_FM_REQUEST_GRP.Get_Content_XML
886: (
887: p_api_version => l_api_version,
888: x_return_status => l_return_status,
889: x_msg_count => l_msg_count,
937: */
938: l_user_id := p_user_id;
939: -- Submit the fulfillment request
940:
941: JTF_FM_REQUEST_GRP.Submit_Mass_Request
942: ( p_api_version =>l_api_version,
943: p_init_msg_list=> FND_API.G_TRUE,
944: p_commit =>FND_API.G_FALSE,
945: p_validation_level=>FND_API.G_VALID_LEVEL_FULL,
1024: FND_MSG_PUB.Count_And_Get
1025: (p_count => x_msg_count ,
1026: p_data => x_msg_data
1027: );
1028: JTF_FM_REQUEST_GRP.Cancel_Request
1029: (p_api_version => l_api_version,
1030: p_commit => l_commit,
1031: p_init_msg_list => FND_API.G_FALSE,
1032: x_return_status => l_return_status,
1053: fnd_file.put_line(fnd_file.log, l_msg_data);
1054: end loop;
1055: end if;
1056: fnd_file.put_line(fnd_file.log, SQLERRM);
1057: JTF_FM_REQUEST_GRP.Cancel_Request
1058: (p_api_version => l_api_version,
1059: p_commit => l_commit,
1060: p_init_msg_list => FND_API.G_FALSE,
1061: x_return_status => l_return_status,
1085: end if;
1086: fnd_file.put_line(fnd_file.log, SQLERRM);
1087:
1088: -- cancel the request just sent
1089: JTF_FM_REQUEST_GRP.Cancel_Request
1090: (p_api_version => l_api_version,
1091: p_commit => l_commit,
1092: p_init_msg_list => FND_API.G_FALSE,
1093: x_return_status => l_return_status,