DBA Data[Home] [Help]

APPS.CSD_REPAIR_ACTUALS_PVT dependencies on FND_MSG_PUB

Line 82: FND_MSG_PUB.initialize;

78: END IF;
79:
80: -- Initialize message list if p_init_msg_list is set to TRUE.
81: IF FND_API.to_Boolean( p_init_msg_list ) THEN
82: FND_MSG_PUB.initialize;
83: END IF;
84:
85: -- Initialize API return status to success
86: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 146: FND_MSG_PUB.ADD;

142: END IF;
143:
144: FND_MESSAGE.SET_NAME('CSD','CSD_API_ACTUALS_EXISTS');
145: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',px_CSD_REPAIR_ACTUALS_REC.repair_line_id);
146: FND_MSG_PUB.ADD;
147:
148: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
149: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
150: END IF;

Line 220: FND_MSG_PUB.Count_And_Get

216: COMMIT WORK;
217: END IF;
218:
219: -- Standard call to get message count and IF count is get message info.
220: FND_MSG_PUB.Count_And_Get
221: (p_count => x_msg_count,
222: p_data => x_msg_data );
223: EXCEPTION
224: WHEN FND_API.G_EXC_ERROR THEN

Line 230: FND_MSG_PUB.Count_And_Get

226: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
227: END IF;
228: x_return_status := FND_API.G_RET_STS_ERROR ;
229: ROLLBACK TO CREATE_REPAIR_ACTUALS;
230: FND_MSG_PUB.Count_And_Get
231: (p_count => x_msg_count,
232: p_data => x_msg_data );
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 239: FND_MSG_PUB.Count_And_Get

235: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
236: END IF;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: ROLLBACK TO CREATE_REPAIR_ACTUALS;
239: FND_MSG_PUB.Count_And_Get
240: ( p_count => x_msg_count,
241: p_data => x_msg_data );
242: WHEN OTHERS THEN
243: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 249: IF FND_MSG_PUB.Check_Msg_Level

245: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
246: END IF;
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: ROLLBACK TO CREATE_REPAIR_ACTUALS;
249: IF FND_MSG_PUB.Check_Msg_Level
250: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
251: THEN
252: FND_MSG_PUB.Add_Exc_Msg
253: (G_PKG_NAME ,

Line 250: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

246: END IF;
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: ROLLBACK TO CREATE_REPAIR_ACTUALS;
249: IF FND_MSG_PUB.Check_Msg_Level
250: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
251: THEN
252: FND_MSG_PUB.Add_Exc_Msg
253: (G_PKG_NAME ,
254: l_api_name );

Line 252: FND_MSG_PUB.Add_Exc_Msg

248: ROLLBACK TO CREATE_REPAIR_ACTUALS;
249: IF FND_MSG_PUB.Check_Msg_Level
250: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
251: THEN
252: FND_MSG_PUB.Add_Exc_Msg
253: (G_PKG_NAME ,
254: l_api_name );
255: END IF;
256: FND_MSG_PUB.Count_And_Get

Line 256: FND_MSG_PUB.Count_And_Get

252: FND_MSG_PUB.Add_Exc_Msg
253: (G_PKG_NAME ,
254: l_api_name );
255: END IF;
256: FND_MSG_PUB.Count_And_Get
257: (p_count => x_msg_count,
258: p_data => x_msg_data );
259:
260: End CREATE_REPAIR_ACTUALS;

Line 341: FND_MSG_PUB.initialize;

337: END IF;
338:
339: -- Initialize message list if p_init_msg_list is set to TRUE.
340: IF FND_API.to_Boolean( p_init_msg_list ) THEN
341: FND_MSG_PUB.initialize;
342: END IF;
343:
344: -- Initialize API return status to success
345: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 387: FND_MSG_PUB.ADD;

383:
384: IF repair_actual%NOTFOUND THEN
385: FND_MESSAGE.SET_NAME('CSD','CSD_API_ACTUALS_MISSING');
386: FND_MESSAGE.SET_TOKEN('REPAIR_ACTUAL_ID',l_actual_id);
387: FND_MSG_PUB.ADD;
388: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
389: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
390: END IF;
391: RAISE FND_API.G_EXC_ERROR;

Line 410: FND_MSG_PUB.ADD;

406: -- Modified the message name for bugfix 3281321. vkjain.
407: -- FND_MESSAGE.SET_NAME('CSD','CSD_OBJ_VER_MISMATCH');
408: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_OBJ_VER_MISMATCH');
409: -- FND_MESSAGE.SET_TOKEN('REPAIR_ACTUAL_ID',l_actual_id);
410: FND_MSG_PUB.ADD;
411: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
412: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
413: END IF;
414: RAISE FND_API.G_EXC_ERROR;

Line 486: FND_MSG_PUB.Count_And_Get

482: COMMIT WORK;
483: END IF;
484:
485: -- Standard call to get message count and IF count is get message info.
486: FND_MSG_PUB.Count_And_Get
487: (p_count => x_msg_count,
488: p_data => x_msg_data );
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN

Line 496: FND_MSG_PUB.Count_And_Get

492: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
493: END IF;
494: x_return_status := FND_API.G_RET_STS_ERROR ;
495: ROLLBACK TO UPDATE_REPAIR_ACTUALS;
496: FND_MSG_PUB.Count_And_Get
497: (p_count => x_msg_count,
498: p_data => x_msg_data );
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 505: FND_MSG_PUB.Count_And_Get

501: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
502: END IF;
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
504: ROLLBACK TO UPDATE_REPAIR_ACTUALS;
505: FND_MSG_PUB.Count_And_Get
506: ( p_count => x_msg_count,
507: p_data => x_msg_data );
508: WHEN OTHERS THEN
509: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 515: IF FND_MSG_PUB.Check_Msg_Level

511: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
512: END IF;
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
514: ROLLBACK TO UPDATE_REPAIR_ACTUALS;
515: IF FND_MSG_PUB.Check_Msg_Level
516: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg
519: (G_PKG_NAME ,

Line 516: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

512: END IF;
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
514: ROLLBACK TO UPDATE_REPAIR_ACTUALS;
515: IF FND_MSG_PUB.Check_Msg_Level
516: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg
519: (G_PKG_NAME ,
520: l_api_name );

Line 518: FND_MSG_PUB.Add_Exc_Msg

514: ROLLBACK TO UPDATE_REPAIR_ACTUALS;
515: IF FND_MSG_PUB.Check_Msg_Level
516: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg
519: (G_PKG_NAME ,
520: l_api_name );
521: END IF;
522: FND_MSG_PUB.Count_And_Get

Line 522: FND_MSG_PUB.Count_And_Get

518: FND_MSG_PUB.Add_Exc_Msg
519: (G_PKG_NAME ,
520: l_api_name );
521: END IF;
522: FND_MSG_PUB.Count_And_Get
523: (p_count => x_msg_count,
524: p_data => x_msg_data );
525: End UPDATE_REPAIR_ACTUALS;
526:

Line 606: FND_MSG_PUB.initialize;

602: END IF;
603:
604: -- Initialize message list if p_init_msg_list is set to TRUE.
605: IF FND_API.to_Boolean( p_init_msg_list ) THEN
606: FND_MSG_PUB.initialize;
607: END IF;
608:
609: -- Initialize API return status to success
610: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 661: FND_MSG_PUB.ADD;

657:
658: IF repair_actual%NOTFOUND THEN
659: FND_MESSAGE.SET_NAME('CSD','CSD_API_ACTUALS_MISSING');
660: FND_MESSAGE.SET_TOKEN('REPAIR_ACTUAL_ID',l_actual_id);
661: FND_MSG_PUB.ADD;
662: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
663: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
664: END IF;
665: RAISE FND_API.G_EXC_ERROR;

Line 688: FND_MSG_PUB.ADD;

684: -- Modified the message name for bugfix 3281321. vkjain.
685: -- FND_MESSAGE.SET_NAME('CSD','CSD_OBJ_VER_MISMATCH');
686: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_OBJ_VER_MISMATCH');
687: -- FND_MESSAGE.SET_TOKEN('REPAIR_ACTUAL_ID',l_actual_id);
688: FND_MSG_PUB.ADD;
689: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
690: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
691: END IF;
692: RAISE FND_API.G_EXC_ERROR;

Line 715: FND_MSG_PUB.ADD;

711: END IF;
712:
713: FND_MESSAGE.SET_NAME('CSD','CSD_ACTUAL_LINE_EXISTS');
714: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID', px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID);
715: FND_MSG_PUB.ADD;
716: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
717: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
718: END IF;
719: RAISE FND_API.G_EXC_ERROR;

Line 759: FND_MSG_PUB.Count_And_Get

755: COMMIT WORK;
756: END IF;
757:
758: -- Standard call to get message count and IF count is get message info.
759: FND_MSG_PUB.Count_And_Get
760: (p_count => x_msg_count,
761: p_data => x_msg_data );
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN

Line 769: FND_MSG_PUB.Count_And_Get

765: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
766: END IF;
767: x_return_status := FND_API.G_RET_STS_ERROR ;
768: ROLLBACK TO DELETE_REPAIR_ACTUALS;
769: FND_MSG_PUB.Count_And_Get
770: (p_count => x_msg_count,
771: p_data => x_msg_data );
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 778: FND_MSG_PUB.Count_And_Get

774: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
775: END IF;
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
777: ROLLBACK TO DELETE_REPAIR_ACTUALS;
778: FND_MSG_PUB.Count_And_Get
779: ( p_count => x_msg_count,
780: p_data => x_msg_data );
781: WHEN OTHERS THEN
782: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 788: IF FND_MSG_PUB.Check_Msg_Level

784: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
785: END IF;
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
787: ROLLBACK TO DELETE_REPAIR_ACTUALS;
788: IF FND_MSG_PUB.Check_Msg_Level
789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
790: THEN
791: FND_MSG_PUB.Add_Exc_Msg
792: (G_PKG_NAME ,

Line 789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

785: END IF;
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
787: ROLLBACK TO DELETE_REPAIR_ACTUALS;
788: IF FND_MSG_PUB.Check_Msg_Level
789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
790: THEN
791: FND_MSG_PUB.Add_Exc_Msg
792: (G_PKG_NAME ,
793: l_api_name );

Line 791: FND_MSG_PUB.Add_Exc_Msg

787: ROLLBACK TO DELETE_REPAIR_ACTUALS;
788: IF FND_MSG_PUB.Check_Msg_Level
789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
790: THEN
791: FND_MSG_PUB.Add_Exc_Msg
792: (G_PKG_NAME ,
793: l_api_name );
794: END IF;
795: FND_MSG_PUB.Count_And_Get

Line 795: FND_MSG_PUB.Count_And_Get

791: FND_MSG_PUB.Add_Exc_Msg
792: (G_PKG_NAME ,
793: l_api_name );
794: END IF;
795: FND_MSG_PUB.Count_And_Get
796: (p_count => x_msg_count,
797: p_data => x_msg_data );
798: End DELETE_REPAIR_ACTUALS;
799:

Line 864: FND_MSG_PUB.initialize;

860: END IF;
861:
862: -- Initialize message list if p_init_msg_list is set to TRUE.
863: IF FND_API.to_Boolean( p_init_msg_list ) THEN
864: FND_MSG_PUB.initialize;
865: END IF;
866:
867: -- Initialize API return status to success
868: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 932: FND_MSG_PUB.Count_And_Get

928: COMMIT WORK;
929: END IF;
930:
931: -- Standard call to get message count and IF count is get message info.
932: FND_MSG_PUB.Count_And_Get
933: (p_count => x_msg_count,
934: p_data => x_msg_data );
935: EXCEPTION
936: WHEN FND_API.G_EXC_ERROR THEN

Line 942: FND_MSG_PUB.Count_And_Get

938: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
939: END IF;
940: x_return_status := FND_API.G_RET_STS_ERROR ;
941: ROLLBACK TO LOCK_REPAIR_ACTUALS;
942: FND_MSG_PUB.Count_And_Get
943: (p_count => x_msg_count,
944: p_data => x_msg_data );
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 951: FND_MSG_PUB.Count_And_Get

947: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
948: END IF;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
950: ROLLBACK TO LOCK_REPAIR_ACTUALS;
951: FND_MSG_PUB.Count_And_Get
952: ( p_count => x_msg_count,
953: p_data => x_msg_data );
954: WHEN OTHERS THEN
955: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 961: IF FND_MSG_PUB.Check_Msg_Level

957: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
958: END IF;
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
960: ROLLBACK TO LOCK_REPAIR_ACTUALS;
961: IF FND_MSG_PUB.Check_Msg_Level
962: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
963: THEN
964: FND_MSG_PUB.Add_Exc_Msg
965: (G_PKG_NAME ,

Line 962: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

958: END IF;
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
960: ROLLBACK TO LOCK_REPAIR_ACTUALS;
961: IF FND_MSG_PUB.Check_Msg_Level
962: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
963: THEN
964: FND_MSG_PUB.Add_Exc_Msg
965: (G_PKG_NAME ,
966: l_api_name );

Line 964: FND_MSG_PUB.Add_Exc_Msg

960: ROLLBACK TO LOCK_REPAIR_ACTUALS;
961: IF FND_MSG_PUB.Check_Msg_Level
962: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
963: THEN
964: FND_MSG_PUB.Add_Exc_Msg
965: (G_PKG_NAME ,
966: l_api_name );
967: END IF;
968: FND_MSG_PUB.Count_And_Get

Line 968: FND_MSG_PUB.Count_And_Get

964: FND_MSG_PUB.Add_Exc_Msg
965: (G_PKG_NAME ,
966: l_api_name );
967: END IF;
968: FND_MSG_PUB.Count_And_Get
969: (p_count => x_msg_count,
970: p_data => x_msg_data );
971:
972: END LOCK_REPAIR_ACTUALS;