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 103: FND_MSG_PUB.initialize;

99: x_return_status:= FND_API.G_RET_STS_SUCCESS;
100:
101: -- initialize meesage list
102: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: x_contracts_enabled := is_contracts_enabled;
107:

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

107:
108: EXCEPTION
109: WHEN OTHERS THEN
110: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
112: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
113: IF (g_fnd_debug='Y') THEN
114: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
115: FND_LOG.string(log_level => FND_LOG.level_unexpected

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

108: EXCEPTION
109: WHEN OTHERS THEN
110: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
112: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
113: IF (g_fnd_debug='Y') THEN
114: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
115: FND_LOG.string(log_level => FND_LOG.level_unexpected
116: ,module => g_module_prefix ||l_api_name

Line 121: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

117: ,message => SQLERRM);
118: END IF;
119: END IF;
120: END IF;
121: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
122: ,p_data => x_msg_data);
123: END is_contracts_enabled;
124:
125:

Line 248: FND_MSG_PUB.initialize;

244: x_return_status:= FND_API.G_RET_STS_SUCCESS;
245:
246: -- initialize meesage list
247: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
248: FND_MSG_PUB.initialize;
249: END IF;
250:
251: -- parse the contracts document type to type lookup
252: l_document_type := SUBSTR(p_document_type, 1, 2);

Line 276: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

272:
273: EXCEPTION
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
277: ,p_data => x_msg_data);
278: WHEN OTHERS THEN
279: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

276: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
277: ,p_data => x_msg_data);
278: WHEN OTHERS THEN
279: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
282: IF (g_fnd_debug='Y') THEN
283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
284: FND_LOG.string(log_level => FND_LOG.level_unexpected

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

277: ,p_data => x_msg_data);
278: WHEN OTHERS THEN
279: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
282: IF (g_fnd_debug='Y') THEN
283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
284: FND_LOG.string(log_level => FND_LOG.level_unexpected
285: ,module => g_module_prefix ||l_api_name

Line 290: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

286: ,message => SQLERRM);
287: END IF;
288: END IF;
289: END IF;
290: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
291: ,p_data => x_msg_data);
292: END get_external_userlist;
293:
294: -------------------------------------------------------------------------------

Line 379: FND_MSG_PUB.initialize;

375: x_return_status:= FND_API.G_RET_STS_SUCCESS;
376:
377: -- initialize meesage list
378: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
379: FND_MSG_PUB.initialize;
380: END IF;
381:
382: -- parse the contracts document type to type lookup
383: l_document_type := SUBSTR(p_document_type, 1, 2);

Line 412: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

408:
409: EXCEPTION
410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
413: ,p_data => x_msg_data);
414: WHEN OTHERS THEN
415: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

412: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
413: ,p_data => x_msg_data);
414: WHEN OTHERS THEN
415: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
417: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
418: IF (g_fnd_debug='Y') THEN
419: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
420: FND_LOG.string(log_level => FND_LOG.level_unexpected

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

413: ,p_data => x_msg_data);
414: WHEN OTHERS THEN
415: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
417: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
418: IF (g_fnd_debug='Y') THEN
419: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
420: FND_LOG.string(log_level => FND_LOG.level_unexpected
421: ,module => g_module_prefix ||l_api_name

Line 426: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

422: ,message => SQLERRM);
423: END IF;
424: END IF;
425: END IF;
426: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
427: ,p_data => x_msg_data);
428: END get_external_userlist;
429:
430: -------------------------------------------------------------------------------

Line 509: FND_MSG_PUB.initialize;

505: x_return_status:= FND_API.G_RET_STS_SUCCESS;
506:
507: -- initialize meesage list
508: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
509: FND_MSG_PUB.initialize;
510: END IF;
511:
512: -- what: for the given document id, bulk collect item categories
513: -- into the PL/SQL table

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

561:
562: EXCEPTION
563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
566: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
567: IF (g_fnd_debug='Y') THEN
568: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
569: FND_LOG.string(log_level => FND_LOG.level_unexpected

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

562: EXCEPTION
563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
566: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
567: IF (g_fnd_debug='Y') THEN
568: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
569: FND_LOG.string(log_level => FND_LOG.level_unexpected
570: ,module => g_module_prefix ||l_api_name

Line 575: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

571: ,message => SQLERRM);
572: END IF;
573: END IF;
574: END IF;
575: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
576: ,p_data => x_msg_data);
577:
578: END get_item_categorylist;
579:

Line 699: FND_MSG_PUB.initialize;

695: END IF;
696:
697: -- Initialize message list if p_init_msg_list is set to TRUE.
698: IF FND_API.to_Boolean(p_init_msg_list ) THEN
699: FND_MSG_PUB.initialize;
700: END IF;
701:
702: -- Initialize API return status to success
703: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 719: FND_MSG_PUB.Add;

715: IF p_header_id is null then
716: Fnd_message.set_name('PO','PO_VALUE_MISSING');
717: Fnd_message.set_token( token => 'VARIABLE'
718: , VALUE => 'p_header_id');
719: FND_MSG_PUB.Add;
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: RAISE FND_API.G_EXC_ERROR;
722: END IF;
723:

Line 743: FND_MSG_PUB.Add;

739: ELSE
740: Fnd_message.set_name('PO','PO_VALUE_MISSING');
741: Fnd_message.set_token( token => 'VARIABLE'
742: , VALUE => 'p_callout_string');
743: FND_MSG_PUB.Add;
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: RAISE FND_API.G_EXC_ERROR;
746:
747: END IF;-- p_callout _string

Line 774: FND_MSG_PUB.Add;

770: IF l_callout_status is null then
771: Fnd_message.set_name('PO','PO_VALUE_MISSING');
772: Fnd_message.set_token( token => 'VARIABLE'
773: , VALUE => 'callout_status');
774: FND_MSG_PUB.Add;
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;
778: IF l_callout_revision is null then

Line 782: FND_MSG_PUB.Add;

778: IF l_callout_revision is null then
779: Fnd_message.set_name('PO','PO_VALUE_MISSING');
780: Fnd_message.set_token( token => 'VARIABLE'
781: , VALUE => 'callout_revision');
782: FND_MSG_PUB.Add;
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: RAISE FND_API.G_EXC_ERROR;
785: END IF;
786: BEGIN

Line 800: FND_MSG_PUB.Add;

796:
797: EXCEPTION
798: WHEN NO_DATA_FOUND then
799: Fnd_message.set_name('PO','PO_DOESNOT_EXIST');
800: FND_MSG_PUB.Add;
801: x_return_status := FND_API.G_RET_STS_ERROR;
802: RAISE FND_API.G_EXC_ERROR;
803:
804: END;

Line 826: FND_MSG_PUB.Add;

822: If l_emp_id is null then
823: Fnd_message.set_name('PO','PO_VALUE_MISSING');
824: Fnd_message.set_token( token => 'VARIABLE'
825: , VALUE => 'emp_id_in_callout_str');
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;--emp id is null
830: --Check if current user is the current approver for the PO

Line 955: FND_MSG_PUB.Add;

951: WHEN l_STATUS_CHANGED then
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: x_update_allowed := 'N';
954: FND_MESSAGE.set_name('PO', 'PO_STATUS_CHANGED');
955: FND_MSG_PUB.Add;
956: FND_MSG_PUB.Count_And_Get
957: (p_count => x_msg_count,
958: p_data => x_msg_data );
959: IF g_fnd_debug = 'Y' then

Line 956: FND_MSG_PUB.Count_And_Get

952: x_return_status := FND_API.G_RET_STS_ERROR;
953: x_update_allowed := 'N';
954: FND_MESSAGE.set_name('PO', 'PO_STATUS_CHANGED');
955: FND_MSG_PUB.Add;
956: FND_MSG_PUB.Count_And_Get
957: (p_count => x_msg_count,
958: p_data => x_msg_data );
959: IF g_fnd_debug = 'Y' then
960: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 972: FND_MSG_PUB.Add;

968: WHEN l_DONOT_UPDATE then
969: x_return_status := FND_API.G_RET_STS_ERROR;
970: x_update_allowed := 'N';
971: FND_MESSAGE.set_name('PO', 'PO_NO_UPDATE_ALLOWED');
972: FND_MSG_PUB.Add;
973: FND_MSG_PUB.Count_And_Get
974: (p_count => x_msg_count,
975: p_data => x_msg_data );
976: IF g_fnd_debug = 'Y' then

Line 973: FND_MSG_PUB.Count_And_Get

969: x_return_status := FND_API.G_RET_STS_ERROR;
970: x_update_allowed := 'N';
971: FND_MESSAGE.set_name('PO', 'PO_NO_UPDATE_ALLOWED');
972: FND_MSG_PUB.Add;
973: FND_MSG_PUB.Count_And_Get
974: (p_count => x_msg_count,
975: p_data => x_msg_data );
976: IF g_fnd_debug = 'Y' then
977: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 987: FND_MSG_PUB.Count_And_Get

983:
984: WHEN FND_API.G_EXC_ERROR then
985: x_return_status := FND_API.G_RET_STS_ERROR;
986: x_update_allowed := 'N';
987: FND_MSG_PUB.Count_And_Get
988: (p_count => x_msg_count,
989: p_data => x_msg_data );
990: IF g_fnd_debug = 'Y' then
991: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

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

992: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
993: MODULE =>g_module_prefix||l_api_name,
994: MESSAGE =>'600:Exception Expected error ');
995: END IF;
996: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
997: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
998: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
999: MODULE =>g_module_prefix||l_api_name,
1000: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

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

996: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
997: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
998: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
999: MODULE =>g_module_prefix||l_api_name,
1000: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1001: END IF;
1002: END LOOP;
1003:
1004: END IF;

Line 1008: FND_MSG_PUB.Count_And_Get

1004: END IF;
1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1007: x_update_allowed := 'N';
1008: FND_MSG_PUB.Count_And_Get
1009: (p_count => x_msg_count,
1010: p_data => x_msg_data );
1011: IF g_fnd_debug = 'Y' then
1012: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

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

1013: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1014: MODULE =>g_module_prefix||l_api_name,
1015: MESSAGE =>'610:Exception UnExpected error ');
1016: END IF;
1017: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1018: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1019: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1020: MODULE =>g_module_prefix||l_api_name,
1021: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

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

1017: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1018: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1019: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1020: MODULE =>g_module_prefix||l_api_name,
1021: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1022: END IF;
1023: END LOOP;
1024:
1025: END IF;

Line 1031: IF FND_MSG_PUB.Check_Msg_Level

1027: WHEN OTHERS THEN
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: X_update_allowed := 'N';
1030:
1031: IF FND_MSG_PUB.Check_Msg_Level
1032: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1033: THEN
1034: FND_MSG_PUB.Add_Exc_Msg
1035: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',

Line 1032: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: X_update_allowed := 'N';
1030:
1031: IF FND_MSG_PUB.Check_Msg_Level
1032: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1033: THEN
1034: FND_MSG_PUB.Add_Exc_Msg
1035: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1036: p_procedure_name => l_api_name);

Line 1034: FND_MSG_PUB.Add_Exc_Msg

1030:
1031: IF FND_MSG_PUB.Check_Msg_Level
1032: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1033: THEN
1034: FND_MSG_PUB.Add_Exc_Msg
1035: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1036: p_procedure_name => l_api_name);
1037: END IF; --msg level
1038: FND_MSG_PUB.Count_And_Get

Line 1038: FND_MSG_PUB.Count_And_Get

1034: FND_MSG_PUB.Add_Exc_Msg
1035: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1036: p_procedure_name => l_api_name);
1037: END IF; --msg level
1038: FND_MSG_PUB.Count_And_Get
1039: (p_count => x_msg_count,
1040: p_data => x_msg_data );
1041: IF g_fnd_debug = 'Y' then
1042: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1176: FND_MSG_PUB.initialize;

1172: END IF;
1173:
1174: -- Initialize message list if p_init_msg_list is set to TRUE.
1175: IF FND_API.to_Boolean(p_init_msg_list ) THEN
1176: FND_MSG_PUB.initialize;
1177: END IF;
1178:
1179: -- Initialize API return status to success
1180: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1222: FND_MSG_PUB.Add;

1218: ELSE
1219: Fnd_message.set_name('PO','PO_VALUE_MISSING');
1220: Fnd_message.set_token( token => 'VARIABLE'
1221: , VALUE => 'p_callout_string');
1222: FND_MSG_PUB.Add;
1223: x_return_status := FND_API.G_RET_STS_ERROR;
1224: RAISE FND_API.G_EXC_ERROR;
1225:
1226: END IF;-- p_callout _string

Line 1348: FND_MSG_PUB.Add;

1344:
1345: Fnd_message.set_name('PO','PO_VALUE_MISSING');
1346: Fnd_message.set_token( token => 'VARIABLE'
1347: , VALUE => 'p_template_changed');
1348: FND_MSG_PUB.Add;
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350: RAISE FND_API.G_EXC_ERROR;
1351:
1352: END IF; -- if p_template_changed other than Y or D

Line 1378: FND_MSG_PUB.Add;

1374: x_return_status := FND_API.G_RET_STS_ERROR;
1375: X_update_allowed := 'N';
1376: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1377: FND_MESSAGE.set_name('PO', 'PO_NO_TEMPLATE_CHANGE');
1378: FND_MSG_PUB.Add;
1379: FND_MSG_PUB.Count_And_Get
1380: (p_count => x_msg_count,
1381: p_data => x_msg_data );
1382: IF g_fnd_debug = 'Y' then

Line 1379: FND_MSG_PUB.Count_And_Get

1375: X_update_allowed := 'N';
1376: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1377: FND_MESSAGE.set_name('PO', 'PO_NO_TEMPLATE_CHANGE');
1378: FND_MSG_PUB.Add;
1379: FND_MSG_PUB.Count_And_Get
1380: (p_count => x_msg_count,
1381: p_data => x_msg_data );
1382: IF g_fnd_debug = 'Y' then
1383: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1392: FND_MSG_PUB.Count_And_Get

1388: END IF;
1389: WHEN FND_API.G_EXC_ERROR then
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1392: FND_MSG_PUB.Count_And_Get
1393: (p_count => x_msg_count,
1394: p_data => x_msg_data );
1395: IF g_fnd_debug = 'Y' then
1396: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

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

1397: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1398: MODULE =>g_module_prefix||l_api_name,
1399: MESSAGE =>'470: expected error ');
1400: END IF;
1401: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1402: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1403: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1404: MODULE =>g_module_prefix||l_api_name,
1405: MESSAGE =>'470:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

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

1401: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1402: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1403: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1404: MODULE =>g_module_prefix||l_api_name,
1405: MESSAGE =>'470:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1406: END IF;
1407: END LOOP;
1408: END IF;
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1412: FND_MSG_PUB.Count_And_Get

1408: END IF;
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1411: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1412: FND_MSG_PUB.Count_And_Get
1413: (p_count => x_msg_count,
1414: p_data => x_msg_data );
1415: IF g_fnd_debug = 'Y' then
1416: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

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

1417: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1418: MODULE =>g_module_prefix||l_api_name,
1419: MESSAGE =>'480:Exception UnExpected error ');
1420: END IF;
1421: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1422: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1423: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1424: MODULE =>g_module_prefix||l_api_name,
1425: MESSAGE =>'480:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

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

1421: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1422: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1423: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1424: MODULE =>g_module_prefix||l_api_name,
1425: MESSAGE =>'480:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1426: END IF;
1427: END LOOP;
1428:
1429: END IF;

Line 1434: IF FND_MSG_PUB.Check_Msg_Level

1430:
1431: WHEN OTHERS THEN
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1434: IF FND_MSG_PUB.Check_Msg_Level
1435: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg
1438: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',

Line 1435: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1431: WHEN OTHERS THEN
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1434: IF FND_MSG_PUB.Check_Msg_Level
1435: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg
1438: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1439: p_procedure_name => l_api_name);

Line 1437: FND_MSG_PUB.Add_Exc_Msg

1433: ROLLBACK TO SP_APPLY_TEMPLATE_CHANGE;
1434: IF FND_MSG_PUB.Check_Msg_Level
1435: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg
1438: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1439: p_procedure_name => l_api_name);
1440: END IF; --msg level
1441: FND_MSG_PUB.Count_And_Get

Line 1441: FND_MSG_PUB.Count_And_Get

1437: FND_MSG_PUB.Add_Exc_Msg
1438: (p_pkg_name => 'PO_CONTERMS_UTL_GRP',
1439: p_procedure_name => l_api_name);
1440: END IF; --msg level
1441: FND_MSG_PUB.Count_And_Get
1442: (p_count => x_msg_count,
1443: p_data => x_msg_data );
1444: IF g_fnd_debug = 'Y' then
1445: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1538: FND_MSG_PUB.initialize;

1534: END IF;
1535:
1536: -- Initialize message list if p_init_msg_list is set to TRUE.
1537: IF FND_API.to_Boolean(p_init_msg_list ) THEN
1538: FND_MSG_PUB.initialize;
1539: END IF;
1540:
1541: -- Initialize API return status to success
1542: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1549: FND_MSG_PUB.Add;

1545: IF p_doc_id is null then
1546: Fnd_message.set_name('PO','PO_VALUE_MISSING');
1547: Fnd_message.set_token( token => 'VARIABLE'
1548: , VALUE => 'p_doc_id');
1549: FND_MSG_PUB.Add;
1550: x_return_status := FND_API.G_RET_STS_ERROR;
1551: RAISE FND_API.G_EXC_ERROR;
1552: END IF;
1553:

Line 1802: FND_MSG_PUB.Count_And_Get

1798: EXCEPTION
1799:
1800: WHEN FND_API.G_EXC_ERROR then
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: FND_MSG_PUB.Count_And_Get
1803: (p_count => x_msg_count,
1804: p_data => x_msg_data );
1805: IF g_fnd_debug = 'Y' then
1806: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

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

1807: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1808: MODULE =>g_module_prefix||l_api_name,
1809: MESSAGE =>'600:Exception Expected error ');
1810: END IF;
1811: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1812: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1813: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1814: MODULE =>g_module_prefix||l_api_name,
1815: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

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

1811: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1812: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1813: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1814: MODULE =>g_module_prefix||l_api_name,
1815: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1816: END IF;
1817: END LOOP;
1818:
1819: END IF;

Line 1822: FND_MSG_PUB.Count_And_Get

1818:
1819: END IF;
1820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1822: FND_MSG_PUB.Count_And_Get
1823: (p_count => x_msg_count,
1824: p_data => x_msg_data );
1825: IF g_fnd_debug = 'Y' then
1826: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

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

1827: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1828: MODULE =>g_module_prefix||l_api_name,
1829: MESSAGE =>'610:Exception UnExpected error ');
1830: END IF;
1831: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1832: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1833: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1834: MODULE =>g_module_prefix||l_api_name,
1835: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

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

1831: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1832: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1833: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1834: MODULE =>g_module_prefix||l_api_name,
1835: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1836: END IF;
1837: END LOOP;
1838:
1839: END IF;

Line 1843: IF FND_MSG_PUB.Check_Msg_Level

1839: END IF;
1840:
1841: WHEN OTHERS THEN
1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1843: IF FND_MSG_PUB.Check_Msg_Level
1844: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1845: THEN
1846: FND_MSG_PUB.Add_Exc_Msg
1847: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',

Line 1844: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1840:
1841: WHEN OTHERS THEN
1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1843: IF FND_MSG_PUB.Check_Msg_Level
1844: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1845: THEN
1846: FND_MSG_PUB.Add_Exc_Msg
1847: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
1848: p_procedure_name => l_api_name);

Line 1846: FND_MSG_PUB.Add_Exc_Msg

1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1843: IF FND_MSG_PUB.Check_Msg_Level
1844: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1845: THEN
1846: FND_MSG_PUB.Add_Exc_Msg
1847: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
1848: p_procedure_name => l_api_name);
1849: END IF; --msg level
1850: FND_MSG_PUB.Count_And_Get

Line 1850: FND_MSG_PUB.Count_And_Get

1846: FND_MSG_PUB.Add_Exc_Msg
1847: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
1848: p_procedure_name => l_api_name);
1849: END IF; --msg level
1850: FND_MSG_PUB.Count_And_Get
1851: (p_count => x_msg_count,
1852: p_data => x_msg_data );
1853: IF g_fnd_debug = 'Y' then
1854: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1972: FND_MSG_PUB.initialize;

1968: END IF;
1969:
1970: -- Initialize message list if p_init_msg_list is set to TRUE.
1971: IF FND_API.to_Boolean(p_init_msg_list ) THEN
1972: FND_MSG_PUB.initialize;
1973: END IF;
1974:
1975: -- Initialize API return status to success
1976: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1983: FND_MSG_PUB.Add;

1979: IF p_doc_id is null then
1980: Fnd_message.set_name('PO','PO_VALUE_MISSING');
1981: Fnd_message.set_token( token => 'VARIABLE'
1982: , VALUE => 'p_doc_id');
1983: FND_MSG_PUB.Add;
1984: x_return_status := FND_API.G_RET_STS_ERROR;
1985: RAISE FND_API.G_EXC_ERROR;
1986: END IF;
1987:

Line 2482: FND_MSG_PUB.Count_And_Get

2478: EXCEPTION
2479:
2480: WHEN FND_API.G_EXC_ERROR then
2481: x_return_status := FND_API.G_RET_STS_ERROR;
2482: FND_MSG_PUB.Count_And_Get
2483: (p_count => x_msg_count,
2484: p_data => x_msg_data );
2485: IF g_fnd_debug = 'Y' then
2486: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

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

2487: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2488: MODULE =>g_module_prefix||l_api_name,
2489: MESSAGE =>'400:Exception Expected error ');
2490: END IF;
2491: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2492: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2493: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2494: MODULE =>g_module_prefix||l_api_name,
2495: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

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

2491: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2492: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2493: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2494: MODULE =>g_module_prefix||l_api_name,
2495: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2496: END IF;
2497: END LOOP;
2498: END IF;
2499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2501: FND_MSG_PUB.Count_And_Get

2497: END LOOP;
2498: END IF;
2499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
2500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2501: FND_MSG_PUB.Count_And_Get
2502: (p_count => x_msg_count,
2503: p_data => x_msg_data );
2504: IF g_fnd_debug = 'Y' then
2505: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

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

2506: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2507: MODULE =>g_module_prefix||l_api_name,
2508: MESSAGE =>'410:Exception Expected error ');
2509: END IF;
2510: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2511: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2512: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2513: MODULE =>g_module_prefix||l_api_name,
2514: MESSAGE =>'410:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

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

2510: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2511: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2512: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2513: MODULE =>g_module_prefix||l_api_name,
2514: MESSAGE =>'410:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2515: END IF;
2516: END LOOP;
2517:
2518: END IF;

Line 2522: IF FND_MSG_PUB.Check_Msg_Level

2518: END IF;
2519:
2520: WHEN OTHERS THEN
2521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2522: IF FND_MSG_PUB.Check_Msg_Level
2523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2524: THEN
2525: FND_MSG_PUB.Add_Exc_Msg
2526: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',

Line 2523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2519:
2520: WHEN OTHERS THEN
2521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2522: IF FND_MSG_PUB.Check_Msg_Level
2523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2524: THEN
2525: FND_MSG_PUB.Add_Exc_Msg
2526: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
2527: p_procedure_name => l_api_name);

Line 2525: FND_MSG_PUB.Add_Exc_Msg

2521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2522: IF FND_MSG_PUB.Check_Msg_Level
2523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2524: THEN
2525: FND_MSG_PUB.Add_Exc_Msg
2526: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
2527: p_procedure_name => l_api_name);
2528: END IF; --msg level
2529: FND_MSG_PUB.Count_And_Get

Line 2529: FND_MSG_PUB.Count_And_Get

2525: FND_MSG_PUB.Add_Exc_Msg
2526: (p_pkg_name => 'PO_CONTERMS_UTILS_GRP',
2527: p_procedure_name => l_api_name);
2528: END IF; --msg level
2529: FND_MSG_PUB.Count_And_Get
2530: (p_count => x_msg_count,
2531: p_data => x_msg_data );
2532: IF g_fnd_debug = 'Y' then
2533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 2617: FND_MSG_PUB.initialize;

2613: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2614:
2615: -- initialize meesage list
2616: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2617: FND_MSG_PUB.initialize;
2618: END IF;
2619:
2620: PO_SIGNATURE_PVT.get_last_signed_revision(
2621: p_po_header_id => p_header_id,

Line 2665: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

2661:
2662: EXCEPTION
2663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2665: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
2666: ,p_data => x_msg_data);
2667: WHEN OTHERS THEN
2668: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

2665: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
2666: ,p_data => x_msg_data);
2667: WHEN OTHERS THEN
2668: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2670: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2671: IF (g_fnd_debug='Y') THEN
2672: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2673: FND_LOG.string(log_level => FND_LOG.level_unexpected

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

2666: ,p_data => x_msg_data);
2667: WHEN OTHERS THEN
2668: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2670: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2671: IF (g_fnd_debug='Y') THEN
2672: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2673: FND_LOG.string(log_level => FND_LOG.level_unexpected
2674: ,module => g_module_prefix ||l_api_name

Line 2679: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

2675: ,message => SQLERRM);
2676: END IF;
2677: END IF;
2678: END IF;
2679: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
2680: ,p_data => x_msg_data);
2681: END Get_Last_Signed_Revision;
2682:
2683: ----------------------------------------------------------------------------------

Line 2936: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count

2932:
2933: Exception
2934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2936: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
2937: ,p_data => l_msg_data);
2938: WHEN OTHERS THEN
2939: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

2936: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
2937: ,p_data => l_msg_data);
2938: WHEN OTHERS THEN
2939: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2941: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2942: IF (g_fnd_debug='Y') THEN
2943: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2944: FND_LOG.string(log_level => FND_LOG.level_unexpected

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

2937: ,p_data => l_msg_data);
2938: WHEN OTHERS THEN
2939: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2941: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2942: IF (g_fnd_debug='Y') THEN
2943: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2944: FND_LOG.string(log_level => FND_LOG.level_unexpected
2945: ,module => g_module_prefix ||l_api_name

Line 2950: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count

2946: ,message => SQLERRM);
2947: END IF;
2948: END IF;
2949: END IF;
2950: FND_MSG_PUB.Count_and_Get(p_count => l_msg_count
2951: ,p_data => l_msg_data);
2952: End Auto_Apply_ConTerms;
2953:
2954:

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

3130: EXCEPTION
3131: WHEN fnd_api.g_exc_unexpected_error
3132: THEN
3133: x_return_status := fnd_api.g_ret_sts_unexp_error;
3134: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3135: p_data => l_msg_data);
3136: WHEN OTHERS
3137: THEN
3138: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3136: WHEN OTHERS
3137: THEN
3138: x_return_status := fnd_api.g_ret_sts_unexp_error;
3139:
3140: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3141: THEN
3142: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3143:
3144: IF (g_fnd_debug = 'Y')

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

3138: x_return_status := fnd_api.g_ret_sts_unexp_error;
3139:
3140: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3141: THEN
3142: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3143:
3144: IF (g_fnd_debug = 'Y')
3145: THEN
3146: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

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

3151: END IF;
3152: END IF;
3153: END IF;
3154:
3155: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3156: p_data => l_msg_data);
3157: END get_def_proc_contract_info;
3158:
3159: ----------------------------------------------------------------------------------

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

3296: EXCEPTION
3297: WHEN fnd_api.g_exc_unexpected_error
3298: THEN
3299: x_return_status := fnd_api.g_ret_sts_unexp_error;
3300: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3301: p_data => l_msg_data);
3302: WHEN OTHERS
3303: THEN
3304: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3302: WHEN OTHERS
3303: THEN
3304: x_return_status := fnd_api.g_ret_sts_unexp_error;
3305:
3306: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3307: THEN
3308: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3309:
3310: IF (g_fnd_debug = 'Y')

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

3304: x_return_status := fnd_api.g_ret_sts_unexp_error;
3305:
3306: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3307: THEN
3308: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3309:
3310: IF (g_fnd_debug = 'Y')
3311: THEN
3312: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

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

3317: END IF;
3318: END IF;
3319: END IF;
3320:
3321: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3322: p_data => l_msg_data);
3323: END Get_Contract_Details;
3324:
3325: ----------------------------------------------------------------------------------