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.PO_CONTERMS_UTL_GRP dependencies on FND_MSG_PUB

Line 118: FND_MSG_PUB.initialize;

114: x_return_status:= FND_API.G_RET_STS_SUCCESS;
115:
116: -- initialize meesage list
117: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
118: FND_MSG_PUB.initialize;
119: END IF;
120:
121: x_contracts_enabled := is_contracts_enabled;
122:

Line 126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
127: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
128: IF (g_fnd_debug='Y') THEN
129: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
130: FND_LOG.string(log_level => FND_LOG.level_unexpected

Line 127: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

123: EXCEPTION
124: WHEN OTHERS THEN
125: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
127: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
128: IF (g_fnd_debug='Y') THEN
129: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
130: FND_LOG.string(log_level => FND_LOG.level_unexpected
131: ,module => g_module_prefix ||l_api_name

Line 136: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

132: ,message => SQLERRM);
133: END IF;
134: END IF;
135: END IF;
136: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
137: ,p_data => x_msg_data);
138: END is_contracts_enabled;
139:
140:

Line 300: FND_MSG_PUB.initialize;

296: x_return_status:= FND_API.G_RET_STS_SUCCESS;
297:
298: -- initialize meesage list
299: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
300: FND_MSG_PUB.initialize;
301: END IF;
302:
303: -- parse the contracts document type to type lookup
304: l_document_type := SUBSTR(p_document_type, 1, 2);

Line 339: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

335:
336: EXCEPTION
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
340: ,p_data => x_msg_data);
341: WHEN OTHERS THEN
342: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

339: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
340: ,p_data => x_msg_data);
341: WHEN OTHERS THEN
342: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
344: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
345: IF (g_fnd_debug='Y') THEN
346: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
347: FND_LOG.string(log_level => FND_LOG.level_unexpected

Line 344: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

340: ,p_data => x_msg_data);
341: WHEN OTHERS THEN
342: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
344: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
345: IF (g_fnd_debug='Y') THEN
346: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
347: FND_LOG.string(log_level => FND_LOG.level_unexpected
348: ,module => g_module_prefix ||l_api_name

Line 353: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

349: ,message => SQLERRM);
350: END IF;
351: END IF;
352: END IF;
353: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
354: ,p_data => x_msg_data);
355: END get_external_userlist;
356:
357: -------------------------------------------------------------------------------

Line 442: FND_MSG_PUB.initialize;

438: x_return_status:= FND_API.G_RET_STS_SUCCESS;
439:
440: -- initialize meesage list
441: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
442: FND_MSG_PUB.initialize;
443: END IF;
444:
445: -- parse the contracts document type to type lookup
446: l_document_type := SUBSTR(p_document_type, 1, 2);

Line 486: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

482:
483: EXCEPTION
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
487: ,p_data => x_msg_data);
488: WHEN OTHERS THEN
489: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

486: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
487: ,p_data => x_msg_data);
488: WHEN OTHERS THEN
489: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
491: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
492: IF (g_fnd_debug='Y') THEN
493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
494: FND_LOG.string(log_level => FND_LOG.level_unexpected

Line 491: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

487: ,p_data => x_msg_data);
488: WHEN OTHERS THEN
489: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
491: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
492: IF (g_fnd_debug='Y') THEN
493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
494: FND_LOG.string(log_level => FND_LOG.level_unexpected
495: ,module => g_module_prefix ||l_api_name

Line 500: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

496: ,message => SQLERRM);
497: END IF;
498: END IF;
499: END IF;
500: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
501: ,p_data => x_msg_data);
502: END get_external_userlist;
503:
504: -------------------------------------------------------------------------------

Line 586: FND_MSG_PUB.initialize;

582: x_return_status:= FND_API.G_RET_STS_SUCCESS;
583:
584: -- initialize meesage list
585: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
586: FND_MSG_PUB.initialize;
587: END IF;
588:
589: /* Mod changes */
590: IF p_doc_type = 'PO_STANDARD_MOD' OR

Line 668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

664:
665: EXCEPTION
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
669: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
670: IF (g_fnd_debug='Y') THEN
671: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
672: FND_LOG.string(log_level => FND_LOG.level_unexpected

Line 669: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

665: EXCEPTION
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
669: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
670: IF (g_fnd_debug='Y') THEN
671: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
672: FND_LOG.string(log_level => FND_LOG.level_unexpected
673: ,module => g_module_prefix ||l_api_name

Line 678: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

674: ,message => SQLERRM);
675: END IF;
676: END IF;
677: END IF;
678: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
679: ,p_data => x_msg_data);
680:
681: END get_item_categorylist;
682:

Line 806: FND_MSG_PUB.initialize;

802: END IF;
803:
804: -- Initialize message list if p_init_msg_list is set to TRUE.
805: IF FND_API.to_Boolean(p_init_msg_list ) THEN
806: FND_MSG_PUB.initialize;
807: END IF;
808:
809: -- Initialize API return status to success
810: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 826: FND_MSG_PUB.Add;

822: IF p_header_id is null then
823: Fnd_message.set_name('PO','PO_VALUE_MISSING');
824: Fnd_message.set_token( token => 'VARIABLE'
825: , VALUE => 'p_header_id');
826: FND_MSG_PUB.Add;
827: x_return_status := FND_API.G_RET_STS_ERROR;
828: RAISE FND_API.G_EXC_ERROR;
829: END IF;
830:

Line 850: FND_MSG_PUB.Add;

846: ELSE
847: Fnd_message.set_name('PO','PO_VALUE_MISSING');
848: Fnd_message.set_token( token => 'VARIABLE'
849: , VALUE => 'p_callout_string');
850: FND_MSG_PUB.Add;
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: RAISE FND_API.G_EXC_ERROR;
853:
854: END IF;-- p_callout _string

Line 881: FND_MSG_PUB.Add;

877: IF l_callout_status is null then
878: Fnd_message.set_name('PO','PO_VALUE_MISSING');
879: Fnd_message.set_token( token => 'VARIABLE'
880: , VALUE => 'callout_status');
881: FND_MSG_PUB.Add;
882: x_return_status := FND_API.G_RET_STS_ERROR;
883: RAISE FND_API.G_EXC_ERROR;
884: END IF;
885: IF l_callout_revision is null then

Line 889: FND_MSG_PUB.Add;

885: IF l_callout_revision is null then
886: Fnd_message.set_name('PO','PO_VALUE_MISSING');
887: Fnd_message.set_token( token => 'VARIABLE'
888: , VALUE => 'callout_revision');
889: FND_MSG_PUB.Add;
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;
893: /* Mod changes */

Line 923: FND_MSG_PUB.Add;

919:
920: EXCEPTION
921: WHEN NO_DATA_FOUND then
922: Fnd_message.set_name('PO','PO_DOESNOT_EXIST');
923: FND_MSG_PUB.Add;
924: x_return_status := FND_API.G_RET_STS_ERROR;
925: RAISE FND_API.G_EXC_ERROR;
926:
927: END;

Line 950: FND_MSG_PUB.Add;

946: If l_emp_id is null then
947: Fnd_message.set_name('PO','PO_VALUE_MISSING');
948: Fnd_message.set_token( token => 'VARIABLE'
949: , VALUE => 'emp_id_in_callout_str');
950: FND_MSG_PUB.Add;
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: RAISE FND_API.G_EXC_ERROR;
953: End if;--emp id is null
954: --Check if current user is the current approver for the PO

Line 1081: FND_MSG_PUB.Add;

1077: WHEN l_STATUS_CHANGED then
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: x_update_allowed := 'N';
1080: FND_MESSAGE.set_name('PO', 'PO_STATUS_CHANGED');
1081: FND_MSG_PUB.Add;
1082: FND_MSG_PUB.Count_And_Get
1083: (p_count => x_msg_count,
1084: p_data => x_msg_data );
1085: IF g_fnd_debug = 'Y' then

Line 1082: FND_MSG_PUB.Count_And_Get

1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: x_update_allowed := 'N';
1080: FND_MESSAGE.set_name('PO', 'PO_STATUS_CHANGED');
1081: FND_MSG_PUB.Add;
1082: FND_MSG_PUB.Count_And_Get
1083: (p_count => x_msg_count,
1084: p_data => x_msg_data );
1085: IF g_fnd_debug = 'Y' then
1086: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1098: FND_MSG_PUB.Add;

1094: WHEN l_DONOT_UPDATE then
1095: x_return_status := FND_API.G_RET_STS_ERROR;
1096: x_update_allowed := 'N';
1097: FND_MESSAGE.set_name('PO', 'PO_NO_UPDATE_ALLOWED');
1098: FND_MSG_PUB.Add;
1099: FND_MSG_PUB.Count_And_Get
1100: (p_count => x_msg_count,
1101: p_data => x_msg_data );
1102: IF g_fnd_debug = 'Y' then

Line 1099: FND_MSG_PUB.Count_And_Get

1095: x_return_status := FND_API.G_RET_STS_ERROR;
1096: x_update_allowed := 'N';
1097: FND_MESSAGE.set_name('PO', 'PO_NO_UPDATE_ALLOWED');
1098: FND_MSG_PUB.Add;
1099: FND_MSG_PUB.Count_And_Get
1100: (p_count => x_msg_count,
1101: p_data => x_msg_data );
1102: IF g_fnd_debug = 'Y' then
1103: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1113: FND_MSG_PUB.Count_And_Get

1109:
1110: WHEN FND_API.G_EXC_ERROR then
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112: x_update_allowed := 'N';
1113: FND_MSG_PUB.Count_And_Get
1114: (p_count => x_msg_count,
1115: p_data => x_msg_data );
1116: IF g_fnd_debug = 'Y' then
1117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1122: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

1118: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1119: MODULE =>g_module_prefix||l_api_name,
1120: MESSAGE =>'600:Exception Expected error ');
1121: END IF;
1122: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1123: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1124: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1125: MODULE =>g_module_prefix||l_api_name,
1126: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line 1126: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

1122: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1123: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1124: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1125: MODULE =>g_module_prefix||l_api_name,
1126: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1127: END IF;
1128: END LOOP;
1129:
1130: END IF;

Line 1134: FND_MSG_PUB.Count_And_Get

1130: END IF;
1131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1133: x_update_allowed := 'N';
1134: FND_MSG_PUB.Count_And_Get
1135: (p_count => x_msg_count,
1136: p_data => x_msg_data );
1137: IF g_fnd_debug = 'Y' then
1138: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1143: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

1139: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1140: MODULE =>g_module_prefix||l_api_name,
1141: MESSAGE =>'610:Exception UnExpected error ');
1142: END IF;
1143: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1145: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1146: MODULE =>g_module_prefix||l_api_name,
1147: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line 1147: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

1143: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1145: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1146: MODULE =>g_module_prefix||l_api_name,
1147: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1148: END IF;
1149: END LOOP;
1150:
1151: END IF;

Line 1157: IF FND_MSG_PUB.Check_Msg_Level

1153: WHEN OTHERS THEN
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: X_update_allowed := 'N';
1156:
1157: IF FND_MSG_PUB.Check_Msg_Level
1158: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: FND_MSG_PUB.Add_Exc_Msg
1161: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',

Line 1158: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: X_update_allowed := 'N';
1156:
1157: IF FND_MSG_PUB.Check_Msg_Level
1158: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: FND_MSG_PUB.Add_Exc_Msg
1161: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1162: p_procedure_name => l_api_name);

Line 1160: FND_MSG_PUB.Add_Exc_Msg

1156:
1157: IF FND_MSG_PUB.Check_Msg_Level
1158: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: FND_MSG_PUB.Add_Exc_Msg
1161: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1162: p_procedure_name => l_api_name);
1163: END IF; --msg level
1164: FND_MSG_PUB.Count_And_Get

Line 1164: FND_MSG_PUB.Count_And_Get

1160: FND_MSG_PUB.Add_Exc_Msg
1161: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1162: p_procedure_name => l_api_name);
1163: END IF; --msg level
1164: FND_MSG_PUB.Count_And_Get
1165: (p_count => x_msg_count,
1166: p_data => x_msg_data );
1167: IF g_fnd_debug = 'Y' then
1168: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1306: FND_MSG_PUB.initialize;

1302: END IF;
1303:
1304: -- Initialize message list if p_init_msg_list is set to TRUE.
1305: IF FND_API.to_Boolean(p_init_msg_list ) THEN
1306: FND_MSG_PUB.initialize;
1307: END IF;
1308:
1309: -- Initialize API return status to success
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1359: FND_MSG_PUB.Add;

1355: ELSE
1356: Fnd_message.set_name('PO','PO_VALUE_MISSING');
1357: Fnd_message.set_token( token => 'VARIABLE'
1358: , VALUE => 'p_callout_string');
1359: FND_MSG_PUB.Add;
1360: x_return_status := FND_API.G_RET_STS_ERROR;
1361: RAISE FND_API.G_EXC_ERROR;
1362:
1363: END IF;-- p_callout _string

Line 1515: FND_MSG_PUB.Add;

1511:
1512: Fnd_message.set_name('PO','PO_VALUE_MISSING');
1513: Fnd_message.set_token( token => 'VARIABLE'
1514: , VALUE => 'p_template_changed');
1515: FND_MSG_PUB.Add;
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: RAISE FND_API.G_EXC_ERROR;
1518:
1519: END IF; -- if p_template_changed other than Y or D

Line 1545: FND_MSG_PUB.Add;

1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542: X_update_allowed := 'N';
1543: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1544: FND_MESSAGE.set_name('PO', 'PO_NO_TEMPLATE_CHANGE');
1545: FND_MSG_PUB.Add;
1546: FND_MSG_PUB.Count_And_Get
1547: (p_count => x_msg_count,
1548: p_data => x_msg_data );
1549: IF g_fnd_debug = 'Y' then

Line 1546: FND_MSG_PUB.Count_And_Get

1542: X_update_allowed := 'N';
1543: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1544: FND_MESSAGE.set_name('PO', 'PO_NO_TEMPLATE_CHANGE');
1545: FND_MSG_PUB.Add;
1546: FND_MSG_PUB.Count_And_Get
1547: (p_count => x_msg_count,
1548: p_data => x_msg_data );
1549: IF g_fnd_debug = 'Y' then
1550: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1559: FND_MSG_PUB.Count_And_Get

1555: END IF;
1556: WHEN FND_API.G_EXC_ERROR then
1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1559: FND_MSG_PUB.Count_And_Get
1560: (p_count => x_msg_count,
1561: p_data => x_msg_data );
1562: IF g_fnd_debug = 'Y' then
1563: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1568: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

1564: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1565: MODULE =>g_module_prefix||l_api_name,
1566: MESSAGE =>'470: expected error ');
1567: END IF;
1568: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1569: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1570: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1571: MODULE =>g_module_prefix||l_api_name,
1572: MESSAGE =>'470:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line 1572: MESSAGE =>'470:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

1568: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1569: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1570: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1571: MODULE =>g_module_prefix||l_api_name,
1572: MESSAGE =>'470:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1573: END IF;
1574: END LOOP;
1575: END IF;
1576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1579: FND_MSG_PUB.Count_And_Get

1575: END IF;
1576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1578: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1579: FND_MSG_PUB.Count_And_Get
1580: (p_count => x_msg_count,
1581: p_data => x_msg_data );
1582: IF g_fnd_debug = 'Y' then
1583: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1588: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

1584: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1585: MODULE =>g_module_prefix||l_api_name,
1586: MESSAGE =>'480:Exception UnExpected error ');
1587: END IF;
1588: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1590: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1591: MODULE =>g_module_prefix||l_api_name,
1592: MESSAGE =>'480:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line 1592: MESSAGE =>'480:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

1588: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1590: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1591: MODULE =>g_module_prefix||l_api_name,
1592: MESSAGE =>'480:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1593: END IF;
1594: END LOOP;
1595:
1596: END IF;

Line 1601: IF FND_MSG_PUB.Check_Msg_Level

1597:
1598: WHEN OTHERS THEN
1599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1600: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1601: IF FND_MSG_PUB.Check_Msg_Level
1602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1603: THEN
1604: FND_MSG_PUB.Add_Exc_Msg
1605: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',

Line 1602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1598: WHEN OTHERS THEN
1599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1600: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1601: IF FND_MSG_PUB.Check_Msg_Level
1602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1603: THEN
1604: FND_MSG_PUB.Add_Exc_Msg
1605: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1606: p_procedure_name => l_api_name);

Line 1604: FND_MSG_PUB.Add_Exc_Msg

1600: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1601: IF FND_MSG_PUB.Check_Msg_Level
1602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1603: THEN
1604: FND_MSG_PUB.Add_Exc_Msg
1605: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1606: p_procedure_name => l_api_name);
1607: END IF; --msg level
1608: FND_MSG_PUB.Count_And_Get

Line 1608: FND_MSG_PUB.Count_And_Get

1604: FND_MSG_PUB.Add_Exc_Msg
1605: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1606: p_procedure_name => l_api_name);
1607: END IF; --msg level
1608: FND_MSG_PUB.Count_And_Get
1609: (p_count => x_msg_count,
1610: p_data => x_msg_data );
1611: IF g_fnd_debug = 'Y' then
1612: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1709: FND_MSG_PUB.initialize;

1705: END IF;
1706:
1707: -- Initialize message list if p_init_msg_list is set to TRUE.
1708: IF FND_API.to_Boolean(p_init_msg_list ) THEN
1709: FND_MSG_PUB.initialize;
1710: END IF;
1711:
1712: -- Initialize API return status to success
1713: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1720: FND_MSG_PUB.Add;

1716: IF p_doc_id is null then
1717: Fnd_message.set_name('PO','PO_VALUE_MISSING');
1718: Fnd_message.set_token( token => 'VARIABLE'
1719: , VALUE => 'p_doc_id');
1720: FND_MSG_PUB.Add;
1721: x_return_status := FND_API.G_RET_STS_ERROR;
1722: RAISE FND_API.G_EXC_ERROR;
1723: END IF;
1724:

Line 1987: FND_MSG_PUB.Count_And_Get

1983: EXCEPTION
1984:
1985: WHEN FND_API.G_EXC_ERROR then
1986: x_return_status := FND_API.G_RET_STS_ERROR;
1987: FND_MSG_PUB.Count_And_Get
1988: (p_count => x_msg_count,
1989: p_data => x_msg_data );
1990: IF g_fnd_debug = 'Y' then
1991: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1996: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

1992: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1993: MODULE =>g_module_prefix||l_api_name,
1994: MESSAGE =>'600:Exception Expected error ');
1995: END IF;
1996: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1997: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1998: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1999: MODULE =>g_module_prefix||l_api_name,
2000: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line 2000: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

1996: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1997: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1998: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1999: MODULE =>g_module_prefix||l_api_name,
2000: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2001: END IF;
2002: END LOOP;
2003:
2004: END IF;

Line 2007: FND_MSG_PUB.Count_And_Get

2003:
2004: END IF;
2005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
2006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2007: FND_MSG_PUB.Count_And_Get
2008: (p_count => x_msg_count,
2009: p_data => x_msg_data );
2010: IF g_fnd_debug = 'Y' then
2011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 2016: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

2012: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2013: MODULE =>g_module_prefix||l_api_name,
2014: MESSAGE =>'610:Exception UnExpected error ');
2015: END IF;
2016: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2017: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2018: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2019: MODULE =>g_module_prefix||l_api_name,
2020: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line 2020: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

2016: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2017: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2018: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2019: MODULE =>g_module_prefix||l_api_name,
2020: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2021: END IF;
2022: END LOOP;
2023:
2024: END IF;

Line 2028: IF FND_MSG_PUB.Check_Msg_Level

2024: END IF;
2025:
2026: WHEN OTHERS THEN
2027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2028: IF FND_MSG_PUB.Check_Msg_Level
2029: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2030: THEN
2031: FND_MSG_PUB.Add_Exc_Msg
2032: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',

Line 2029: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2025:
2026: WHEN OTHERS THEN
2027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2028: IF FND_MSG_PUB.Check_Msg_Level
2029: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2030: THEN
2031: FND_MSG_PUB.Add_Exc_Msg
2032: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
2033: p_procedure_name => l_api_name);

Line 2031: FND_MSG_PUB.Add_Exc_Msg

2027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2028: IF FND_MSG_PUB.Check_Msg_Level
2029: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2030: THEN
2031: FND_MSG_PUB.Add_Exc_Msg
2032: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
2033: p_procedure_name => l_api_name);
2034: END IF; --msg level
2035: FND_MSG_PUB.Count_And_Get

Line 2035: FND_MSG_PUB.Count_And_Get

2031: FND_MSG_PUB.Add_Exc_Msg
2032: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
2033: p_procedure_name => l_api_name);
2034: END IF; --msg level
2035: FND_MSG_PUB.Count_And_Get
2036: (p_count => x_msg_count,
2037: p_data => x_msg_data );
2038: IF g_fnd_debug = 'Y' then
2039: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 2161: FND_MSG_PUB.initialize;

2157: END IF;
2158:
2159: -- Initialize message list if p_init_msg_list is set to TRUE.
2160: IF FND_API.to_Boolean(p_init_msg_list ) THEN
2161: FND_MSG_PUB.initialize;
2162: END IF;
2163:
2164: -- Initialize API return status to success
2165: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2172: FND_MSG_PUB.Add;

2168: IF p_doc_id is null then
2169: Fnd_message.set_name('PO','PO_VALUE_MISSING');
2170: Fnd_message.set_token( token => 'VARIABLE'
2171: , VALUE => 'p_doc_id');
2172: FND_MSG_PUB.Add;
2173: x_return_status := FND_API.G_RET_STS_ERROR;
2174: RAISE FND_API.G_EXC_ERROR;
2175: END IF;
2176:

Line 2816: FND_MSG_PUB.Count_And_Get

2812: EXCEPTION
2813:
2814: WHEN FND_API.G_EXC_ERROR then
2815: x_return_status := FND_API.G_RET_STS_ERROR;
2816: FND_MSG_PUB.Count_And_Get
2817: (p_count => x_msg_count,
2818: p_data => x_msg_data );
2819: IF g_fnd_debug = 'Y' then
2820: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 2825: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

2821: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2822: MODULE =>g_module_prefix||l_api_name,
2823: MESSAGE =>'400:Exception Expected error ');
2824: END IF;
2825: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2826: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2827: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2828: MODULE =>g_module_prefix||l_api_name,
2829: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line 2829: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

2825: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2826: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2827: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2828: MODULE =>g_module_prefix||l_api_name,
2829: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2830: END IF;
2831: END LOOP;
2832: END IF;
2833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2835: FND_MSG_PUB.Count_And_Get

2831: END LOOP;
2832: END IF;
2833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
2834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2835: FND_MSG_PUB.Count_And_Get
2836: (p_count => x_msg_count,
2837: p_data => x_msg_data );
2838: IF g_fnd_debug = 'Y' then
2839: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 2844: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

2840: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2841: MODULE =>g_module_prefix||l_api_name,
2842: MESSAGE =>'410:Exception Expected error ');
2843: END IF;
2844: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2846: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2847: MODULE =>g_module_prefix||l_api_name,
2848: MESSAGE =>'410:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line 2848: MESSAGE =>'410:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

2844: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2846: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2847: MODULE =>g_module_prefix||l_api_name,
2848: MESSAGE =>'410:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2849: END IF;
2850: END LOOP;
2851:
2852: END IF;

Line 2856: IF FND_MSG_PUB.Check_Msg_Level

2852: END IF;
2853:
2854: WHEN OTHERS THEN
2855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2856: IF FND_MSG_PUB.Check_Msg_Level
2857: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2858: THEN
2859: FND_MSG_PUB.Add_Exc_Msg
2860: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',

Line 2857: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2853:
2854: WHEN OTHERS THEN
2855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2856: IF FND_MSG_PUB.Check_Msg_Level
2857: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2858: THEN
2859: FND_MSG_PUB.Add_Exc_Msg
2860: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
2861: p_procedure_name => l_api_name);

Line 2859: FND_MSG_PUB.Add_Exc_Msg

2855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2856: IF FND_MSG_PUB.Check_Msg_Level
2857: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2858: THEN
2859: FND_MSG_PUB.Add_Exc_Msg
2860: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
2861: p_procedure_name => l_api_name);
2862: END IF; --msg level
2863: FND_MSG_PUB.Count_And_Get

Line 2863: FND_MSG_PUB.Count_And_Get

2859: FND_MSG_PUB.Add_Exc_Msg
2860: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
2861: p_procedure_name => l_api_name);
2862: END IF; --msg level
2863: FND_MSG_PUB.Count_And_Get
2864: (p_count => x_msg_count,
2865: p_data => x_msg_data );
2866: IF g_fnd_debug = 'Y' then
2867: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 2954: FND_MSG_PUB.initialize;

2950: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2951:
2952: -- initialize meesage list
2953: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2954: FND_MSG_PUB.initialize;
2955: END IF;
2956:
2957:
2958: /* Mod changes */

Line 3013: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

3009:
3010: EXCEPTION
3011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3013: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
3014: ,p_data => x_msg_data);
3015: WHEN OTHERS THEN
3016: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3017: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 3017: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3013: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
3014: ,p_data => x_msg_data);
3015: WHEN OTHERS THEN
3016: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3017: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3018: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3019: IF (g_fnd_debug='Y') THEN
3020: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3021: FND_LOG.string(log_level => FND_LOG.level_unexpected

Line 3018: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3014: ,p_data => x_msg_data);
3015: WHEN OTHERS THEN
3016: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3017: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3018: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3019: IF (g_fnd_debug='Y') THEN
3020: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3021: FND_LOG.string(log_level => FND_LOG.level_unexpected
3022: ,module => g_module_prefix ||l_api_name

Line 3027: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

3023: ,message => SQLERRM);
3024: END IF;
3025: END IF;
3026: END IF;
3027: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
3028: ,p_data => x_msg_data);
3029: END Get_Last_Signed_Revision;
3030:
3031: ----------------------------------------------------------------------------------

Line 3282: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count

3278:
3279: Exception
3280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3282: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
3283: ,p_data => l_msg_data);
3284: WHEN OTHERS THEN
3285: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 3286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3282: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
3283: ,p_data => l_msg_data);
3284: WHEN OTHERS THEN
3285: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3287: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3288: IF (g_fnd_debug='Y') THEN
3289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3290: FND_LOG.string(log_level => FND_LOG.level_unexpected

Line 3287: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3283: ,p_data => l_msg_data);
3284: WHEN OTHERS THEN
3285: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3287: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3288: IF (g_fnd_debug='Y') THEN
3289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3290: FND_LOG.string(log_level => FND_LOG.level_unexpected
3291: ,module => g_module_prefix ||l_api_name

Line 3296: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count

3292: ,message => SQLERRM);
3293: END IF;
3294: END IF;
3295: END IF;
3296: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
3297: ,p_data => l_msg_data);
3298: End Auto_Apply_ConTerms;
3299:
3300:

Line 3518: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count

3514:
3515: EXCEPTION
3516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3518: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
3519: ,p_data => l_msg_data);
3520: WHEN OTHERS THEN
3521: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 3522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3518: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
3519: ,p_data => l_msg_data);
3520: WHEN OTHERS THEN
3521: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3523: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3524: IF (g_fnd_debug='Y') THEN
3525: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3526: FND_LOG.string(log_level => FND_LOG.level_unexpected

Line 3523: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3519: ,p_data => l_msg_data);
3520: WHEN OTHERS THEN
3521: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3523: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3524: IF (g_fnd_debug='Y') THEN
3525: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3526: FND_LOG.string(log_level => FND_LOG.level_unexpected
3527: ,module => g_module_prefix ||l_api_name

Line 3532: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count

3528: ,message => SQLERRM);
3529: END IF;
3530: END IF;
3531: END IF;
3532: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
3533: ,p_data => l_msg_data);
3534: End Copy_Conterms_Mod;
3535: --CLM Mod
3536:

Line 3716: fnd_msg_pub.count_and_get (p_count => l_msg_count,

3712: EXCEPTION
3713: WHEN fnd_api.g_exc_unexpected_error
3714: THEN
3715: x_return_status := fnd_api.g_ret_sts_unexp_error;
3716: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3717: p_data => l_msg_data);
3718: WHEN OTHERS
3719: THEN
3720: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3722: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3718: WHEN OTHERS
3719: THEN
3720: x_return_status := fnd_api.g_ret_sts_unexp_error;
3721:
3722: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3723: THEN
3724: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3725:
3726: IF (g_fnd_debug = 'Y')

Line 3724: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3720: x_return_status := fnd_api.g_ret_sts_unexp_error;
3721:
3722: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3723: THEN
3724: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3725:
3726: IF (g_fnd_debug = 'Y')
3727: THEN
3728: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 3737: fnd_msg_pub.count_and_get (p_count => l_msg_count,

3733: END IF;
3734: END IF;
3735: END IF;
3736:
3737: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3738: p_data => l_msg_data);
3739: END get_def_proc_contract_info;
3740:
3741: ----------------------------------------------------------------------------------

Line 3882: fnd_msg_pub.count_and_get (p_count => l_msg_count,

3878: EXCEPTION
3879: WHEN fnd_api.g_exc_unexpected_error
3880: THEN
3881: x_return_status := fnd_api.g_ret_sts_unexp_error;
3882: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3883: p_data => l_msg_data);
3884: WHEN OTHERS
3885: THEN
3886: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3888: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3884: WHEN OTHERS
3885: THEN
3886: x_return_status := fnd_api.g_ret_sts_unexp_error;
3887:
3888: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3889: THEN
3890: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3891:
3892: IF (g_fnd_debug = 'Y')

Line 3890: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3886: x_return_status := fnd_api.g_ret_sts_unexp_error;
3887:
3888: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3889: THEN
3890: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3891:
3892: IF (g_fnd_debug = 'Y')
3893: THEN
3894: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 3903: fnd_msg_pub.count_and_get (p_count => l_msg_count,

3899: END IF;
3900: END IF;
3901: END IF;
3902:
3903: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3904: p_data => l_msg_data);
3905: END Get_Contract_Details;
3906:
3907: ----------------------------------------------------------------------------------