eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_FM_UTL_V dependencies on JTF_FM_UTL_V

Line 1: PACKAGE BODY JTF_FM_UTL_V AS

1: PACKAGE BODY JTF_FM_UTL_V AS
2: /* $Header: jtfvfmub.pls 120.2.12000000.2 2007/07/02 22:12:31 ahattark ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'jtf.plsql.jtfvfmub.JTF_FM_UTL_V';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtfgfmub.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'jtf.plsql.jtfvfmub.JTF_FM_UTL_V';

1: PACKAGE BODY JTF_FM_UTL_V AS
2: /* $Header: jtfvfmub.pls 120.2.12000000.2 2007/07/02 22:12:31 ahattark ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'jtf.plsql.jtfvfmub.JTF_FM_UTL_V';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtfgfmub.pls';
6: --
7: G_VALID_LEVEL_LOGIN CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
8:

Line 119: JTF_FM_UTL_V.Handle_ERROR('JTF_FM_FILE_NOTFOUND',to_char(p_file_id));

115: END IF;
116: EXCEPTION
117: WHEN NO_DATA_FOUND
118: THEN
119: JTF_FM_UTL_V.Handle_ERROR('JTF_FM_FILE_NOTFOUND',to_char(p_file_id));
120:
121: END Confirm_RTF; -- End Confirm_RTF
122:
123:

Line 160: JTF_FM_UTL_V.Handle_ERROR('JTF_FM_FILE_NOTFOUND',to_char(p_file_id));

156: END IF;
157: EXCEPTION
158: WHEN NO_DATA_FOUND
159: THEN
160: JTF_FM_UTL_V.Handle_ERROR('JTF_FM_FILE_NOTFOUND',to_char(p_file_id));
161:
162: END CONFIRM_PDF; -- End Confirm_RTF
163:
164:

Line 202: JTF_FM_UTL_V.Handle_ERROR('JTF_FM_FILE_NOTFOUND',to_char(p_file_id));

198: END IF;
199: EXCEPTION
200: WHEN NO_DATA_FOUND
201: THEN
202: JTF_FM_UTL_V.Handle_ERROR('JTF_FM_FILE_NOTFOUND',to_char(p_file_id));
203:
204: END CONFIRM_TEXT_HTML; -- End Confirm_TEXT_HTML
205:
206:

Line 640: JTF_FM_UTL_V.PRINT_MESSAGE('p_api_name = ' || p_api_name, JTF_FM_UTL_V.G_LEVEL_ERROR,'JTF_FM_REQUEST_GRP.Add_error_message');

636: ) IS
637: BEGIN
638:
639: -- To Be Developed.
640: JTF_FM_UTL_V.PRINT_MESSAGE('p_api_name = ' || p_api_name, JTF_FM_UTL_V.G_LEVEL_ERROR,'JTF_FM_REQUEST_GRP.Add_error_message');
641: JTF_FM_UTL_V.PRINT_MESSAGE('p_error_msg = ' || p_error_msg, JTF_FM_UTL_V.G_LEVEL_ERROR,'JTF_FM_REQUEST_GRP.Add_error_message');
642: null;
643:
644: END;

Line 641: JTF_FM_UTL_V.PRINT_MESSAGE('p_error_msg = ' || p_error_msg, JTF_FM_UTL_V.G_LEVEL_ERROR,'JTF_FM_REQUEST_GRP.Add_error_message');

637: BEGIN
638:
639: -- To Be Developed.
640: JTF_FM_UTL_V.PRINT_MESSAGE('p_api_name = ' || p_api_name, JTF_FM_UTL_V.G_LEVEL_ERROR,'JTF_FM_REQUEST_GRP.Add_error_message');
641: JTF_FM_UTL_V.PRINT_MESSAGE('p_error_msg = ' || p_error_msg, JTF_FM_UTL_V.G_LEVEL_ERROR,'JTF_FM_REQUEST_GRP.Add_error_message');
642: null;
643:
644: END;
645:

Line 771: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_UNKNOWN_EMAIL_FORMAT',p_string);

767: x_result := 'both';
768: ELSE--anything is passed that is not null(something,htm,....)
769: x_result := p_string;
770: --raise error
771: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_UNKNOWN_EMAIL_FORMAT',p_string);
772: END IF;
773: ELSE-- if it is null
774: x_result := 'none';
775: END IF;

Line 795: JTF_FM_UTL_V.PRINT_MESSAGE('Begin function'||l_full_name || p_string, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

791: l_api_name CONSTANT VARCHAR2(30) := 'IS_FLD_VALID';
792: l_full_name CONSTANT VARCHAR2(100) := G_PKG_NAME || '.' || l_api_name;
793:
794: BEGIN
795: JTF_FM_UTL_V.PRINT_MESSAGE('Begin function'||l_full_name || p_string, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
796:
797: IF(p_string IS NOT NULL AND p_string <> FND_API.G_MISS_CHAR)
798: THEN
799: x_result := true;

Line 802: JTF_FM_UTL_V.PRINT_MESSAGE('Returning false', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

798: THEN
799: x_result := true;
800: ELSE
801: NULL;
802: JTF_FM_UTL_V.PRINT_MESSAGE('Returning false', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
803: END IF;
804:
805: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
806:

Line 805: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

801: NULL;
802: JTF_FM_UTL_V.PRINT_MESSAGE('Returning false', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
803: END IF;
804:
805: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
806:
807: RETURN x_result;
808: END IS_FLD_VALID;
809:

Line 826: JTF_FM_UTL_V.PRINT_MESSAGE('Begin function'||l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

822: l_api_name CONSTANT VARCHAR2(30) := 'IS_FLD_VALID';
823: l_full_name CONSTANT VARCHAR2(100) := G_PKG_NAME || '.' || l_api_name;
824:
825: BEGIN
826: JTF_FM_UTL_V.PRINT_MESSAGE('Begin function'||l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
827: JTF_FM_UTL_V.PRINT_MESSAGE(to_char(p_number), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
828: JTF_FM_UTL_V.PRINT_MESSAGE('G MISS VALUE IS :'||l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
829: JTF_FM_UTL_V.PRINT_MESSAGE(to_char(FND_API.G_MISS_NUM), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
830:

Line 827: JTF_FM_UTL_V.PRINT_MESSAGE(to_char(p_number), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

823: l_full_name CONSTANT VARCHAR2(100) := G_PKG_NAME || '.' || l_api_name;
824:
825: BEGIN
826: JTF_FM_UTL_V.PRINT_MESSAGE('Begin function'||l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
827: JTF_FM_UTL_V.PRINT_MESSAGE(to_char(p_number), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
828: JTF_FM_UTL_V.PRINT_MESSAGE('G MISS VALUE IS :'||l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
829: JTF_FM_UTL_V.PRINT_MESSAGE(to_char(FND_API.G_MISS_NUM), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
830:
831: IF(p_number IS NOT NULL AND p_number <> FND_API.G_MISS_NUM)

Line 828: JTF_FM_UTL_V.PRINT_MESSAGE('G MISS VALUE IS :'||l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

824:
825: BEGIN
826: JTF_FM_UTL_V.PRINT_MESSAGE('Begin function'||l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
827: JTF_FM_UTL_V.PRINT_MESSAGE(to_char(p_number), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
828: JTF_FM_UTL_V.PRINT_MESSAGE('G MISS VALUE IS :'||l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
829: JTF_FM_UTL_V.PRINT_MESSAGE(to_char(FND_API.G_MISS_NUM), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
830:
831: IF(p_number IS NOT NULL AND p_number <> FND_API.G_MISS_NUM)
832: THEN

Line 829: JTF_FM_UTL_V.PRINT_MESSAGE(to_char(FND_API.G_MISS_NUM), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

825: BEGIN
826: JTF_FM_UTL_V.PRINT_MESSAGE('Begin function'||l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
827: JTF_FM_UTL_V.PRINT_MESSAGE(to_char(p_number), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
828: JTF_FM_UTL_V.PRINT_MESSAGE('G MISS VALUE IS :'||l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
829: JTF_FM_UTL_V.PRINT_MESSAGE(to_char(FND_API.G_MISS_NUM), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
830:
831: IF(p_number IS NOT NULL AND p_number <> FND_API.G_MISS_NUM)
832: THEN
833: x_result := true;

Line 836: JTF_FM_UTL_V.PRINT_MESSAGE('Returning false', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

832: THEN
833: x_result := true;
834: ELSE
835: NULL;
836: JTF_FM_UTL_V.PRINT_MESSAGE('Returning false', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
837: END IF;
838:
839: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
840:

Line 839: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

835: NULL;
836: JTF_FM_UTL_V.PRINT_MESSAGE('Returning false', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
837: END IF;
838:
839: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
840:
841: RETURN x_result;
842: END IS_FLD_VALID;
843:

Line 854: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

850: l_full_name CONSTANT varchar2(100) := G_PKG_NAME || '.' || l_api_name;
851:
852: BEGIN
853:
854: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
855:
856: select fnd_profile.value('ICX_CLIENT_IANA_ENCODING') into l_encoding from dual;
857:
858: -- According to bug3764670, the following would never be true

Line 866: JTF_FM_UTL_V.PRINT_MESSAGE('The Encoding for for the environment is ' || l_encoding,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name );

862: -- THEN
863: -- l_encoding := 'eye ess oh dash eight eight five nine dash one';
864: -- END IF;
865:
866: JTF_FM_UTL_V.PRINT_MESSAGE('The Encoding for for the environment is ' || l_encoding,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name );
867: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
868:
869: RETURN l_encoding;
870: END GET_ENCODING;

Line 867: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

863: -- l_encoding := 'eye ess oh dash eight eight five nine dash one';
864: -- END IF;
865:
866: JTF_FM_UTL_V.PRINT_MESSAGE('The Encoding for for the environment is ' || l_encoding,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name );
867: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
868:
869: RETURN l_encoding;
870: END GET_ENCODING;
871:

Line 884: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

880: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
881:
882:
883: BEGIN
884: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
885:
886: --UPDATE JTF_FM_EMAIL_STATSwith the new information
887: INSERT INTO JTF_FM_EMAIL_STATS
888: (

Line 912: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');

908: FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.USER_ID,SYSDATE,
909: 0,
910: 0);
911:
912: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');
913:
914:
915: END INSERT_EMAIL_STATS;
916:

Line 1031: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

1027: l_full_name CONSTANT varchar2(100) := G_PKG_NAME || '.' || l_api_name;
1028:
1029: BEGIN
1030:
1031: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
1032:
1033: p_dtd := ' 1034: p_dtd := p_dtd||' encoding="' || l_enc || '" standalone="no" ?>'||a;
1035: p_dtd := p_dtd||'

Line 1121: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

1117: p_dtd := p_dtd||''||a;
1118:
1119: p_dtd := p_dtd||' ]>'||a;
1120:
1121: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
1122: END Get_Dtd;
1123:
1124: -- Utility function to replace XML tags
1125: FUNCTION REPLACE_TAG

Line 1135: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

1131: l_tag VARCHAR2(10);
1132: l_api_name CONSTANT VARCHAR2(30) := 'REPLACE_TAG';
1133: l_full_name CONSTANT VARCHAR2(100) := G_PKG_NAME || '.' || l_api_name;
1134: BEGIN
1135: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
1136:
1137:
1138: IF LENGTH(p_string) <> 0
1139: THEN

Line 1166: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_NO_BIND_VAR',p_string);

1162:
1163:
1164: ELSE
1165:
1166: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_NO_BIND_VAR',p_string);
1167: END IF;
1168: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
1169:
1170: RETURN l_message;

Line 1168: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

1164: ELSE
1165:
1166: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_NO_BIND_VAR',p_string);
1167: END IF;
1168: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
1169:
1170: RETURN l_message;
1171: END REPLACE_TAG;
1172:

Line 1274: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

1270: SERVER_ID = l_server_id;
1271:
1272: BEGIN
1273: -- Standard begin of API savepoint
1274: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
1275:
1276:
1277: SAVEPOINT FM_SUBMIT_REQ_V1;
1278: a := '';

Line 1363: JTF_FM_UTL_V.PRINT_MESSAGE('No server found for this User',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1359: OPEN CSERV;
1360: FETCH CSERV INTO l_server_id;
1361: IF (CSERV%NOTFOUND)
1362: THEN
1363: JTF_FM_UTL_V.PRINT_MESSAGE('No server found for this User',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1364: SELECT Fnd_Profile.value('JTF_FM_DEFAULT_SERVER') INTO l_server_id FROM DUAL;
1365: JTF_FM_UTL_V.PRINT_MESSAGE('DEFAULT SERVER will be used' || l_server_id
1366: ,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1367: IF l_server_id IS NULL

Line 1365: JTF_FM_UTL_V.PRINT_MESSAGE('DEFAULT SERVER will be used' || l_server_id

1361: IF (CSERV%NOTFOUND)
1362: THEN
1363: JTF_FM_UTL_V.PRINT_MESSAGE('No server found for this User',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1364: SELECT Fnd_Profile.value('JTF_FM_DEFAULT_SERVER') INTO l_server_id FROM DUAL;
1365: JTF_FM_UTL_V.PRINT_MESSAGE('DEFAULT SERVER will be used' || l_server_id
1366: ,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1367: IF l_server_id IS NULL
1368: THEN
1369: JTF_FM_UTL_V.PRINT_MESSAGE('No Default Server found',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

Line 1366: ,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1362: THEN
1363: JTF_FM_UTL_V.PRINT_MESSAGE('No server found for this User',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1364: SELECT Fnd_Profile.value('JTF_FM_DEFAULT_SERVER') INTO l_server_id FROM DUAL;
1365: JTF_FM_UTL_V.PRINT_MESSAGE('DEFAULT SERVER will be used' || l_server_id
1366: ,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1367: IF l_server_id IS NULL
1368: THEN
1369: JTF_FM_UTL_V.PRINT_MESSAGE('No Default Server found',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1370: l_Error_Msg := 'Could not find server_id for the user passed';

Line 1369: JTF_FM_UTL_V.PRINT_MESSAGE('No Default Server found',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1365: JTF_FM_UTL_V.PRINT_MESSAGE('DEFAULT SERVER will be used' || l_server_id
1366: ,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1367: IF l_server_id IS NULL
1368: THEN
1369: JTF_FM_UTL_V.PRINT_MESSAGE('No Default Server found',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1370: l_Error_Msg := 'Could not find server_id for the user passed';
1371: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_SERVER_ID',p_fulfill_electronic_rec.server_group);
1372: END IF;
1373: --RAISE FND_API.G_EXC_ERROR;

Line 1371: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_SERVER_ID',p_fulfill_electronic_rec.server_group);

1367: IF l_server_id IS NULL
1368: THEN
1369: JTF_FM_UTL_V.PRINT_MESSAGE('No Default Server found',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1370: l_Error_Msg := 'Could not find server_id for the user passed';
1371: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_SERVER_ID',p_fulfill_electronic_rec.server_group);
1372: END IF;
1373: --RAISE FND_API.G_EXC_ERROR;
1374: END IF; -- IF (CSERV%NOTFOUND)
1375: CLOSE CSERV;

Line 1379: JTF_FM_UTL_V.PRINT_MESSAGE('Server_id Got: ' || l_server_id,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1375: CLOSE CSERV;
1376: ELSE -- IF (p_server_id = FND_API.G_MISS_NUM OR p_server_id IS NULL)
1377: l_server_id := p_fulfill_electronic_rec.server_group;
1378: END IF; -- IF (p_server_id = FND_API.G_MISS_NUM OR p_server_id IS NULL)
1379: JTF_FM_UTL_V.PRINT_MESSAGE('Server_id Got: ' || l_server_id,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1380: JTF_FM_UTL_V.PRINT_MESSAGE('p_queue_response: ' || fm_pvt_rec.queue,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1381: OPEN CREQ_Q;
1382: FETCH CREQ_Q INTO l_request_queue;
1383: IF (CREQ_Q%NOTFOUND)

Line 1380: JTF_FM_UTL_V.PRINT_MESSAGE('p_queue_response: ' || fm_pvt_rec.queue,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1376: ELSE -- IF (p_server_id = FND_API.G_MISS_NUM OR p_server_id IS NULL)
1377: l_server_id := p_fulfill_electronic_rec.server_group;
1378: END IF; -- IF (p_server_id = FND_API.G_MISS_NUM OR p_server_id IS NULL)
1379: JTF_FM_UTL_V.PRINT_MESSAGE('Server_id Got: ' || l_server_id,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1380: JTF_FM_UTL_V.PRINT_MESSAGE('p_queue_response: ' || fm_pvt_rec.queue,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1381: OPEN CREQ_Q;
1382: FETCH CREQ_Q INTO l_request_queue;
1383: IF (CREQ_Q%NOTFOUND)
1384: THEN

Line 1385: JTF_FM_UTL_V.PRINT_MESSAGE('Fetched queue unsuccessful',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1381: OPEN CREQ_Q;
1382: FETCH CREQ_Q INTO l_request_queue;
1383: IF (CREQ_Q%NOTFOUND)
1384: THEN
1385: JTF_FM_UTL_V.PRINT_MESSAGE('Fetched queue unsuccessful',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1386: l_Error_Msg := 'Could not find request_queue_name in the database';
1387: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_QUEUE_NOTFOUND',to_char(l_server_id));
1388: RAISE
1389: FND_API.G_EXC_ERROR;

Line 1387: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_QUEUE_NOTFOUND',to_char(l_server_id));

1383: IF (CREQ_Q%NOTFOUND)
1384: THEN
1385: JTF_FM_UTL_V.PRINT_MESSAGE('Fetched queue unsuccessful',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1386: l_Error_Msg := 'Could not find request_queue_name in the database';
1387: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_QUEUE_NOTFOUND',to_char(l_server_id));
1388: RAISE
1389: FND_API.G_EXC_ERROR;
1390: END IF;
1391: CLOSE CREQ_Q;

Line 1392: JTF_FM_UTL_V.PRINT_MESSAGE('Updating record in history',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1388: RAISE
1389: FND_API.G_EXC_ERROR;
1390: END IF;
1391: CLOSE CREQ_Q;
1392: JTF_FM_UTL_V.PRINT_MESSAGE('Updating record in history',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1393: l_submit_dt := sysdate;
1394:
1395: --Bug Fix #3214491
1396:

Line 1433: JTF_FM_UTL_V.PRINT_MESSAGE('Updating record in status',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1429: fm_pvt_rec.queue,
1430: l_media_type
1431: );
1432:
1433: JTF_FM_UTL_V.PRINT_MESSAGE('Updating record in status',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1434: -- Create a status record for the request
1435: INSERT INTO JTF_FM_STATUS_ALL
1436: (
1437: REQUEST_ID,

Line 1456: JTF_FM_UTL_V.PRINT_MESSAGE('Updated record in status******',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1452: l_submit_dt,
1453: FND_GLOBAL.USER_ID
1454: );
1455:
1456: JTF_FM_UTL_V.PRINT_MESSAGE('Updated record in status******',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1457: INSERT INTO JTF_FM_EMAIL_STATS
1458: (
1459: REQUEST_ID,
1460: TOTAL,

Line 1473: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND',fm_pvt_rec.request_id);

1469:
1470: EXCEPTION
1471: WHEN NO_DATA_FOUND THEN
1472: l_Error_Msg := 'Data not found for the request_id passed';
1473: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND',fm_pvt_rec.request_id);
1474: RAISE FND_API.G_EXC_ERROR;
1475:
1476:
1477: END;

Line 1483: JTF_FM_UTL_V.PRINT_MESSAGE('Forming the request ..',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1479:
1480: -- Check if the update was successful
1481:
1482:
1483: JTF_FM_UTL_V.PRINT_MESSAGE('Forming the request ..',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1484: -- Insert the Document Type Definition
1485: JTF_FM_UTL_V.Get_Dtd(l_dtd);
1486: -- start forming the request
1487: l_message := l_message||'

Line 1485: JTF_FM_UTL_V.Get_Dtd(l_dtd);

1481:
1482:
1483: JTF_FM_UTL_V.PRINT_MESSAGE('Forming the request ..',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1484: -- Insert the Document Type Definition
1485: JTF_FM_UTL_V.Get_Dtd(l_dtd);
1486: -- start forming the request
1487: l_message := l_message||' 1488: l_message := l_message || 'submit_time="'||to_char(l_submit_dt, 'YYYY-MM-DD HH24:MI:SS')||'" '||a;
1489: --l_message := l_message || 'status="NEW_REQUEST" '||a;

Line 1503: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.template_id))

1499: END IF; -- IF (p_preview
1500:
1501: -- new code added for previewing
1502:
1503: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.template_id))
1504: THEN
1505: l_message := l_message || 'template="'||to_char(p_fulfill_electronic_rec.template_id)||'" '||a;
1506: END IF; -- IF p_template_id
1507: l_message := l_message || 'priority="'||to_char(fm_pvt_rec.priority)||'" '||a;

Line 1524: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.subject))

1520: THEN
1521: l_message := l_message || 'party_id="'||to_char(fm_pvt_rec.party_id)||'" '||a;
1522: END IF; -- IF (p_party_id
1523:
1524: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.subject))
1525: THEN
1526: l_message := l_message || 'subject="'||
1527: JTF_FM_UTL_V.REPLACE_TAG(p_fulfill_electronic_rec.subject)||'" '||a;
1528: END IF; -- IF (p_subject

Line 1527: JTF_FM_UTL_V.REPLACE_TAG(p_fulfill_electronic_rec.subject)||'" '||a;

1523:
1524: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.subject))
1525: THEN
1526: l_message := l_message || 'subject="'||
1527: JTF_FM_UTL_V.REPLACE_TAG(p_fulfill_electronic_rec.subject)||'" '||a;
1528: END IF; -- IF (p_subject
1529:
1530: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.source_code_id))
1531: THEN

Line 1530: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.source_code_id))

1526: l_message := l_message || 'subject="'||
1527: JTF_FM_UTL_V.REPLACE_TAG(p_fulfill_electronic_rec.subject)||'" '||a;
1528: END IF; -- IF (p_subject
1529:
1530: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.source_code_id))
1531: THEN
1532: l_message := l_message || 'source_code_id="'||to_char(p_fulfill_electronic_rec.source_code_id)||'" '||a;
1533: END IF; -- IF (p_source_code_id
1534: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.source_code))

Line 1534: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.source_code))

1530: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.source_code_id))
1531: THEN
1532: l_message := l_message || 'source_code_id="'||to_char(p_fulfill_electronic_rec.source_code_id)||'" '||a;
1533: END IF; -- IF (p_source_code_id
1534: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.source_code))
1535: THEN
1536: l_message := l_message || 'source_code="'||p_fulfill_electronic_rec.source_code||'" '||a;
1537: END IF; -- IF (p_source_code
1538:

Line 1539: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.object_type))

1535: THEN
1536: l_message := l_message || 'source_code="'||p_fulfill_electronic_rec.source_code||'" '||a;
1537: END IF; -- IF (p_source_code
1538:
1539: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.object_type))
1540: THEN
1541: l_message := l_message || 'object_type="'||p_fulfill_electronic_rec.object_type||'" '||a;
1542: END IF; -- IF (p_object_type
1543: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.object_id))

Line 1543: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.object_id))

1539: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.object_type))
1540: THEN
1541: l_message := l_message || 'object_type="'||p_fulfill_electronic_rec.object_type||'" '||a;
1542: END IF; -- IF (p_object_type
1543: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.object_id))
1544: THEN
1545: l_message := l_message || 'object_id="'||to_char(p_fulfill_electronic_rec.object_id)||'" '||a;
1546: END IF; -- IF (p_object_id
1547: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.order_id))

Line 1547: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.order_id))

1543: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.object_id))
1544: THEN
1545: l_message := l_message || 'object_id="'||to_char(p_fulfill_electronic_rec.object_id)||'" '||a;
1546: END IF; -- IF (p_object_id
1547: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.order_id))
1548: THEN
1549: l_message := l_message || 'order_id="'||to_char(p_fulfill_electronic_rec.order_id)||'" '||a;
1550: END IF; -- IF (p_order_id
1551: JTF_FM_UTL_V.PRINT_MESSAGE('doc_id' ||to_char(fm_pvt_rec.doc_id), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 1551: JTF_FM_UTL_V.PRINT_MESSAGE('doc_id' ||to_char(fm_pvt_rec.doc_id), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

1547: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.order_id))
1548: THEN
1549: l_message := l_message || 'order_id="'||to_char(p_fulfill_electronic_rec.order_id)||'" '||a;
1550: END IF; -- IF (p_order_id
1551: JTF_FM_UTL_V.PRINT_MESSAGE('doc_id' ||to_char(fm_pvt_rec.doc_id), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
1552: IF (JTF_FM_UTL_V.IS_FLD_VALID(fm_pvt_rec.doc_id))
1553: THEN
1554: l_message := l_message || 'doc_id="'||to_char(fm_pvt_rec.doc_id)||'" '||a;
1555: l_message := l_message || 'doc_ref="'||fm_pvt_rec.doc_ref||'" '||a;

Line 1552: IF (JTF_FM_UTL_V.IS_FLD_VALID(fm_pvt_rec.doc_id))

1548: THEN
1549: l_message := l_message || 'order_id="'||to_char(p_fulfill_electronic_rec.order_id)||'" '||a;
1550: END IF; -- IF (p_order_id
1551: JTF_FM_UTL_V.PRINT_MESSAGE('doc_id' ||to_char(fm_pvt_rec.doc_id), JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
1552: IF (JTF_FM_UTL_V.IS_FLD_VALID(fm_pvt_rec.doc_id))
1553: THEN
1554: l_message := l_message || 'doc_id="'||to_char(fm_pvt_rec.doc_id)||'" '||a;
1555: l_message := l_message || 'doc_ref="'||fm_pvt_rec.doc_ref||'" '||a;
1556: ELSE -- IF (p_doc_id

Line 1603: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.extended_header))

1599: ELSE
1600: l_message := l_message|| '' || SUBSTR(fm_pvt_rec.content_xml, l_count) || '';
1601: END IF;
1602:
1603: IF (JTF_FM_UTL_V.IS_FLD_VALID(p_fulfill_electronic_rec.extended_header))
1604: THEN
1605: l_message := l_message || '' || p_fulfill_electronic_rec.extended_header|| '' ||a;
1606: END IF; -- IF (p_extended_header
1607: l_message := l_message || ' '||a;

Line 1617: JTF_FM_UTL_V.PRINT_MESSAGE('LENGTH of the MSG:'||to_char(LENGTH(l_message)),JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1613: IF MOD(xml_length,2000) <> 0 THEN
1614: loop_count := loop_count +1;
1615: END IF;
1616: --DBMS_OUTPUT.PUT_LINE('loop_count is ' || to_char(loop_count));
1617: JTF_FM_UTL_V.PRINT_MESSAGE('LENGTH of the MSG:'||to_char(LENGTH(l_message)),JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1618: JTF_FM_UTL_V.PRINT_MESSAGE('XML FORMED IS:' ,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1619: -- The following code added to print the entire XML in log messages
1620: FOR l_row in 1 .. loop_count
1621: LOOP

Line 1618: JTF_FM_UTL_V.PRINT_MESSAGE('XML FORMED IS:' ,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1614: loop_count := loop_count +1;
1615: END IF;
1616: --DBMS_OUTPUT.PUT_LINE('loop_count is ' || to_char(loop_count));
1617: JTF_FM_UTL_V.PRINT_MESSAGE('LENGTH of the MSG:'||to_char(LENGTH(l_message)),JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1618: JTF_FM_UTL_V.PRINT_MESSAGE('XML FORMED IS:' ,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1619: -- The following code added to print the entire XML in log messages
1620: FOR l_row in 1 .. loop_count
1621: LOOP
1622: --DBMS_OUTPUT.PUT_LINE('First variable--------:' || to_char((l_row-1)*data_len +1));

Line 1625: JTF_FM_UTL_V.PRINT_MESSAGE(l_error_msg ,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1621: LOOP
1622: --DBMS_OUTPUT.PUT_LINE('First variable--------:' || to_char((l_row-1)*data_len +1));
1623: --DBMS_OUTPUT.PUT_LINE('Second variable***********:' || to_char(data_len*l_row));
1624: L_ERROR_MSG := SUBSTRB(l_message, (l_row-1)*data_len +1, data_len*l_row);
1625: JTF_FM_UTL_V.PRINT_MESSAGE(l_error_msg ,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1626:
1627: END LOOP;
1628:
1629:

Line 1632: JTF_FM_UTL_V.PRINT_MESSAGE('Successfully formed the request',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1628:
1629:
1630: -- end of request
1631:
1632: JTF_FM_UTL_V.PRINT_MESSAGE('Successfully formed the request',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1633:
1634:
1635: l_temp := l_dtd || l_message;
1636:

Line 1656: JTF_FM_UTL_V.PRINT_MESSAGE('Validated and set the parser free',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1652: l_message := l_hdtd || l_message;
1653:
1654:
1655:
1656: JTF_FM_UTL_V.PRINT_MESSAGE('Validated and set the parser free',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1657: -- Convert the message to RAW so that it can be enqueued as RAW payload
1658: l_mesg := UTL_RAW.CAST_TO_RAW(l_message);
1659: JTF_FM_UTL_V.PRINT_MESSAGE('cast the message to raw',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1660:

Line 1659: JTF_FM_UTL_V.PRINT_MESSAGE('cast the message to raw',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1655:
1656: JTF_FM_UTL_V.PRINT_MESSAGE('Validated and set the parser free',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1657: -- Convert the message to RAW so that it can be enqueued as RAW payload
1658: l_mesg := UTL_RAW.CAST_TO_RAW(l_message);
1659: JTF_FM_UTL_V.PRINT_MESSAGE('cast the message to raw',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1660:
1661: -- Set the default message properties
1662:
1663: l_message_properties.priority := fm_pvt_rec.priority;

Line 1664: JTF_FM_UTL_V.PRINT_MESSAGE('set the priority',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1660:
1661: -- Set the default message properties
1662:
1663: l_message_properties.priority := fm_pvt_rec.priority;
1664: JTF_FM_UTL_V.PRINT_MESSAGE('set the priority',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1665:
1666: -- Enqueue the request in to the Request queue for the fulfillment Processor
1667:
1668: dbms_aq.enqueue(queue_name => l_request_queue,

Line 1673: JTF_FM_UTL_V.PRINT_MESSAGE('Successfully enqueued the request',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1669: enqueue_options => l_enqueue_options,
1670: message_properties => l_message_properties,
1671: payload => l_mesg, msgid => l_message_handle);
1672:
1673: JTF_FM_UTL_V.PRINT_MESSAGE('Successfully enqueued the request',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1674:
1675: -- Insert the XML request into the History record created above
1676:
1677:

Line 1694: JTF_FM_UTL_V.PRINT_MESSAGE('Before Updating History table --after enque',

1690: DBMS_LOB.WRITE (l_request, l_amount, 1, l_message);
1691: DBMS_LOB.CLOSE (l_request);
1692:
1693: l_meaning := 'SUBMITTED';
1694: JTF_FM_UTL_V.PRINT_MESSAGE('Before Updating History table --after enque',
1695: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1696:
1697:
1698:

Line 1695: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1691: DBMS_LOB.CLOSE (l_request);
1692:
1693: l_meaning := 'SUBMITTED';
1694: JTF_FM_UTL_V.PRINT_MESSAGE('Before Updating History table --after enque',
1695: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1696:
1697:
1698:
1699: --- Determine the request type as follows because the p_queue_response can be set to FND_API.G_TRUE

Line 1746: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND',fm_pvt_rec.request_id);

1742: --SUBMIT_DT_TM = l_submit_dt;
1743: EXCEPTION
1744: WHEN NO_DATA_FOUND THEN
1745: l_Error_Msg := 'Data not found for the request_id passed';
1746: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND',fm_pvt_rec.request_id);
1747: RAISE FND_API.G_EXC_ERROR;
1748:
1749:
1750: END;

Line 1753: JTF_FM_UTL_V.PRINT_MESSAGE('Before Updating Status table --after enque',

1749:
1750: END;
1751:
1752:
1753: JTF_FM_UTL_V.PRINT_MESSAGE('Before Updating Status table --after enque',
1754: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1755:
1756:
1757: -- Update tables with the type of request.

Line 1754: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1750: END;
1751:
1752:
1753: JTF_FM_UTL_V.PRINT_MESSAGE('Before Updating Status table --after enque',
1754: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1755:
1756:
1757: -- Update tables with the type of request.
1758: -- Updating the status table

Line 1792: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND',fm_pvt_rec.request_id);

1788: --SUBMIT_DT_TM = l_submit_dt;
1789: EXCEPTION
1790: WHEN NO_DATA_FOUND THEN
1791: l_Error_Msg := 'Data not found for the request_id passed';
1792: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND',fm_pvt_rec.request_id);
1793: RAISE FND_API.G_EXC_ERROR;
1794:
1795:
1796: END;

Line 1839: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);

1835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1836: THEN
1837: ROLLBACK TO FM_SUBMIT_REQ_V1;
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1839: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
1840: -- Standard call to get message count and if count=1, get the message
1841: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1842: p_count => x_msg_count,
1843: p_data => x_msg_data

Line 1845: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

1841: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1842: p_count => x_msg_count,
1843: p_data => x_msg_data
1844: );
1845: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1846:
1847: WHEN FND_API.G_EXC_ERROR
1848: THEN
1849: ROLLBACK TO FM_SUBMIT_REQ_V1;

Line 1851: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);

1847: WHEN FND_API.G_EXC_ERROR
1848: THEN
1849: ROLLBACK TO FM_SUBMIT_REQ_V1;
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('Expected Error Occured'||
1853: l_Error_Msg,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1854: -- Standard call to get message count and if count=1, get the message
1855: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

Line 1852: JTF_FM_UTL_V.PRINT_MESSAGE('Expected Error Occured'||

1848: THEN
1849: ROLLBACK TO FM_SUBMIT_REQ_V1;
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('Expected Error Occured'||
1853: l_Error_Msg,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1854: -- Standard call to get message count and if count=1, get the message
1855: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1856: p_count => x_msg_count,

Line 1853: l_Error_Msg,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1849: ROLLBACK TO FM_SUBMIT_REQ_V1;
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('Expected Error Occured'||
1853: l_Error_Msg,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1854: -- Standard call to get message count and if count=1, get the message
1855: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1856: p_count => x_msg_count,
1857: p_data => x_msg_data

Line 1859: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

1855: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1856: p_count => x_msg_count,
1857: p_data => x_msg_data
1858: );
1859: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1860:
1861: WHEN OTHERS
1862: THEN
1863: ROLLBACK TO FM_SUBMIT_REQ_V1;

Line 1865: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);

1861: WHEN OTHERS
1862: THEN
1863: ROLLBACK TO FM_SUBMIT_REQ_V1;
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1865: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
1866:
1867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1868: THEN
1869: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1877: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

1873: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1874: p_count => x_msg_count,
1875: p_data => x_msg_data
1876: );
1877: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1878:
1879: -----------------END EXCEPTION BLOCK-------------------
1880: JTF_FM_UTL_V.PRINT_MESSAGE('END'||l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1881: END FM_SUBMIT_REQ_V1;

Line 1880: JTF_FM_UTL_V.PRINT_MESSAGE('END'||l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1876: );
1877: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1878:
1879: -----------------END EXCEPTION BLOCK-------------------
1880: JTF_FM_UTL_V.PRINT_MESSAGE('END'||l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1881: END FM_SUBMIT_REQ_V1;
1882:
1883:
1884:

Line 1886: END JTF_FM_UTL_V;

1882:
1883:
1884:
1885:
1886: END JTF_FM_UTL_V;
1887: