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

Line 143: FND_MSG_PUB.initialize;

139: --
140: SAVEPOINT Insert_Row ;
141: --
142: if FND_API.to_Boolean (p_init_msg_list) then
143: FND_MSG_PUB.initialize;
144: end if;
145: --
146: --
147: P_LAST_UPDATE_DATE := SYSDATE;

Line 162: FND_MSG_PUB.Add ;

158: P_LAST_UPDATE_LOGIN := -1;
159: end if;
160: else
161: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
162: FND_MSG_PUB.Add ;
163: raise FND_API.G_EXC_ERROR;
164: end if;
165: --
166: insert into PSB_POSITION_PAY_DISTRIBUTIONS(

Line 231: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

227: if FND_API.to_Boolean (p_commit) then
228: commit work;
229: end if;
230: -- Standard call to get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
232: p_data => p_msg_data);
233: --
234: EXCEPTION
235: --

Line 240: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

236: when FND_API.G_EXC_ERROR then
237: --
238: rollback to INSERT_ROW ;
239: p_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
241: p_data => p_msg_data);
242: --
243: when FND_API.G_EXC_UNEXPECTED_ERROR then
244: --

Line 247: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

243: when FND_API.G_EXC_UNEXPECTED_ERROR then
244: --
245: rollback to INSERT_ROW ;
246: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
248: p_data => p_msg_data);
249: --
250: when OTHERS then
251: --

Line 254: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

250: when OTHERS then
251: --
252: rollback to INSERT_ROW ;
253: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
255: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
256: l_api_name);
257: END if;
258: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 255: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

251: --
252: rollback to INSERT_ROW ;
253: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
255: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
256: l_api_name);
257: END if;
258: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
259: p_data => p_msg_data);

Line 258: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

254: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
255: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
256: l_api_name);
257: END if;
258: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
259: p_data => p_msg_data);
260: --
261: END INSERT_ROW;
262: --

Line 324: FND_MSG_PUB.initialize;

320: --
321: SAVEPOINT Lock_Row ;
322: --
323: if FND_API.to_Boolean (p_init_msg_list) then
324: FND_MSG_PUB.initialize;
325: end if;
326: --
327: p_row_locked := FND_API.G_TRUE ;
328: --

Line 333: fnd_msg_pub.add ;

329: open c1;
330: fetch c1 into tlinfo;
331: if (c1%notfound) then
332: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
333: fnd_msg_pub.add ;
334: close c1;
335: raise fnd_api.g_exc_error ;
336: end if;
337: close c1;

Line 401: fnd_msg_pub.add ;

397: ) then
398: null;
399: else
400: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
401: fnd_msg_pub.add ;
402: raise fnd_api.g_exc_error ;
403: end if;
404:
405: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 413: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

409: --
410: rollback to LOCK_ROW ;
411: p_row_locked := FND_API.G_FALSE ;
412: p_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
414: p_data => p_msg_data);
415: --
416: when FND_API.G_EXC_ERROR then
417: --

Line 420: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

416: when FND_API.G_EXC_ERROR then
417: --
418: rollback to LOCK_ROW ;
419: p_return_status := FND_API.G_RET_STS_ERROR;
420: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
421: p_data => p_msg_data);
422: --
423: when FND_API.G_EXC_UNEXPECTED_ERROR then
424: --

Line 427: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

423: when FND_API.G_EXC_UNEXPECTED_ERROR then
424: --
425: rollback to LOCK_ROW ;
426: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
428: p_data => p_msg_data);
429: --
430: when OTHERS then
431: --

Line 434: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

430: when OTHERS then
431: --
432: rollback to LOCK_ROW ;
433: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
435: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
436: l_api_name);
437: END if;
438: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 435: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

431: --
432: rollback to LOCK_ROW ;
433: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
435: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
436: l_api_name);
437: END if;
438: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
439: p_data => p_msg_data);

Line 438: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

434: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
435: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
436: l_api_name);
437: END if;
438: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
439: p_data => p_msg_data);
440: --
441: END LOCK_ROW;
442:

Line 481: FND_MSG_PUB.initialize;

477: --
478: SAVEPOINT Update_Row ;
479: --
480: if FND_API.to_Boolean (p_init_msg_list) then
481: FND_MSG_PUB.initialize;
482: end if;
483:
484: --
485: P_LAST_UPDATE_DATE := SYSDATE;

Line 500: FND_MSG_PUB.Add ;

496: P_LAST_UPDATE_LOGIN := -1;
497: end if;
498: else
499: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
500: FND_MSG_PUB.Add ;
501: raise FND_API.G_EXC_ERROR ;
502: end if;
503:
504: -- do the update of the record

Line 553: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

549: end if;
550:
551: -- Standard call to get message count and if count is 1, get message info.
552:
553: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
554: p_data => p_msg_data);
555: --
556: EXCEPTION
557:

Line 562: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

558: when FND_API.G_EXC_ERROR then
559: --
560: rollback to Update_Row ;
561: p_return_status := FND_API.G_RET_STS_ERROR;
562: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
563: p_data => p_msg_data);
564: --
565: when FND_API.G_EXC_UNEXPECTED_ERROR then
566: --

Line 569: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

565: when FND_API.G_EXC_UNEXPECTED_ERROR then
566: --
567: rollback to Update_Row ;
568: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
569: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
570: p_data => p_msg_data);
571: --
572: when OTHERS then
573: --

Line 576: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

572: when OTHERS then
573: --
574: rollback to Update_Row ;
575: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
577: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
578: l_api_name);
579: end if;
580: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 577: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

573: --
574: rollback to Update_Row ;
575: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
577: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
578: l_api_name);
579: end if;
580: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
581: p_data => p_msg_data);

Line 580: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

576: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
577: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
578: l_api_name);
579: end if;
580: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
581: p_data => p_msg_data);
582: --
583:
584: END UPDATE_ROW;

Line 631: FND_MSG_PUB.initialize;

627: --
628: -- Initialize message list if p_init_msg_list is set to TRUE.
629: --
630: if FND_API.to_Boolean (p_init_msg_list) then
631: FND_MSG_PUB.initialize;
632: end if;
633: --
634: p_return_status := FND_API.G_RET_STS_SUCCESS ;
635: --

Line 673: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

669: if FND_API.to_Boolean (p_commit) then
670: commit work;
671: end if;
672: -- Standard call to get message count and if count is 1, get message info.
673: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
674: p_data => p_msg_data);
675:
676: return;
677: END if;

Line 710: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

706: end if;
707:
708: -- Standard call to get message count and if count is 1, get message info.
709:
710: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
711: p_data => p_msg_data);
712:
713: END ADD_ROW;
714: --

Line 738: FND_MSG_PUB.initialize;

734: --
735: -- Initialize message list if p_init_msg_list is set to TRUE.
736: --
737: if FND_API.to_Boolean (p_init_msg_list) then
738: FND_MSG_PUB.initialize;
739: end if;
740: --
741: p_return_status := FND_API.G_RET_STS_SUCCESS ;
742:

Line 758: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

754: end if;
755:
756: -- Standard call to get message count and if count is 1, get message info.
757:
758: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
759: p_data => p_msg_data);
760: --
761: EXCEPTION
762: when FND_API.G_EXC_ERROR then

Line 766: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

762: when FND_API.G_EXC_ERROR then
763: --
764: rollback to Delete_Row;
765: p_return_status := FND_API.G_RET_STS_ERROR;
766: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
767: p_data => p_msg_data);
768: --
769: when FND_API.G_EXC_UNEXPECTED_ERROR then
770: --

Line 773: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

769: when FND_API.G_EXC_UNEXPECTED_ERROR then
770: --
771: rollback to Delete_Row;
772: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
774: p_data => p_msg_data);
775: --
776: when OTHERS then
777: --

Line 780: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

776: when OTHERS then
777: --
778: rollback to Delete_Row ;
779: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
781: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
782: l_api_name);
783: end if;
784: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 781: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

777: --
778: rollback to Delete_Row ;
779: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
781: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
782: l_api_name);
783: end if;
784: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
785: p_data => p_msg_data);

Line 784: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

780: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
781: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
782: l_api_name);
783: end if;
784: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
785: p_data => p_msg_data);
786: --
787: END DELETE_ROW;
788:

Line 826: FND_MSG_PUB.initialize;

822:
823: -- Initialize message list if p_init_msg_list is set to TRUE
824:
825: if FND_API.to_Boolean (p_init_msg_list) then
826: FND_MSG_PUB.initialize;
827: end if;
828:
829: delete from PSB_POSITION_PAY_DISTRIBUTIONS
830: where data_extract_id = p_data_extract_id;

Line 847: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

843:
844:
845: -- Standard call to get message count and if count is 1, get message info
846:
847: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
848: p_data => p_msg_data);
849:
850: EXCEPTION
851:

Line 856: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

852: when FND_API.G_EXC_ERROR then
853: rollback to Delete_Distributions_Pvt;
854: p_return_status := FND_API.G_RET_STS_ERROR;
855:
856: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
857: p_data => p_msg_data);
858:
859:
860: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 864: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

860: when FND_API.G_EXC_UNEXPECTED_ERROR then
861: rollback to Delete_Distributions_Pvt;
862: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863:
864: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
865: p_data => p_msg_data);
866:
867:
868: when OTHERS then

Line 872: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

868: when OTHERS then
869: rollback to Delete_Distributions_Pvt;
870: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871:
872: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
873:
874: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
875: l_api_name);
876: end if;

Line 874: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

870: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871:
872: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
873:
874: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
875: l_api_name);
876: end if;
877:
878: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 878: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

874: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
875: l_api_name);
876: end if;
877:
878: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
879: p_data => p_msg_data);
880:
881: END Delete_Distributions;
882:

Line 921: FND_MSG_PUB.initialize;

917:
918: -- Initialize message list if p_init_msg_list is set to TRUE
919:
920: if FND_API.to_Boolean (p_init_msg_list) then
921: FND_MSG_PUB.initialize;
922: end if;
923:
924: DELETE from PSB_POSITION_PAY_DISTRIBUTIONS
925: WHERE position_id = p_position_id

Line 946: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

942:
943:
944: -- Standard call to get message count and if count is 1, get message info
945:
946: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
947: p_data => p_msg_data);
948:
949: EXCEPTION
950:

Line 955: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

951: when FND_API.G_EXC_ERROR then
952: rollback to Delete_Dist_Position_Pvt;
953: p_return_status := FND_API.G_RET_STS_ERROR;
954:
955: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
956: p_data => p_msg_data);
957:
958:
959: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 963: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

959: when FND_API.G_EXC_UNEXPECTED_ERROR then
960: rollback to Delete_Dist_Position_Pvt;
961: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962:
963: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
964: p_data => p_msg_data);
965:
966:
967: when OTHERS then

Line 971: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

967: when OTHERS then
968: rollback to Delete_Dist_Position_Pvt;
969: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970:
971: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
972:
973: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
974: l_api_name);
975: end if;

Line 973: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

969: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970:
971: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
972:
973: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
974: l_api_name);
975: end if;
976:
977: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 977: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

973: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
974: l_api_name);
975: end if;
976:
977: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
978: p_data => p_msg_data);
979:
980: END Delete_Distributions_Position;
981:

Line 1100: FND_MSG_PUB.initialize;

1096:
1097: -- Initialize message list if p_init_msg_list is set to TRUE
1098:
1099: if FND_API.to_Boolean (p_init_msg_list) then
1100: FND_MSG_PUB.initialize;
1101: end if;
1102:
1103: if nvl(p_worksheet_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
1104: l_ccid_valid := FND_API.G_TRUE;

Line 1346: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1342:
1343:
1344: -- Standard call to get message count and if count is 1, get message info
1345:
1346: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1347: p_data => p_msg_data);
1348:
1349: EXCEPTION
1350:

Line 1355: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1351: when FND_API.G_EXC_ERROR then
1352: rollback to Modify_Distribution_WS_Pvt;
1353: p_return_status := FND_API.G_RET_STS_ERROR;
1354:
1355: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1356: p_data => p_msg_data);
1357:
1358:
1359: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1363: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1359: when FND_API.G_EXC_UNEXPECTED_ERROR then
1360: rollback to Modify_Distribution_WS_Pvt;
1361: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1362:
1363: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1364: p_data => p_msg_data);
1365:
1366:
1367: when OTHERS then

Line 1371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

1367: when OTHERS then
1368: rollback to Modify_Distribution_WS_Pvt;
1369: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1370:
1371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1372:
1373: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1374: l_api_name);
1375: end if;

Line 1373: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1369: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1370:
1371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1372:
1373: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1374: l_api_name);
1375: end if;
1376:
1377: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 1377: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1373: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1374: l_api_name);
1375: end if;
1376:
1377: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1378: p_data => p_msg_data);
1379:
1380: END Modify_Distribution_WS;
1381:

Line 1489: FND_MSG_PUB.initialize;

1485:
1486: -- Initialize message list if p_init_msg_list is set to TRUE
1487:
1488: if FND_API.to_Boolean (p_init_msg_list) then
1489: FND_MSG_PUB.initialize;
1490: end if;
1491:
1492: l_userid := FND_GLOBAL.USER_ID;
1493: l_loginid := FND_GLOBAL.LOGIN_ID;

Line 2123: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2119:
2120:
2121: -- Standard call to get message count and if count is 1, get message info
2122:
2123: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2124: p_data => p_msg_data);
2125:
2126: EXCEPTION
2127:

Line 2132: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2128: when FND_API.G_EXC_ERROR then
2129: rollback to Modify_Distribution_Pvt;
2130: p_return_status := FND_API.G_RET_STS_ERROR;
2131:
2132: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2133: p_data => p_msg_data);
2134:
2135: when FND_API.G_EXC_UNEXPECTED_ERROR then
2136: rollback to Modify_Distribution_Pvt;

Line 2139: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2135: when FND_API.G_EXC_UNEXPECTED_ERROR then
2136: rollback to Modify_Distribution_Pvt;
2137: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2138:
2139: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2140: p_data => p_msg_data);
2141:
2142: when OTHERS then
2143: rollback to Modify_Distribution_Pvt;

Line 2146: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

2142: when OTHERS then
2143: rollback to Modify_Distribution_Pvt;
2144: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2145:
2146: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2147:
2148: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2149: l_api_name);
2150: end if;

Line 2148: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

2144: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2145:
2146: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2147:
2148: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2149: l_api_name);
2150: end if;
2151: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2152: p_data => p_msg_data);

Line 2151: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2147:
2148: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2149: l_api_name);
2150: end if;
2151: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2152: p_data => p_msg_data);
2153:
2154: END Modify_Distribution;
2155:

Line 2345: FND_MSG_PUB.initialize;

2341:
2342: -- Initialize message list if p_init_msg_list is set to TRUE
2343:
2344: if FND_API.to_Boolean (p_init_msg_list) then
2345: FND_MSG_PUB.initialize;
2346: end if;
2347:
2348: for C_Distribution_Rec in C_Distributions
2349: Loop

Line 2470: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2466:
2467:
2468: -- Standard call to get message count and if count is 1, get message info
2469:
2470: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2471: p_data => p_msg_data);
2472:
2473: EXCEPTION
2474:

Line 2479: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2475: when FND_API.G_EXC_ERROR then
2476: rollback to Modify_Extract_Dist_Pvt;
2477: p_return_status := FND_API.G_RET_STS_ERROR;
2478:
2479: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2480: p_data => p_msg_data);
2481:
2482:
2483: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2487: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2483: when FND_API.G_EXC_UNEXPECTED_ERROR then
2484: rollback to Modify_Extract_Dist_Pvt;
2485: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2486:
2487: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2488: p_data => p_msg_data);
2489:
2490:
2491: when OTHERS then

Line 2495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

2491: when OTHERS then
2492: rollback to Modify_Extract_Dist_Pvt;
2493: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2494:
2495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2496:
2497: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2498: l_api_name);
2499: end if;

Line 2497: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

2493: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2494:
2495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2496:
2497: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2498: l_api_name);
2499: end if;
2500:
2501: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 2501: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2497: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2498: l_api_name);
2499: end if;
2500:
2501: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2502: p_data => p_msg_data);
2503:
2504: END Modify_Extract_Distribution;
2505:

Line 2550: FND_MSG_PUB.Add;

2546: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));
2547: end loop;
2548: end if;
2549:
2550: FND_MSG_PUB.Add;
2551:
2552: end if;
2553:
2554: -- Clear Message Token stack

Line 2711: FND_MSG_PUB.initialize;

2707:
2708: -- Initialize message list if p_init_msg_list is set to TRUE
2709:
2710: IF FND_API.to_Boolean (p_init_msg_list) THEN
2711: FND_MSG_PUB.initialize;
2712: END IF;
2713:
2714: l_userid := FND_GLOBAL.USER_ID;
2715: l_loginid := FND_GLOBAL.LOGIN_ID;

Line 2933: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2929:
2930:
2931: -- Standard call to get message count and if count is 1, get message info
2932:
2933: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2934: p_data => x_msg_data);
2935:
2936: EXCEPTION
2937:

Line 2942: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2938: WHEN FND_API.G_EXC_ERROR THEN
2939: ROLLBACK TO Apply_Position_Pay_Distr;
2940: x_return_status := FND_API.G_RET_STS_ERROR;
2941:
2942: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2943: p_data => x_msg_data);
2944:
2945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2946: ROLLBACK TO Apply_Position_Pay_Distr;

Line 2949: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2946: ROLLBACK TO Apply_Position_Pay_Distr;
2947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2948:
2949: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2950: p_data => x_msg_data);
2951:
2952: WHEN OTHERS THEN
2953: ROLLBACK TO Apply_Position_Pay_Distr;

Line 2956: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2952: WHEN OTHERS THEN
2953: ROLLBACK TO Apply_Position_Pay_Distr;
2954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2955:
2956: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2957:
2958: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2959: l_api_name);
2960: END IF;

Line 2958: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

2954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2955:
2956: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2957:
2958: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2959: l_api_name);
2960: END IF;
2961: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2962: p_data => x_msg_data);

Line 2961: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2957:
2958: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2959: l_api_name);
2960: END IF;
2961: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2962: p_data => x_msg_data);
2963:
2964: END Apply_Position_Pay_Distr;
2965: