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_ACCOUNT_POSITION_SET_PVT dependencies on FND_MSG_PUB

Line 78: FND_MSG_PUB.initialize ;

74: END IF;
75: --
76:
77: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
78: FND_MSG_PUB.initialize ;
79: END IF;
80: --
81: p_return_status := FND_API.G_RET_STS_SUCCESS ;
82: --

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

137: IF FND_API.To_Boolean ( p_commit ) THEN
138: COMMIT WORK;
139: END iF;
140: --
141: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
142: p_data => p_msg_data );
143: --
144: EXCEPTION
145: --

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

146: WHEN FND_API.G_EXC_ERROR THEN
147: --
148: ROLLBACK TO Insert_Row_Pvt ;
149: p_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
151: p_data => p_msg_data );
152: --
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: --

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

153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: --
155: ROLLBACK TO Insert_Row_Pvt ;
156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
158: p_data => p_msg_data );
159: --
160: WHEN OTHERS THEN
161: --

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

161: --
162: ROLLBACK TO Insert_Row_Pvt ;
163: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: --
165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
166: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
167: l_api_name);
168: END if;
169: --

Line 166: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

162: ROLLBACK TO Insert_Row_Pvt ;
163: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: --
165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
166: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
167: l_api_name);
168: END if;
169: --
170: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

166: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
167: l_api_name);
168: END if;
169: --
170: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
171: p_data => p_msg_data );
172: --
173: END Insert_Row;
174: /*-------------------------------------------------------------------------*/

Line 232: FND_MSG_PUB.initialize ;

228: END IF;
229: --
230:
231: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
232: FND_MSG_PUB.initialize ;
233: END IF;
234: --
235: p_return_status := FND_API.G_RET_STS_SUCCESS ;
236: p_row_locked := FND_API.G_TRUE ;

Line 244: FND_MSG_PUB.Add;

240: FETCH C INTO Recinfo;
241: IF (C%NOTFOUND) then
242: CLOSE C;
243: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
244: FND_MSG_PUB.Add;
245: RAISE FND_API.G_EXC_ERROR ;
246: END IF;
247: CLOSE C;
248:

Line 297: FND_MSG_PUB.Add;

293: THEN
294: Null;
295: ELSE
296: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
297: FND_MSG_PUB.Add;
298: RAISE FND_API.G_EXC_ERROR ;
299: END IF;
300:
301: --

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

302: IF FND_API.To_Boolean ( p_commit ) THEN
303: COMMIT WORK;
304: END iF;
305: --
306: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
307: p_data => p_msg_data );
308: --
309: EXCEPTION
310: --

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

312: --
313: ROLLBACK TO Lock_Row_Pvt ;
314: p_row_locked := FND_API.G_FALSE;
315: p_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
317: p_data => p_msg_data );
318: --
319: WHEN FND_API.G_EXC_ERROR THEN
320: --

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

319: WHEN FND_API.G_EXC_ERROR THEN
320: --
321: ROLLBACK TO Lock_Row_Pvt ;
322: p_return_status := FND_API.G_RET_STS_ERROR;
323: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
324: p_data => p_msg_data );
325: --
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: --

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

326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: --
328: ROLLBACK TO Lock_Row_Pvt ;
329: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
331: p_data => p_msg_data );
332: --
333: WHEN OTHERS THEN
334: --

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

334: --
335: ROLLBACK TO Lock_Row_Pvt ;
336: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: --
338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
339: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
340: l_api_name);
341: END if;
342: --

Line 339: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

335: ROLLBACK TO Lock_Row_Pvt ;
336: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: --
338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
339: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
340: l_api_name);
341: END if;
342: --
343: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

339: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
340: l_api_name);
341: END if;
342: --
343: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
344: p_data => p_msg_data );
345: --
346: END Lock_Row;
347: /* ----------------------------------------------------------------------- */

Line 398: FND_MSG_PUB.initialize ;

394: END IF;
395: --
396:
397: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
398: FND_MSG_PUB.initialize ;
399: END IF;
400: --
401: p_return_status := FND_API.G_RET_STS_SUCCESS ;
402: --

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

430: IF FND_API.To_Boolean ( p_commit ) THEN
431: COMMIT WORK;
432: END iF;
433: --
434: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
435: p_data => p_msg_data );
436: --
437: EXCEPTION
438: --

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

439: WHEN FND_API.G_EXC_ERROR THEN
440: --
441: ROLLBACK TO Update_Row_Pvt ;
442: p_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
444: p_data => p_msg_data );
445: --
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: --

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

446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: --
448: ROLLBACK TO Update_Row_Pvt ;
449: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
451: p_data => p_msg_data );
452: --
453: WHEN OTHERS THEN
454: --

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

454: --
455: ROLLBACK TO Update_Row_Pvt ;
456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: --
458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
459: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
460: l_api_name);
461: END if;
462: --

Line 459: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

455: ROLLBACK TO Update_Row_Pvt ;
456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: --
458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
459: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
460: l_api_name);
461: END if;
462: --
463: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

459: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
460: l_api_name);
461: END if;
462: --
463: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
464: p_data => p_msg_data );
465: --
466: END Update_Row;
467: /* ----------------------------------------------------------------------- */

Line 512: FND_MSG_PUB.initialize ;

508: END IF;
509: --
510:
511: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
512: FND_MSG_PUB.initialize ;
513: END IF ;
514: --
515: p_return_status := FND_API.G_RET_STS_SUCCESS ;
516: --

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

570: IF FND_API.To_Boolean ( p_commit ) THEN
571: COMMIT WORK;
572: END iF;
573: --
574: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
575: p_data => p_msg_data );
576:
577: EXCEPTION
578: --

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

579: WHEN FND_API.G_EXC_ERROR THEN
580: --
581: ROLLBACK TO Delete_Row_Pvt ;
582: p_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
584: p_data => p_msg_data );
585: --
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: --

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

586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: --
588: ROLLBACK TO Delete_Row_Pvt ;
589: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
591: p_data => p_msg_data );
592: --
593: WHEN OTHERS THEN
594: --

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

594: --
595: ROLLBACK TO Delete_Row_Pvt ;
596: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: --
598: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
599: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
600: l_api_name);
601: END if;
602: --

Line 599: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

595: ROLLBACK TO Delete_Row_Pvt ;
596: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: --
598: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
599: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
600: l_api_name);
601: END if;
602: --
603: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

599: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
600: l_api_name);
601: END if;
602: --
603: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
604: p_data => p_msg_data );
605: --
606: END Delete_Row;
607: /* ----------------------------------------------------------------------- */

Line 666: FND_MSG_PUB.initialize ;

662: END IF;
663: --
664:
665: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
666: FND_MSG_PUB.initialize ;
667: END IF;
668: --
669: p_return_status := FND_API.G_RET_STS_SUCCESS ;
670: --

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

685: IF FND_API.To_Boolean ( p_commit ) THEN
686: COMMIT WORK;
687: END iF;
688: --
689: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
690: p_data => p_msg_data );
691: --
692: EXCEPTION
693: --

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

694: WHEN FND_API.G_EXC_ERROR THEN
695: --
696: ROLLBACK TO Check_Unique_Pvt ;
697: p_return_status := FND_API.G_RET_STS_ERROR;
698: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
699: p_data => p_msg_data );
700: --
701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
702: --

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

701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
702: --
703: ROLLBACK TO Check_Unique_Pvt ;
704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
706: p_data => p_msg_data );
707: --
708: WHEN OTHERS THEN
709: --

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

709: --
710: ROLLBACK TO Check_Unique_Pvt ;
711: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: --
713: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
714: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
715: l_api_name);
716: END if;
717: --

Line 714: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

710: ROLLBACK TO Check_Unique_Pvt ;
711: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: --
713: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
714: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
715: l_api_name);
716: END if;
717: --
718: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

714: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
715: l_api_name);
716: END if;
717: --
718: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
719: p_data => p_msg_data );
720: --
721: END Check_Unique;
722: /* ----------------------------------------------------------------------- */

Line 796: FND_MSG_PUB.initialize ;

792: END IF;
793: --
794:
795: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
796: FND_MSG_PUB.initialize ;
797: END IF;
798: --
799: p_return_status := FND_API.G_RET_STS_SUCCESS ;
800: --

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

888: IF FND_API.To_Boolean ( p_commit ) THEN
889: COMMIT WORK;
890: END iF;
891: --
892: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
893: p_data => p_msg_data );
894:
895: EXCEPTION
896: --

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

897: WHEN FND_API.G_EXC_ERROR THEN
898: --
899: ROLLBACK TO Check_References_Pvt ;
900: p_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
902: p_data => p_msg_data );
903: --
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: --

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

904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: --
906: ROLLBACK TO Check_References_Pvt ;
907: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
909: p_data => p_msg_data );
910: --
911: WHEN OTHERS THEN
912: --

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

912: --
913: ROLLBACK TO Check_References_Pvt ;
914: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: --
916: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
917: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
918: l_api_name);
919: END if;
920: --

Line 917: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

913: ROLLBACK TO Check_References_Pvt ;
914: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: --
916: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
917: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
918: l_api_name);
919: END if;
920: --
921: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

917: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
918: l_api_name);
919: END if;
920: --
921: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
922: p_data => p_msg_data );
923: --
924: END Check_References;
925: /*-------------------------------------------------------------------------*/

Line 988: FND_MSG_PUB.initialize ;

984: END IF;
985: --
986:
987: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
988: FND_MSG_PUB.initialize ;
989: END IF;
990: --
991: p_return_status := FND_API.G_RET_STS_SUCCESS ;
992: --

Line 1004: FND_MSG_PUB.Add;

1000: IF p_entity_table(i) NOT IN ( 'BWR', 'C', 'DR', 'E', 'P', 'PSG' ) THEN
1001: --
1002: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_ENTITY_TYPE') ;
1003: Fnd_Message.Set_Token('ENTITY_TYPE', p_entity_table(i) ) ;
1004: FND_MSG_PUB.Add;
1005: RAISE FND_API.G_EXC_ERROR ;
1006: --
1007: END IF;
1008:

Line 1021: FND_MSG_PUB.Add;

1017: IF ( l_source_data_extract_csr%NOTFOUND ) THEN
1018: --
1019: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_DATA_EXTRACT') ;
1020: Fnd_Message.Set_Token('DATA_EXTRACT', p_source_data_extract_id ) ;
1021: FND_MSG_PUB.Add;
1022: RAISE FND_API.G_EXC_ERROR ;
1023: --
1024: END IF ;
1025:

Line 1036: FND_MSG_PUB.Add;

1032: IF ( l_target_data_extract_csr%NOTFOUND ) THEN
1033: --
1034: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_DATA_EXTRACT') ;
1035: Fnd_Message.Set_Token('DATA_EXTRACT', p_target_data_extract_id ) ;
1036: FND_MSG_PUB.Add;
1037: RAISE FND_API.G_EXC_ERROR ;
1038: --
1039: END IF ;
1040:

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

1138: IF FND_API.To_Boolean ( p_commit ) THEN
1139: COMMIT WORK;
1140: END iF;
1141: --
1142: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1143: p_data => p_msg_data );
1144:
1145: --
1146: EXCEPTION

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

1148: WHEN FND_API.G_EXC_ERROR THEN
1149: --
1150: ROLLBACK TO Copy_Position_Sets_Pvt ;
1151: p_return_status := FND_API.G_RET_STS_ERROR;
1152: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1153: p_data => p_msg_data );
1154: --
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: --

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

1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: --
1157: ROLLBACK TO Copy_Position_Sets_Pvt ;
1158: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1160: p_data => p_msg_data );
1161: --
1162: WHEN OTHERS THEN
1163: --

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

1163: --
1164: ROLLBACK TO Copy_Position_Sets_Pvt ;
1165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: --
1167: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1168: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1169: l_api_name);
1170: END if;
1171: --

Line 1168: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1164: ROLLBACK TO Copy_Position_Sets_Pvt ;
1165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: --
1167: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1168: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1169: l_api_name);
1170: END if;
1171: --
1172: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

1168: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1169: l_api_name);
1170: END if;
1171: --
1172: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1173: p_data => p_msg_data );
1174: --
1175: END Copy_Position_Sets ;
1176: /*-------------------------------------------------------------------------*/

Line 1270: FND_MSG_PUB.initialize ;

1266: END IF;
1267: --
1268:
1269: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1270: FND_MSG_PUB.initialize ;
1271: END IF;
1272: --
1273: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1274:

Line 1302: FND_MSG_PUB.Add;

1298:
1299: --
1300: Fnd_Message.Set_Name ('PSB', 'PSB_SET_CANNOT_BE_COPIED') ;
1301: Fnd_Message.Set_Token('SET_NAME', l_sets_rec.name ) ;
1302: FND_MSG_PUB.Add;
1303: RETURN;
1304: --
1305: END IF;
1306:

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

1561: IF FND_API.To_Boolean ( p_commit ) THEN
1562: COMMIT WORK;
1563: END iF;
1564: --
1565: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1566: p_data => p_msg_data );
1567: --
1568: EXCEPTION
1569: --

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

1570: WHEN FND_API.G_EXC_ERROR THEN
1571: --
1572: ROLLBACK TO Copy_Position_Set_Pvt ;
1573: p_return_status := FND_API.G_RET_STS_ERROR ;
1574: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1575: p_data => p_msg_data );
1576: --
1577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1578: --

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

1577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1578: --
1579: ROLLBACK TO Copy_Position_Set_Pvt ;
1580: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1581: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1582: p_data => p_msg_data );
1583: --
1584: WHEN OTHERS THEN
1585: --

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

1585: --
1586: ROLLBACK TO Copy_Position_Set_Pvt ;
1587: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: --
1589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1590: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1591: l_api_name);
1592: END if;
1593: --

Line 1590: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1586: ROLLBACK TO Copy_Position_Set_Pvt ;
1587: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: --
1589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1590: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1591: l_api_name);
1592: END if;
1593: --
1594: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

1590: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1591: l_api_name);
1592: END if;
1593: --
1594: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1595: p_data => p_msg_data );
1596: --
1597: END Copy_Position_Set ;
1598: /*---------------------------------------------------------------------------*/