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.OKC_TERMS_UTIL_GRP dependencies on STANDARD

Line 72: -- Standard Start of API savepoint

68: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: p_validation_string : '||p_validation_string );
69: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'800: p_doc_type : '||p_doc_type);
70: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: p_doc_id : '||p_doc_id);
71: END IF;
72: -- Standard Start of API savepoint
73: SAVEPOINT g_Delete_Doc;
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 74: -- Standard call to check for call compatibility.

70: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: p_doc_id : '||p_doc_id);
71: END IF;
72: -- Standard Start of API savepoint
73: SAVEPOINT g_Delete_Doc;
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 173: -- Standard call to get message count and if count is 1, get message info.

169:
170: IF FND_API.To_Boolean( p_commit ) THEN
171: COMMIT WORK;
172: END IF;
173: -- Standard call to get message count and if count is 1, get message info.
174: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
175: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
176: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1300: Leaving Delete_Doc');
177: END IF;

Line 238: -- Standard Start of API savepoint

234: BEGIN
235: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
236: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1700: Entered Purge_Doc');
237: END IF;
238: -- Standard Start of API savepoint
239: SAVEPOINT g_Purge_Doc;
240: -- Standard call to check for call compatibility.
241: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 240: -- Standard call to check for call compatibility.

236: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1700: Entered Purge_Doc');
237: END IF;
238: -- Standard Start of API savepoint
239: SAVEPOINT g_Purge_Doc;
240: -- Standard call to check for call compatibility.
241: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 360: -- Standard call to get message count and if count is 1, get message info.

356: IF FND_API.To_Boolean( p_commit ) THEN
357: COMMIT WORK;
358: END IF;
359:
360: -- Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
362: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2100: Leaving Purge_Doc');
364: END IF;

Line 437: -- Standard Start of API savepoint

433: BEGIN
434: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
435: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2500: Entered Mark_Variable_Based_Amendment');
436: END IF;
437: -- Standard Start of API savepoint
438: SAVEPOINT g_Get_System_Variables;
439: -- Standard call to check for call compatibility.
440: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 439: -- Standard call to check for call compatibility.

435: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2500: Entered Mark_Variable_Based_Amendment');
436: END IF;
437: -- Standard Start of API savepoint
438: SAVEPOINT g_Get_System_Variables;
439: -- Standard call to check for call compatibility.
440: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 575: -- Standard call to get message count and if count is 1, get message info.

571:
572: END LOOP;
573: END IF;
574:
575: -- Standard call to get message count and if count is 1, get message info.
576: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
577: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2700: Leaving Mark_Variable_Based_Amendment');
579: END IF;

Line 614: --Possible return values NONE, ONLY_STANDARD_EXIST, NON_STANDARD_EXIST .

610: END Mark_Variable_Based_Amendment;
611:
612: /*
613: --To be used to find out if a document is using articles.If yes then what type.
614: --Possible return values NONE, ONLY_STANDARD_EXIST, NON_STANDARD_EXIST .
615: */
616:
617: FUNCTION Is_Article_Exist(
618: p_api_version IN NUMBER,

Line 634: SELECT a.standard_yn

630: l_dummy VARCHAR2(1) := '?';
631: l_return_value VARCHAR2(100) := G_NO_ARTICLE_EXIST;
632:
633: CURSOR find_art_crs IS
634: SELECT a.standard_yn
635: FROM okc_k_articles_b kart, okc_articles_all a
636: WHERE kart.document_type=p_doc_type
637: AND kart.document_id=p_doc_id
638: AND nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED

Line 641: ORDER BY Decode(a.standard_yn,'N',1) ASC ;

637: AND kart.document_id=p_doc_id
638: AND nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED
639: AND nvl(kart.summary_amend_operation_code,'?')<>G_AMEND_CODE_DELETED
640: AND a.article_id = kart.sav_sae_id
641: ORDER BY Decode(a.standard_yn,'N',1) ASC ;
642: BEGIN
643: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
644: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3100: Entered Is_Article_exist');
645: END IF;

Line 646: -- Standard call to check for call compatibility.

642: BEGIN
643: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
644: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3100: Entered Is_Article_exist');
645: END IF;
646: -- Standard call to check for call compatibility.
647: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: END IF;
650: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 658: RETURN G_NON_STANDARD_ART_EXIST;

654: -- Initialize API return status to success
655: x_return_status := G_RET_STS_SUCCESS;
656:
657: IF Get_Contract_Source_Code(p_document_type => p_doc_type,p_document_id => p_doc_id) = 'ATTACHED' THEN
658: RETURN G_NON_STANDARD_ART_EXIST;
659: END IF;
660:
661: OPEN find_art_crs;
662: FETCH find_art_crs INTO l_dummy;

Line 665: l_return_value := G_ONLY_STANDARD_ART_EXIST;

661: OPEN find_art_crs;
662: FETCH find_art_crs INTO l_dummy;
663: CLOSE find_art_crs;
664: IF l_dummy='Y' THEN
665: l_return_value := G_ONLY_STANDARD_ART_EXIST;
666: ELSIF l_dummy='N' THEN
667: l_return_value := G_NON_STANDARD_ART_EXIST;
668: END IF;
669:

Line 667: l_return_value := G_NON_STANDARD_ART_EXIST;

663: CLOSE find_art_crs;
664: IF l_dummy='Y' THEN
665: l_return_value := G_ONLY_STANDARD_ART_EXIST;
666: ELSIF l_dummy='N' THEN
667: l_return_value := G_NON_STANDARD_ART_EXIST;
668: END IF;
669:
670: -- Standard call to get message count and if count is 1, get message info.
671: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 670: -- Standard call to get message count and if count is 1, get message info.

666: ELSIF l_dummy='N' THEN
667: l_return_value := G_NON_STANDARD_ART_EXIST;
668: END IF;
669:
670: -- Standard call to get message count and if count is 1, get message info.
671: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3200: Result Is_Article_exist? : ['||l_return_value||']');
674: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3300: Leaving Is_Article_exist');

Line 847: FUNCTION Deviation_From_Standard(

843: return l_return_value;
844:
845: END Is_Document_Updatable;
846:
847: FUNCTION Deviation_From_Standard(
848: p_doc_type IN VARCHAR2,
849: p_doc_id IN NUMBER
850: ) RETURN VARCHAR2 IS
851: l_return_status Varchar2(1);

Line 857: l_return_value:=Deviation_From_Standard(p_api_version => 1,

853: l_msg_count NUMBER;
854: l_return_value Varchar2(30);
855: BEGIN
856:
857: l_return_value:=Deviation_From_Standard(p_api_version => 1,
858: p_init_msg_list => FND_API.G_FALSE,
859: p_doc_type => p_doc_type,
860: p_doc_id => p_doc_id,
861: x_return_status => l_return_status,

Line 877: FUNCTION Deviation_From_Standard(

873: -- compared to template that was used in the document.ocument has used.
874: -- Possible return values NO_CHANGE,ARTICLES_CHANGED,DELIVERABLES_CHANGED,
875: -- ARTICLES_AND_DELIVERABLES_CHANGED
876: */
877: FUNCTION Deviation_From_Standard(
878: p_api_version IN NUMBER,
879: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
880:
881: x_return_status OUT NOCOPY VARCHAR2,

Line 889: l_api_name CONSTANT VARCHAR2(30) := 'Deviation_From_Standard';

885: p_doc_type IN VARCHAR2,
886: p_doc_id IN NUMBER
887: ) RETURN VARCHAR2 IS
888: l_api_version CONSTANT NUMBER := 1;
889: l_api_name CONSTANT VARCHAR2(30) := 'Deviation_From_Standard';
890: l_return_value VARCHAR2(100) := G_NO_CHANGE;
891: l_article_changed VARCHAR2(1) := 'N';
892: l_deliverable_changed VARCHAR2(1) := 'N';
893:

Line 913: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3700: Entered Deviation_From_Standard');

909: ;
910:
911: BEGIN
912: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
913: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3700: Entered Deviation_From_Standard');
914: END IF;
915: -- Standard call to check for call compatibility.
916: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 915: -- Standard call to check for call compatibility.

911: BEGIN
912: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
913: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3700: Entered Deviation_From_Standard');
914: END IF;
915: -- Standard call to check for call compatibility.
916: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
918: END IF;
919: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 944: -- Standard call to get message count and if count is 1, get message info.

940: l_return_value := G_NO_CHANGE;
941: END IF;
942: END IF;
943:
944: -- Standard call to get message count and if count is 1, get message info.
945: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
946: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Result Deviation_From_Standard? : ['||l_return_value||']');
948: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Leaving Deviation_From_Standard');

Line 947: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Result Deviation_From_Standard? : ['||l_return_value||']');

943:
944: -- Standard call to get message count and if count is 1, get message info.
945: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
946: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Result Deviation_From_Standard? : ['||l_return_value||']');
948: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Leaving Deviation_From_Standard');
949: END IF;
950: RETURN l_return_value ;
951: EXCEPTION

Line 948: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Leaving Deviation_From_Standard');

944: -- Standard call to get message count and if count is 1, get message info.
945: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
946: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Result Deviation_From_Standard? : ['||l_return_value||']');
948: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Leaving Deviation_From_Standard');
949: END IF;
950: RETURN l_return_value ;
951: EXCEPTION
952: WHEN FND_API.G_EXC_ERROR THEN

Line 954: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4000: Leaving Deviation_From_Standard : OKC_API.G_EXCEPTION_ERROR Exception');

950: RETURN l_return_value ;
951: EXCEPTION
952: WHEN FND_API.G_EXC_ERROR THEN
953: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4000: Leaving Deviation_From_Standard : OKC_API.G_EXCEPTION_ERROR Exception');
955: END IF;
956: x_return_status := G_RET_STS_ERROR ;
957: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
958: RETURN NULL ;

Line 962: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4100: Leaving Deviation_From_Standard : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

958: RETURN NULL ;
959:
960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
961: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4100: Leaving Deviation_From_Standard : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
963: END IF;
964: x_return_status := G_RET_STS_UNEXP_ERROR ;
965: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
966: RETURN NULL ;

Line 970: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4200: Leaving Deviation_From_Standard because of EXCEPTION: '||sqlerrm);

966: RETURN NULL ;
967:
968: WHEN OTHERS THEN
969: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
970: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4200: Leaving Deviation_From_Standard because of EXCEPTION: '||sqlerrm);
971: END IF;
972:
973: IF find_art_crs%ISOPEN THEN
974: CLOSE find_art_crs;

Line 982: END Deviation_From_Standard ;

978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
979: END IF;
980: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
981: RETURN NULL ;
982: END Deviation_From_Standard ;
983:
984: /*
985: --To be used to find out if template used in document has expired.Possible return values Y,N.
986: -- Possible return values are

Line 1021: -- Standard call to check for call compatibility.

1017: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4300: Entered Is_Template_Expired');
1019: END IF;
1020:
1021: -- Standard call to check for call compatibility.
1022: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1024: END IF;
1025:

Line 1042: -- Standard call to get message count and if count is 1, get message info.

1038: OPEN find_tmpl_crs;
1039: FETCH find_tmpl_crs INTO l_return_value;
1040: CLOSE find_tmpl_crs ;
1041:
1042: -- Standard call to get message count and if count is 1, get message info.
1043: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1044:
1045: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1046: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Result Is_Template_Expired? : ['||l_return_value||']');

Line 1148: -- type of article is amended.Possible values NO_ARTICLE_AMENDED,ONLY_STANDARD_AMENDED ,NON_STANDARD_AMENDED

1144:
1145:
1146: /*
1147: --To be used in amend flow to find out if any article is amended.If Yes then what
1148: -- type of article is amended.Possible values NO_ARTICLE_AMENDED,ONLY_STANDARD_AMENDED ,NON_STANDARD_AMENDED
1149: */
1150:
1151: FUNCTION Is_Article_Amended(
1152: p_api_version IN NUMBER,

Line 1167: SELECT a.standard_yn

1163: l_api_name CONSTANT VARCHAR2(30) := 'Is_Article_AMENDED';
1164: l_dummy VARCHAR2(1) := '?';
1165: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
1166: CURSOR find_art_crs IS
1167: SELECT a.standard_yn
1168: FROM okc_k_articles_b kart, okc_articles_all a
1169: WHERE kart.document_type=p_doc_type
1170: AND kart.document_id=p_doc_id
1171: AND kart.summary_amend_operation_code IS NOT NULL

Line 1173: ORDER BY Decode(a.standard_yn,'N',1) ASC ;

1169: WHERE kart.document_type=p_doc_type
1170: AND kart.document_id=p_doc_id
1171: AND kart.summary_amend_operation_code IS NOT NULL
1172: AND a.article_id = kart.sav_sae_id
1173: ORDER BY Decode(a.standard_yn,'N',1) ASC ;
1174: BEGIN
1175: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1176: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5700: Entered Is_Article_AMENDED');
1177: END IF;

Line 1178: -- Standard call to check for call compatibility.

1174: BEGIN
1175: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1176: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5700: Entered Is_Article_AMENDED');
1177: END IF;
1178: -- Standard call to check for call compatibility.
1179: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: END IF;
1182: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1194: l_return_value := G_ONLY_STANDARD_ART_AMENDED;

1190: FETCH find_art_crs INTO l_dummy;
1191: CLOSE find_art_crs;
1192:
1193: IF l_dummy='Y' THEN
1194: l_return_value := G_ONLY_STANDARD_ART_AMENDED;
1195: ELSIF l_dummy='N' THEN
1196: l_return_value := G_NON_STANDARD_ART_AMENDED;
1197: END IF;
1198:

Line 1196: l_return_value := G_NON_STANDARD_ART_AMENDED;

1192:
1193: IF l_dummy='Y' THEN
1194: l_return_value := G_ONLY_STANDARD_ART_AMENDED;
1195: ELSIF l_dummy='N' THEN
1196: l_return_value := G_NON_STANDARD_ART_AMENDED;
1197: END IF;
1198:
1199: -- Standard call to get message count and if count is 1, get message info.
1200:

Line 1199: -- Standard call to get message count and if count is 1, get message info.

1195: ELSIF l_dummy='N' THEN
1196: l_return_value := G_NON_STANDARD_ART_AMENDED;
1197: END IF;
1198:
1199: -- Standard call to get message count and if count is 1, get message info.
1200:
1201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1202:
1203: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1329: -- Standard call to check for call compatibility.

1325: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1326: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6900: Entered Get_Terms_Template');
1327: END IF;
1328:
1329: -- Standard call to check for call compatibility.
1330: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333:

Line 1346: -- Standard call to get message count and if count is 1, get message info.

1342: OPEN find_tmpl_crs;
1343: FETCH find_tmpl_crs INTO x_template_id, x_template_name;
1344: CLOSE find_tmpl_crs;
1345:
1346: -- Standard call to get message count and if count is 1, get message info.
1347: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1348:
1349: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1350: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Result Get_Terms_Template? : ['||l_return_value||']');

Line 1413: -- Standard call to check for call compatibility.

1409: BEGIN
1410: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1411: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Get_Contract_Document_Type');
1412: END IF;
1413: -- Standard call to check for call compatibility.
1414: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1416: END IF;
1417: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1432: -- Standard call to get message count and if count is 1, get message info.

1428: IF l_return_value IS NULL THEN
1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431:
1432: -- Standard call to get message count and if count is 1, get message info.
1433: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1434: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1435: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7600: Result Get_Contract_Document_Type? : ['||l_return_value||']');
1436: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Get_Contract_Document_Type');

Line 1502: -- Standard call to check for call compatibility.

1498:
1499: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1500: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: Entered Get_Contract_Document_Type_id');
1501: END IF;
1502: -- Standard call to check for call compatibility.
1503: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1505: END IF;
1506: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1522: -- Standard call to get message count and if count is 1, get message info.

1518: IF l_notfound THEN
1519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1520: END IF;
1521:
1522: -- Standard call to get message count and if count is 1, get message info.
1523: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1524: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1525: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8200: Result Document_Type : ['||x_doc_type||']');
1526: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8300: Result Document_ID : ['||x_doc_id||']');

Line 1630: -- Standard call to check for call compatibility.

1626: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9200: p_doc_type : '||p_doc_type);
1627: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9300: p_doc_id : '||p_doc_id);
1628: END IF;
1629:
1630: -- Standard call to check for call compatibility.
1631: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name , G_PKG_NAME) THEN
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: END IF;
1634:

Line 1802: -- Standard call to check for call compatibility.

1798: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11000: p_doc_type : '||p_doc_type);
1799: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11100: p_doc_id : '||p_doc_id);
1800: END IF;
1801:
1802: -- Standard call to check for call compatibility.
1803: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1805: END IF;
1806:

Line 2098: -- Standard call to check for call compatibility.

2094: BEGIN
2095: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2096: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14200: Entered is_manual_article_exist');
2097: END IF;
2098: -- Standard call to check for call compatibility.
2099: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2101: END IF;
2102: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2123: -- Standard call to get message count and if count is 1, get message info.

2119: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2120: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14300: Leaving is_manual_article_exist');
2121: END IF;
2122:
2123: -- Standard call to get message count and if count is 1, get message info.
2124: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2125: RETURN l_return_value ;
2126:
2127: EXCEPTION

Line 2184: -- Standard call to check for call compatibility.

2180: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2181: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14700: Get_Template_Name');
2182: END IF;
2183:
2184: -- Standard call to check for call compatibility.
2185: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187: END IF;
2188:

Line 2210: -- Standard call to get message count and if count is 1, get message info.

2206: FETCH c_get_template_name INTO l_return_value;
2207: CLOSE c_get_template_name;
2208:
2209:
2210: -- Standard call to get message count and if count is 1, get message info.
2211: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2212:
2213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2214: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14900: Result Get_Template_Name : ['||l_return_value||']');

Line 2314: -- Standard call to check for call compatibility.

2310: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2311: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15400: Entered get_item_dtl_for_expert');
2312: END IF;
2313:
2314: -- Standard call to check for call compatibility.
2315: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2317: END IF;
2318: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2424: -- Standard call to get message count and if count is 1, get message info.

2420: ELSE
2421: NULL;
2422: END IF;
2423:
2424: -- Standard call to get message count and if count is 1, get message info.
2425: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2426: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15500: Leaving get_item_dtl_for_expert');
2428: END IF;

Line 2595: -- Standard call to get message count and if count is 1, get message info.

2591: Raise FND_API.G_EXC_ERROR;
2592: END IF;
2593: CLOSE l_get_template_dtl;
2594:
2595: -- Standard call to get message count and if count is 1, get message info.
2596: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2597: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2598: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16500: Leaving Get_Terms_Template_dtl');
2599: END IF;

Line 2700: -- Standard call to get message count and if count is 1, get message info.

2696: x_template_description ;
2697:
2698: CLOSE terms_tmpl_csr;
2699:
2700: -- Standard call to get message count and if count is 1, get message info.
2701: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2702: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2703: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'17000: Leaving Get_Terms_Template_dtl');
2704: END IF;

Line 2747: p_standard_yn IN VARCHAR2

2743:
2744: FUNCTION enable_update(
2745: p_object_type IN VARCHAR2,
2746: p_document_type IN VARCHAR2,
2747: p_standard_yn IN VARCHAR2
2748: ) RETURN VARCHAR2 IS
2749: l_api_name CONSTANT VARCHAR2(30) := 'enable_update';
2750: BEGIN
2751: IF (p_object_type <> 'SECTION' AND p_object_type <> 'ARTICLE') THEN

Line 2761: ELSIF NVL(p_standard_yn,'N') = 'Y' THEN

2757: -- Article Cases
2758: ELSIF p_document_type = 'TEMPLATE' THEN
2759: -- always disable for template as the logic is based on template status and is in the controller code
2760: RETURN 'OkcTermsStructDtlsUpdateDisabled';
2761: ELSIF NVL(p_standard_yn,'N') = 'Y' THEN
2762: -- update always enabled for standard articles
2763: RETURN 'OkcTermsStructDtlsUpdateEnabled' ;
2764: -- non std articles
2765: ELSIF fnd_function.test('OKC_TERMS_AUTHOR_NON_STD','N') THEN

Line 2762: -- update always enabled for standard articles

2758: ELSIF p_document_type = 'TEMPLATE' THEN
2759: -- always disable for template as the logic is based on template status and is in the controller code
2760: RETURN 'OkcTermsStructDtlsUpdateDisabled';
2761: ELSIF NVL(p_standard_yn,'N') = 'Y' THEN
2762: -- update always enabled for standard articles
2763: RETURN 'OkcTermsStructDtlsUpdateEnabled' ;
2764: -- non std articles
2765: ELSIF fnd_function.test('OKC_TERMS_AUTHOR_NON_STD','N') THEN
2766: -- user has access to fn and doc not template

Line 2783: p_standard_yn IN VARCHAR2,

2779:
2780: FUNCTION enable_delete(
2781: p_object_type IN VARCHAR2,
2782: p_mandatory_yn IN VARCHAR2,
2783: p_standard_yn IN VARCHAR2,
2784: p_document_type IN VARCHAR2
2785: ) RETURN VARCHAR2 IS
2786: l_api_name CONSTANT VARCHAR2(30) := 'enable_delete';
2787: BEGIN

Line 2810: -- Case 2: STANDARD ARTICLES (non-mandatory)

2806: ELSE
2807: RETURN 'OkcTermsStructDtlsRemoveDisabled';
2808: END IF;
2809: END IF;
2810: -- Case 2: STANDARD ARTICLES (non-mandatory)
2811: ELSIF NVL(p_standard_yn,'N') = 'Y' THEN
2812: -- for standard articles delete is always allowed
2813: RETURN 'OkcTermsStructDtlsRemoveEnabled' ;
2814: -- Case 3: NON-STANDARD ARTICLES (non-mandatory)

Line 2811: ELSIF NVL(p_standard_yn,'N') = 'Y' THEN

2807: RETURN 'OkcTermsStructDtlsRemoveDisabled';
2808: END IF;
2809: END IF;
2810: -- Case 2: STANDARD ARTICLES (non-mandatory)
2811: ELSIF NVL(p_standard_yn,'N') = 'Y' THEN
2812: -- for standard articles delete is always allowed
2813: RETURN 'OkcTermsStructDtlsRemoveEnabled' ;
2814: -- Case 3: NON-STANDARD ARTICLES (non-mandatory)
2815: ELSIF fnd_function.test('OKC_TERMS_AUTHOR_NON_STD','N') THEN

Line 2812: -- for standard articles delete is always allowed

2808: END IF;
2809: END IF;
2810: -- Case 2: STANDARD ARTICLES (non-mandatory)
2811: ELSIF NVL(p_standard_yn,'N') = 'Y' THEN
2812: -- for standard articles delete is always allowed
2813: RETURN 'OkcTermsStructDtlsRemoveEnabled' ;
2814: -- Case 3: NON-STANDARD ARTICLES (non-mandatory)
2815: ELSIF fnd_function.test('OKC_TERMS_AUTHOR_NON_STD','N') THEN
2816: -- for non-std articles check for function security

Line 2814: -- Case 3: NON-STANDARD ARTICLES (non-mandatory)

2810: -- Case 2: STANDARD ARTICLES (non-mandatory)
2811: ELSIF NVL(p_standard_yn,'N') = 'Y' THEN
2812: -- for standard articles delete is always allowed
2813: RETURN 'OkcTermsStructDtlsRemoveEnabled' ;
2814: -- Case 3: NON-STANDARD ARTICLES (non-mandatory)
2815: ELSIF fnd_function.test('OKC_TERMS_AUTHOR_NON_STD','N') THEN
2816: -- for non-std articles check for function security
2817: -- user has access , so check allow delete for non-std articles
2818: RETURN 'OkcTermsStructDtlsRemoveEnabled' ;

Line 3026: -- Standard call to check for call compatibility.

3022: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3023: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15400: Entered Get_Contract_Details');
3024: END IF;
3025:
3026: -- Standard call to check for call compatibility.
3027: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3029: END IF;
3030: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3074: -- Standard call to get message count and if count is 1, get message info.

3070: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16900: x_template_name:'||x_template_name);
3071: END IF;
3072: END IF;
3073:
3074: -- Standard call to get message count and if count is 1, get message info.
3075: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3076: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'17000: Leaving Get_Contract_Details');
3078: END IF;

Line 3232: -- Standard call to check for call compatibility.

3228: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3229: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15400: Entered Get_Contract_Details_All');
3230: END IF;
3231:
3232: -- Standard call to check for call compatibility.
3233: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3235: END IF;
3236: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3349: -- Standard call to get message count and if count is 1, get message info.

3345: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'16900: x_template_name:'||x_template_name);
3346: END IF;
3347: END IF;
3348:
3349: -- Standard call to get message count and if count is 1, get message info.
3350: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3351: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3352: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'17000: Leaving Get_Contract_Details_All');
3353: END IF;

Line 3492: -- Standard call to check for call compatibility.

3488: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3489: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6900: Entered Is_Terms_Template_Valid');
3490: END IF;
3491:
3492: -- Standard call to check for call compatibility.
3493: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: END IF;
3496:

Line 3508: -- Standard call to get message count and if count is 1, get message info.

3504: OPEN terms_tmpl_csr;
3505: FETCH terms_tmpl_csr INTO l_result;
3506: CLOSE terms_tmpl_csr;
3507:
3508: -- Standard call to get message count and if count is 1, get message info.
3509: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3510:
3511: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3512: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Result Is_Terms_Template_Valid? : ['||l_result||']');

Line 3598: -- Standard call to check for call compatibility.

3594: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3595: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6900: Entered Get_Contract_Defaults');
3596: END IF;
3597:
3598: -- Standard call to check for call compatibility.
3599: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3601: END IF;
3602:

Line 3634: -- Standard call to get message count and if count is 1, get message info.

3630: x_template_name:= fnd_message.get;
3631: x_template_description := NULL;
3632: END IF;
3633:
3634: -- Standard call to get message count and if count is 1, get message info.
3635: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3636:
3637: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3638: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Result Get_Contract_Defaults? : ['||x_return_status||']');

Line 3721: -- Standard call to check for call compatibility.

3717: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6920: p_org_id='||p_org_id);
3718: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6930: p_valid_date='||p_valid_date);
3719: END IF;
3720:
3721: -- Standard call to check for call compatibility.
3722: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3724: END IF;
3725:

Line 3737: -- Standard call to get message count and if count is 1, get message info.

3733: OPEN terms_tmpl_csr;
3734: FETCH terms_tmpl_csr INTO x_template_id,x_template_name,x_template_description;
3735: CLOSE terms_tmpl_csr;
3736:
3737: -- Standard call to get message count and if count is 1, get message info.
3738: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3739:
3740: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3741: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Result x_template_id : ['||x_template_id||']');

Line 3896: -- Standard call to check for call compatibility.

3892: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3893: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6900: Entered Has_Uploaded_Deviations_Doc');
3894: END IF;
3895:
3896: -- Standard call to check for call compatibility.
3897: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3899: END IF;
3900:

Line 3918: -- Standard call to get message count and if count is 1, get message info.

3914: p_document_id => p_document_id
3915: );
3916:
3917:
3918: -- Standard call to get message count and if count is 1, get message info.
3919: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3920:
3921: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3922: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Result Has_Uploaded_Deviations_Doc? : ['||x_return_status||']');

Line 4052: -- Standard call to check for call compatibility.

4048: BEGIN
4049: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4050: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered Contract_Terms_Amended');
4051: END IF;
4052: -- Standard call to check for call compatibility.
4053: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4055: END IF;
4056: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4087: -- Standard call to get message count and if count is 1, get message info.

4083: p_doc_id => p_doc_id);
4084:
4085: END IF;
4086:
4087: -- Standard call to get message count and if count is 1, get message info.
4088:
4089: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4090:
4091: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4188: -- Standard call to check for call compatibility.

4184: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4185: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6900: Entered get_translated_template');
4186: END IF;
4187:
4188: -- Standard call to check for call compatibility.
4189: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4191: END IF;
4192:

Line 4247: -- Standard call to get message count and if count is 1, get message info.

4243: END IF;
4244:
4245: CLOSE l_translated_csr;
4246:
4247: -- Standard call to get message count and if count is 1, get message info.
4248: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4249:
4250: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4251: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7300: Leaving get_translated_template');