DBA Data[Home] [Help]

APPS.JTF_FM_OCM_REND_REQ dependencies on JTF_FM_REQUEST_GRP

Line 52: p_party_id IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ,

48:
49:
50: PROCEDURE GET_TEST_XML
51: (
52: p_party_id IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ,
53: p_email IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
54: p_fax IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
55: p_printer IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
56: p_media IN VARCHAR2,

Line 53: p_email IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,

49:
50: PROCEDURE GET_TEST_XML
51: (
52: p_party_id IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ,
53: p_email IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
54: p_fax IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
55: p_printer IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
56: p_media IN VARCHAR2,
57: p_content_xml IN VARCHAR2,

Line 54: p_fax IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,

50: PROCEDURE GET_TEST_XML
51: (
52: p_party_id IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ,
53: p_email IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
54: p_fax IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
55: p_printer IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
56: p_media IN VARCHAR2,
57: p_content_xml IN VARCHAR2,
58: x_return_status OUT NOCOPY VARCHAR2,

Line 55: p_printer IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,

51: (
52: p_party_id IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ,
53: p_email IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
54: p_fax IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
55: p_printer IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
56: p_media IN VARCHAR2,
57: p_content_xml IN VARCHAR2,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_test_xml OUT NOCOPY VARCHAR2

Line 890: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');

886: );
887: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
888:
889: for i in 0..x_msg_count loop
890: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');
891:
892: end loop;
893:
894:

Line 1051: 'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');

1047: IF l_req_count > 0 THEN
1048:
1049: JTF_FM_UTL_V.PRINT_MESSAGE('IT IS A TEST REQUEST: THE COUNT IS ' ||
1050: l_req_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1051: 'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');
1052:
1053: -- This is a test request, so the next thing to determine is if there
1054: -- was a version passed into the call. If so, we use it, othewise
1055: -- we need to determine what the version is so we can find the FND_LOBS

Line 1400: 'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');

1396: for i in 0..x_msg_count loop
1397:
1398: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),
1399: JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1400: 'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');
1401:
1402: end loop;
1403:
1404: END GET_OCM_REND_DETAILS;

Line 1424: p_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,

1420: p_media_type IN VARCHAR2,
1421: p_printer IN VARCHAR2 ,
1422: p_email IN VARCHAR2 ,
1423: p_fax IN VARCHAR2 ,
1424: p_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
1425: p_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
1426: p_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
1427: p_request_id IN NUMBER,
1428: x_content_xml OUT NOCOPY VARCHAR2,

Line 1425: p_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,

1421: p_printer IN VARCHAR2 ,
1422: p_email IN VARCHAR2 ,
1423: p_fax IN VARCHAR2 ,
1424: p_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
1425: p_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
1426: p_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
1427: p_request_id IN NUMBER,
1428: x_content_xml OUT NOCOPY VARCHAR2,
1429: p_version IN NUMBER,

Line 1426: p_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,

1422: p_email IN VARCHAR2 ,
1423: p_fax IN VARCHAR2 ,
1424: p_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
1425: p_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
1426: p_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
1427: p_request_id IN NUMBER,
1428: x_content_xml OUT NOCOPY VARCHAR2,
1429: p_version IN NUMBER,
1430: p_email_format IN VARCHAR2

Line 1665: ||JTF_FM_REQUEST_GRP.REPLACE_TAG(p_bind_var_type(i));

1661: l_message := l_message||' '||a;
1662: FOR i IN 1..p_bind_var.count LOOP
1663:
1664: l_message := l_message||' '
1668: ||JTF_FM_REQUEST_GRP.REPLACE_TAG(p_bind_val(i))||'
'||a;
1669:

Line 1667: ||JTF_FM_REQUEST_GRP.REPLACE_TAG(p_bind_var(i))||'" > '

1663:
1664: l_message := l_message||' '
1668: ||JTF_FM_REQUEST_GRP.REPLACE_TAG(p_bind_val(i))||'
'||a;
1669:
1670: END LOOP; -- FOR i IN
1671: l_message := l_message||' '||a;

Line 1668: ||JTF_FM_REQUEST_GRP.REPLACE_TAG(p_bind_val(i))||''||a;

1664: l_message := l_message||' '
1668: ||JTF_FM_REQUEST_GRP.REPLACE_TAG(p_bind_val(i))||'
'||a;
1669:
1670: END LOOP; -- FOR i IN
1671: l_message := l_message||' '||a;
1672: l_message := l_message||' '||a;

Line 1789: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

1785: l_init_msg_list VARCHAR2(2) := FND_API.G_FALSE;
1786: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1787: l_content_xml VARCHAR2(32767);
1788: l_content_xml1 VARCHAR2(32767);
1789: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1790: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1791: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1792: l_content_id NUMBER;
1793: l_per_user_history VARCHAR2(2);

Line 1790: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

1786: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1787: l_content_xml VARCHAR2(32767);
1788: l_content_xml1 VARCHAR2(32767);
1789: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1790: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1791: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1792: l_content_id NUMBER;
1793: l_per_user_history VARCHAR2(2);
1794: l_subject VARCHAR2(255);

Line 1791: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

1787: l_content_xml VARCHAR2(32767);
1788: l_content_xml1 VARCHAR2(32767);
1789: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1790: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1791: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1792: l_content_id NUMBER;
1793: l_per_user_history VARCHAR2(2);
1794: l_subject VARCHAR2(255);
1795: l_quantity NUMBER := 1;

Line 1900: l_bind_var := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;

1896: ELSIF (IS_REQ_ETSL(p_fulfill_electronic_rec.request_type)) THEN
1897:
1898:
1899: x_return_status := FND_API.G_RET_STS_SUCCESS;
1900: l_bind_var := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
1901: l_bind_val := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
1902: l_bind_var_type := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
1903:
1904: IF LENGTH(p_fulfill_electronic_rec.media_types) >3 THEN

Line 1901: l_bind_val := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;

1897:
1898:
1899: x_return_status := FND_API.G_RET_STS_SUCCESS;
1900: l_bind_var := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
1901: l_bind_val := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
1902: l_bind_var_type := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
1903:
1904: IF LENGTH(p_fulfill_electronic_rec.media_types) >3 THEN
1905: l_Error_Msg := null;

Line 1902: l_bind_var_type := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;

1898:
1899: x_return_status := FND_API.G_RET_STS_SUCCESS;
1900: l_bind_var := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
1901: l_bind_val := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
1902: l_bind_var_type := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
1903:
1904: IF LENGTH(p_fulfill_electronic_rec.media_types) >3 THEN
1905: l_Error_Msg := null;
1906: l_Error_Msg := 'Invalid media type specified. Only allowed values are ';

Line 1998: JTF_FM_REQUEST_GRP.start_request

1994: internally three apis are called
1995: start request is called first
1996: **/
1997:
1998: JTF_FM_REQUEST_GRP.start_request
1999: (
2000: p_api_version => l_api_version,
2001: p_init_msg_list => l_init_msg_list,
2002: x_return_status => x_return_status,