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

Line 5: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

1: PACKAGE BODY DPP_MIG_ADJ_PARA_APPROVAL_PVT AS
2: /* $Header: dppmigsb.pls 120.5 2009/07/28 07:19:50 anbbalas noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_MIG_ADJ_PARA_APPROVAL_PVT';
5: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
6: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppmigsb.pls';
7:
8: ---------------------------------------------------------------------
9: -- PROCEDURE

Line 54: Fnd_Msg_Pub.initialize;

50:
51:
52: BEGIN
53: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
54: Fnd_Msg_Pub.initialize;
55: END IF;
56:
57: IF NOT Fnd_Api.compatible_api_call ( l_api_version,
58: p_api_version,

Line 93: FND_MSG_PUB.Count_And_Get (

89:
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: -- Standard call to get message count and if count=1, get the message
93: FND_MSG_PUB.Count_And_Get (
94: p_encoded => FND_API.G_FALSE,
95: p_count => x_msg_count,
96: p_data => x_msg_data
97: );

Line 100: x_msg_data := SUBSTR((x_msg_data ||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

96: p_data => x_msg_data
97: );
98: IF x_msg_count > 1 THEN
99: FOR I IN 1..x_msg_count LOOP
100: x_msg_data := SUBSTR((x_msg_data ||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
101: END LOOP;
102: END IF;
103:
104: WHEN OTHERS THEN

Line 110: FND_MSG_PUB.add;

106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
107: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.checkMigrationCompletion');
108: fnd_message.set_token('ERRNO', sqlcode);
109: fnd_message.set_token('REASON', sqlerrm);
110: FND_MSG_PUB.add;
111:
112: -- Standard call to get message count and if count=1, get the message
113: FND_MSG_PUB.Count_And_Get (
114: p_encoded => FND_API.G_FALSE,

Line 113: FND_MSG_PUB.Count_And_Get (

109: fnd_message.set_token('REASON', sqlerrm);
110: FND_MSG_PUB.add;
111:
112: -- Standard call to get message count and if count=1, get the message
113: FND_MSG_PUB.Count_And_Get (
114: p_encoded => FND_API.G_FALSE,
115: p_count => x_msg_count,
116: p_data => x_msg_data
117: );

Line 120: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

116: p_data => x_msg_data
117: );
118: IF x_msg_count > 1 THEN
119: FOR I IN 1..x_msg_count LOOP
120: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
121: END LOOP;
122: END IF;
123:
124: END checkMigrationCompletion;

Line 192: Fnd_Msg_Pub.initialize;

188:
189:
190: BEGIN
191: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
192: Fnd_Msg_Pub.initialize;
193: END IF;
194:
195: IF NOT Fnd_Api.compatible_api_call ( l_api_version,
196: p_api_version,

Line 237: FND_MSG_PUB.Count_And_Get (

233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: -- Standard call to get message count and if count=1, get the message
237: FND_MSG_PUB.Count_And_Get (
238: p_encoded => FND_API.G_FALSE,
239: p_count => x_msg_count,
240: p_data => x_msg_data
241: );

Line 244: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

240: p_data => x_msg_data
241: );
242: IF x_msg_count > 1 THEN
243: FOR I IN 1..x_msg_count LOOP
244: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
245: END LOOP;
246: END IF;
247:
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 251: FND_MSG_PUB.Count_And_Get (

247:
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: -- Standard call to get message count and if count=1, get the message
251: FND_MSG_PUB.Count_And_Get (
252: p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data
255: );

Line 258: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

254: p_data => x_msg_data
255: );
256: IF x_msg_count > 1 THEN
257: FOR I IN 1..x_msg_count LOOP
258: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
259: END LOOP;
260: END IF;
261:
262: WHEN OTHERS THEN

Line 268: FND_MSG_PUB.add;

264: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
265: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_suppTradeProfile');
266: fnd_message.set_token('ERRNO', sqlcode);
267: fnd_message.set_token('REASON', sqlerrm);
268: FND_MSG_PUB.add;
269:
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,

Line 271: FND_MSG_PUB.Count_And_Get (

267: fnd_message.set_token('REASON', sqlerrm);
268: FND_MSG_PUB.add;
269:
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data
275: );

Line 278: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

274: p_data => x_msg_data
275: );
276: IF x_msg_count > 1 THEN
277: FOR I IN 1..x_msg_count LOOP
278: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
279: END LOOP;
280: END IF;
281:
282: END validate_suppTradeProfile;

Line 344: Fnd_Msg_Pub.initialize;

340: where hr.organization_id = p_org_id;
341:
342: BEGIN
343: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
344: Fnd_Msg_Pub.initialize;
345: END IF;
346:
347: IF NOT Fnd_Api.compatible_api_call ( l_api_version,
348: p_api_version,

Line 400: FND_MSG_PUB.Count_And_Get (

396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: -- Standard call to get message count and if count=1, get the message
400: FND_MSG_PUB.Count_And_Get (
401: p_encoded => FND_API.G_FALSE,
402: p_count => x_msg_count,
403: p_data => x_msg_data
404: );

Line 407: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

403: p_data => x_msg_data
404: );
405: IF x_msg_count > 1 THEN
406: FOR I IN 1..x_msg_count LOOP
407: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
408: END LOOP;
409: END IF;
410:
411: WHEN OTHERS THEN

Line 417: FND_MSG_PUB.add;

413: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
414: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_execProcessSetup');
415: fnd_message.set_token('ERRNO', sqlcode);
416: fnd_message.set_token('REASON', sqlerrm);
417: FND_MSG_PUB.add;
418:
419: -- Standard call to get message count and if count=1, get the message
420: FND_MSG_PUB.Count_And_Get (
421: p_encoded => FND_API.G_FALSE,

Line 420: FND_MSG_PUB.Count_And_Get (

416: fnd_message.set_token('REASON', sqlerrm);
417: FND_MSG_PUB.add;
418:
419: -- Standard call to get message count and if count=1, get the message
420: FND_MSG_PUB.Count_And_Get (
421: p_encoded => FND_API.G_FALSE,
422: p_count => x_msg_count,
423: p_data => x_msg_data
424: );

Line 427: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

423: p_data => x_msg_data
424: );
425: IF x_msg_count > 1 THEN
426: FOR I IN 1..x_msg_count LOOP
427: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
428: END LOOP;
429: END IF;
430:
431: END validate_execProcessSetup;

Line 522: Fnd_Msg_Pub.initialize;

518: AND dppl.lookup_code = opsa.process_code;
519:
520: BEGIN
521: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
522: Fnd_Msg_Pub.initialize;
523: END IF;
524:
525: IF NOT Fnd_Api.compatible_api_call ( l_api_version,
526: p_api_version,

Line 617: FND_MSG_PUB.Count_And_Get (

613: EXCEPTION
614: WHEN FND_API.G_EXC_ERROR THEN
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data
621: );

Line 624: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

620: p_data => x_msg_data
621: );
622: IF x_msg_count > 1 THEN
623: FOR I IN 1..x_msg_count LOOP
624: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
625: END LOOP;
626: END IF;
627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 631: FND_MSG_PUB.Count_And_Get (

627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: -- Standard call to get message count and if count=1, get the message
631: FND_MSG_PUB.Count_And_Get (
632: p_encoded => FND_API.G_FALSE,
633: p_count => x_msg_count,
634: p_data => x_msg_data
635: );

Line 638: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

634: p_data => x_msg_data
635: );
636: IF x_msg_count > 1 THEN
637: FOR I IN 1..x_msg_count LOOP
638: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
639: END LOOP;
640: END IF;
641:
642: WHEN OTHERS THEN

Line 648: FND_MSG_PUB.add;

644: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
645: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.insertExecutionProcesses');
646: fnd_message.set_token('ERRNO', sqlcode);
647: fnd_message.set_token('REASON', sqlerrm);
648: FND_MSG_PUB.add;
649:
650: -- Standard call to get message count and if count=1, get the message
651: FND_MSG_PUB.Count_And_Get (
652: p_encoded => FND_API.G_FALSE,

Line 651: FND_MSG_PUB.Count_And_Get (

647: fnd_message.set_token('REASON', sqlerrm);
648: FND_MSG_PUB.add;
649:
650: -- Standard call to get message count and if count=1, get the message
651: FND_MSG_PUB.Count_And_Get (
652: p_encoded => FND_API.G_FALSE,
653: p_count => x_msg_count,
654: p_data => x_msg_data
655: );

Line 658: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

654: p_data => x_msg_data
655: );
656: IF x_msg_count > 1 THEN
657: FOR I IN 1..x_msg_count LOOP
658: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
659: END LOOP;
660: END IF;
661:
662: END insertExecutionProcesses;

Line 713: Fnd_Msg_Pub.initialize;

709: and trunc(effective_start_date) > trunc(sysdate);
710:
711: BEGIN
712: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
713: Fnd_Msg_Pub.initialize;
714: END IF;
715:
716: IF NOT Fnd_Api.compatible_api_call ( l_api_version,
717: p_api_version,

Line 750: fnd_msg_pub.add;

746: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
747: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
748: fnd_message.set_token('ERRNO', sqlcode);
749: fnd_message.set_token('REASON', sqlerrm);
750: fnd_msg_pub.add;
751: RAISE fnd_api.g_exc_unexpected_error;
752: END;
753:
754: FOR validTransactionsRec IN validTransactionsCur

Line 772: FND_MSG_PUB.add;

768: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
769: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
770: fnd_message.set_token('ERRNO', sqlcode);
771: fnd_message.set_token('REASON', sqlerrm);
772: FND_MSG_PUB.add;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END;
775: END LOOP;
776:

Line 781: FND_MSG_PUB.Count_And_Get (

777: EXCEPTION
778: WHEN FND_API.G_EXC_ERROR THEN
779: x_return_status := FND_API.G_RET_STS_ERROR;
780: -- Standard call to get message count and if count=1, get the message
781: FND_MSG_PUB.Count_And_Get (
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_msg_count,
784: p_data => x_msg_data
785: );

Line 788: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

784: p_data => x_msg_data
785: );
786: IF x_msg_count > 1 THEN
787: FOR I IN 1..x_msg_count LOOP
788: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
789: END LOOP;
790: END IF;
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 795: FND_MSG_PUB.Count_And_Get (

791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: -- Standard call to get message count and if count=1, get the message
795: FND_MSG_PUB.Count_And_Get (
796: p_encoded => FND_API.G_FALSE,
797: p_count => x_msg_count,
798: p_data => x_msg_data
799: );

Line 802: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

798: p_data => x_msg_data
799: );
800: IF x_msg_count > 1 THEN
801: FOR I IN 1..x_msg_count LOOP
802: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
803: END LOOP;
804: END IF;
805:
806: WHEN OTHERS THEN

Line 812: FND_MSG_PUB.add;

808: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
809: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
810: fnd_message.set_token('ERRNO', sqlcode);
811: fnd_message.set_token('REASON', sqlerrm);
812: FND_MSG_PUB.add;
813:
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE,

Line 815: FND_MSG_PUB.Count_And_Get (

811: fnd_message.set_token('REASON', sqlerrm);
812: FND_MSG_PUB.add;
813:
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE,
817: p_count => x_msg_count,
818: p_data => x_msg_data
819: );

Line 822: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

818: p_data => x_msg_data
819: );
820: IF x_msg_count > 1 THEN
821: FOR I IN 1..x_msg_count LOOP
822: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
823: END LOOP;
824: END IF;
825:
826: END clearAllApprovals;

Line 866: Fnd_Msg_Pub.initialize;

862: l_msg_data VARCHAR2(4000);
863:
864: BEGIN
865: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
866: Fnd_Msg_Pub.initialize;
867: END IF;
868:
869: IF NOT Fnd_Api.compatible_api_call ( l_api_version,
870: p_api_version,

Line 978: FND_MSG_PUB.Count_And_Get (

974: EXCEPTION
975: WHEN FND_API.G_EXC_ERROR THEN
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: -- Standard call to get message count and if count=1, get the message
978: FND_MSG_PUB.Count_And_Get (
979: p_encoded => FND_API.G_FALSE,
980: p_count => x_msg_count,
981: p_data => x_msg_data
982: );

Line 985: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

981: p_data => x_msg_data
982: );
983: IF x_msg_count > 1 THEN
984: FOR I IN 1..x_msg_count LOOP
985: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
986: END LOOP;
987: END IF;
988:
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 992: FND_MSG_PUB.Count_And_Get (

988:
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: -- Standard call to get message count and if count=1, get the message
992: FND_MSG_PUB.Count_And_Get (
993: p_encoded => FND_API.G_FALSE,
994: p_count => x_msg_count,
995: p_data => x_msg_data
996: );

Line 999: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

995: p_data => x_msg_data
996: );
997: IF x_msg_count > 1 THEN
998: FOR I IN 1..x_msg_count LOOP
999: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1000: END LOOP;
1001: END IF;
1002:
1003: WHEN OTHERS THEN

Line 1009: FND_MSG_PUB.add;

1005: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1006: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_status');
1007: fnd_message.set_token('ERRNO', sqlcode);
1008: fnd_message.set_token('REASON', sqlerrm);
1009: FND_MSG_PUB.add;
1010:
1011: -- Standard call to get message count and if count=1, get the message
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => FND_API.G_FALSE,

Line 1012: FND_MSG_PUB.Count_And_Get (

1008: fnd_message.set_token('REASON', sqlerrm);
1009: FND_MSG_PUB.add;
1010:
1011: -- Standard call to get message count and if count=1, get the message
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => FND_API.G_FALSE,
1014: p_count => x_msg_count,
1015: p_data => x_msg_data
1016: );

Line 1019: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1015: p_data => x_msg_data
1016: );
1017: IF x_msg_count > 1 THEN
1018: FOR I IN 1..x_msg_count LOOP
1019: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1020: END LOOP;
1021: END IF;
1022:
1023: END update_status;

Line 1230: FND_MSG_PUB.Count_And_Get (

1226: ROLLBACK TO update_transaction_status;
1227: errbuf :='Error';
1228: retcode := 2;
1229: -- Standard call to get message count and if count=1, get the message
1230: FND_MSG_PUB.Count_And_Get (
1231: p_encoded => FND_API.G_FALSE,
1232: p_count => l_msg_count,
1233: p_data => l_msg_data
1234: );

Line 1237: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1233: p_data => l_msg_data
1234: );
1235: IF l_msg_count > 1 THEN
1236: FOR I IN 1..l_msg_count LOOP
1237: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1238: END LOOP;
1239: END IF;
1240:
1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1246: FND_MSG_PUB.Count_And_Get (

1242: ROLLBACK TO update_transaction_status;
1243: errbuf :='Error';
1244: retcode := 2;
1245: -- Standard call to get message count and if count=1, get the message
1246: FND_MSG_PUB.Count_And_Get (
1247: p_encoded => FND_API.G_FALSE,
1248: p_count => l_msg_count,
1249: p_data => l_msg_data
1250: );

Line 1253: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1249: p_data => l_msg_data
1250: );
1251: IF l_msg_count > 1 THEN
1252: FOR I IN 1..l_msg_count LOOP
1253: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1254: END LOOP;
1255: END IF;
1256:
1257: WHEN OTHERS THEN

Line 1265: FND_MSG_PUB.add;

1261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1262: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_transaction_status');
1263: fnd_message.set_token('ERRNO', sqlcode);
1264: fnd_message.set_token('REASON', sqlerrm);
1265: FND_MSG_PUB.add;
1266:
1267: -- Standard call to get message count and if count=1, get the message
1268: FND_MSG_PUB.Count_And_Get (
1269: p_encoded => FND_API.G_FALSE,

Line 1268: FND_MSG_PUB.Count_And_Get (

1264: fnd_message.set_token('REASON', sqlerrm);
1265: FND_MSG_PUB.add;
1266:
1267: -- Standard call to get message count and if count=1, get the message
1268: FND_MSG_PUB.Count_And_Get (
1269: p_encoded => FND_API.G_FALSE,
1270: p_count => l_msg_count,
1271: p_data => l_msg_data
1272: );

Line 1275: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

1271: p_data => l_msg_data
1272: );
1273: IF l_msg_count > 1 THEN
1274: FOR I IN 1..l_msg_count LOOP
1275: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1276: END LOOP;
1277: END IF;
1278:
1279: END update_transaction_status;