59: END IF;
60:
61: -- Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean( p_init_msg_list ) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: IF (lc_proc_level >= lc_debug_level) THEN
67: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
213: COMMIT WORK;
214: END IF;
215:
216: -- Standard call to get message count and IF count is get message info.
217: FND_MSG_PUB.Count_And_Get
218: (p_count => x_msg_count,
219: p_data => x_msg_data );
220:
221: IF (lc_proc_level >= lc_debug_level) THEN
236: 'Adding message CSD_RDC_ASSOCIATION_EXISTS to FND_MSG stack');
237: end if;
238: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_ASSOCIATION_EXISTS');
239: FND_MESSAGE.SET_TOKEN('DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.diagnostic_code_id);
240: FND_MSG_PUB.Add;
241:
242: FND_MSG_PUB.Count_And_Get
243: (p_count => x_msg_count,
244: p_data => x_msg_data );
238: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_ASSOCIATION_EXISTS');
239: FND_MESSAGE.SET_TOKEN('DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.diagnostic_code_id);
240: FND_MSG_PUB.Add;
241:
242: FND_MSG_PUB.Count_And_Get
243: (p_count => x_msg_count,
244: p_data => x_msg_data );
245:
246: -- save message in debug log
253: ROLLBACK TO Create_RO_Diagnostic_Code;
254:
255: x_return_status := FND_API.G_RET_STS_ERROR;
256:
257: FND_MSG_PUB.Count_And_Get
258: (p_count => x_msg_count,
259: p_data => x_msg_data );
260:
261: -- save message in debug log
268: ROLLBACK TO Create_RO_Diagnostic_Code;
269:
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271:
272: IF FND_MSG_PUB.Check_Msg_Level
273: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
274: THEN
275: if (lc_stat_level >= lc_debug_level) then
276: FND_LOG.STRING(lc_stat_level, lc_mod_name,
269:
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271:
272: IF FND_MSG_PUB.Check_Msg_Level
273: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
274: THEN
275: if (lc_stat_level >= lc_debug_level) then
276: FND_LOG.STRING(lc_stat_level, lc_mod_name,
277: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
273: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
274: THEN
275: if (lc_stat_level >= lc_debug_level) then
276: FND_LOG.STRING(lc_stat_level, lc_mod_name,
277: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
278: end if;
279: FND_MSG_PUB.Add_Exc_Msg
280: (G_PKG_NAME ,
281: lc_api_name );
275: if (lc_stat_level >= lc_debug_level) then
276: FND_LOG.STRING(lc_stat_level, lc_mod_name,
277: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
278: end if;
279: FND_MSG_PUB.Add_Exc_Msg
280: (G_PKG_NAME ,
281: lc_api_name );
282: END IF;
283:
280: (G_PKG_NAME ,
281: lc_api_name );
282: END IF;
283:
284: FND_MSG_PUB.Count_And_Get
285: ( p_count => x_msg_count,
286: p_data => x_msg_data );
287:
288: -- save message in debug log
296:
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298:
299: -- save message in fnd stack
300: IF FND_MSG_PUB.Check_Msg_Level
301: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
302: THEN
303: if (lc_stat_level >= lc_debug_level) then
304: FND_LOG.STRING(lc_stat_level, lc_mod_name,
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298:
299: -- save message in fnd stack
300: IF FND_MSG_PUB.Check_Msg_Level
301: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
302: THEN
303: if (lc_stat_level >= lc_debug_level) then
304: FND_LOG.STRING(lc_stat_level, lc_mod_name,
305: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
301: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
302: THEN
303: if (lc_stat_level >= lc_debug_level) then
304: FND_LOG.STRING(lc_stat_level, lc_mod_name,
305: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
306: end if;
307: FND_MSG_PUB.Add_Exc_Msg
308: (G_PKG_NAME ,
309: lc_api_name );
303: if (lc_stat_level >= lc_debug_level) then
304: FND_LOG.STRING(lc_stat_level, lc_mod_name,
305: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
306: end if;
307: FND_MSG_PUB.Add_Exc_Msg
308: (G_PKG_NAME ,
309: lc_api_name );
310: END IF;
311:
308: (G_PKG_NAME ,
309: lc_api_name );
310: END IF;
311:
312: FND_MSG_PUB.Count_And_Get
313: (p_count => x_msg_count,
314: p_data => x_msg_data );
315:
316: -- save message in debug log
382: END IF;
383:
384: -- Initialize message list if p_init_msg_list is set to TRUE.
385: IF FND_API.to_Boolean( p_init_msg_list ) THEN
386: FND_MSG_PUB.initialize;
387: END IF;
388:
389: IF (lc_proc_level >= lc_debug_level) THEN
390: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
624: COMMIT WORK;
625: END IF;
626:
627: -- Standard call to get message count and IF count is get message info.
628: FND_MSG_PUB.Count_And_Get
629: (p_count => x_msg_count,
630: p_data => x_msg_data );
631:
632: IF (lc_proc_level >= lc_debug_level) THEN
648: end if;
649: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
650: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
651: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','REPAIR_LINE_ID');
652: FND_MSG_PUB.Add;
653:
654: FND_MSG_PUB.Count_And_Get
655: (p_count => x_msg_count,
656: p_data => x_msg_data );
650: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
651: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','REPAIR_LINE_ID');
652: FND_MSG_PUB.Add;
653:
654: FND_MSG_PUB.Count_And_Get
655: (p_count => x_msg_count,
656: p_data => x_msg_data );
657:
658: -- save message in debug log
673: end if;
674: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
675: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
676: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','DIAGNOSTIC_CODE_ID');
677: FND_MSG_PUB.Add;
678:
679: FND_MSG_PUB.Count_And_Get
680: (p_count => x_msg_count,
681: p_data => x_msg_data );
675: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
676: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','DIAGNOSTIC_CODE_ID');
677: FND_MSG_PUB.Add;
678:
679: FND_MSG_PUB.Count_And_Get
680: (p_count => x_msg_count,
681: p_data => x_msg_data );
682:
683: -- save message in debug log
698: 'Adding message CSD_RDC_ASSOCIATION_EXISTS to FND_MSG stack');
699: end if;
700: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_ASSOCIATION_EXISTS');
701: FND_MESSAGE.SET_TOKEN('DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.diagnostic_code_id);
702: FND_MSG_PUB.Add;
703:
704: FND_MSG_PUB.Count_And_Get
705: (p_count => x_msg_count,
706: p_data => x_msg_data );
700: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_ASSOCIATION_EXISTS');
701: FND_MESSAGE.SET_TOKEN('DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.diagnostic_code_id);
702: FND_MSG_PUB.Add;
703:
704: FND_MSG_PUB.Count_And_Get
705: (p_count => x_msg_count,
706: p_data => x_msg_data );
707:
708: -- save message in debug log
723: 'Adding message CSD_RDC_INVALID_ID to FND_MSG stack');
724: end if;
725: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_INVALID_ID');
726: FND_MESSAGE.SET_TOKEN('RO_DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.ro_diagnostic_code_id);
727: FND_MSG_PUB.Add;
728:
729: FND_MSG_PUB.Count_And_Get
730: (p_count => x_msg_count,
731: p_data => x_msg_data );
725: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_INVALID_ID');
726: FND_MESSAGE.SET_TOKEN('RO_DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.ro_diagnostic_code_id);
727: FND_MSG_PUB.Add;
728:
729: FND_MSG_PUB.Count_And_Get
730: (p_count => x_msg_count,
731: p_data => x_msg_data );
732:
733: -- save message in debug log
748: 'Adding message CSD_RDC_GET_OVN_ERROR to FND_MSG stack');
749: end if;
750: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_GET_OVN_ERROR');
751: FND_MESSAGE.SET_TOKEN('RO_DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.ro_diagnostic_code_id);
752: FND_MSG_PUB.Add;
753:
754: FND_MSG_PUB.Count_And_Get
755: (p_count => x_msg_count,
756: p_data => x_msg_data );
750: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_GET_OVN_ERROR');
751: FND_MESSAGE.SET_TOKEN('RO_DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.ro_diagnostic_code_id);
752: FND_MSG_PUB.Add;
753:
754: FND_MSG_PUB.Count_And_Get
755: (p_count => x_msg_count,
756: p_data => x_msg_data );
757:
758: -- save message in debug log
773: 'Adding message CSD_RDC_OVN_MISMATCH to FND_MSG stack');
774: end if;
775: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_OVN_MISMATCH');
776: FND_MESSAGE.SET_TOKEN('RO_DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.ro_diagnostic_code_id);
777: FND_MSG_PUB.Add;
778:
779: FND_MSG_PUB.Count_And_Get
780: (p_count => x_msg_count,
781: p_data => x_msg_data );
775: FND_MESSAGE.SET_NAME('CSD','CSD_RDC_OVN_MISMATCH');
776: FND_MESSAGE.SET_TOKEN('RO_DIAGNOSTIC_CODE_ID',p_ro_diagnostic_code_rec.ro_diagnostic_code_id);
777: FND_MSG_PUB.Add;
778:
779: FND_MSG_PUB.Count_And_Get
780: (p_count => x_msg_count,
781: p_data => x_msg_data );
782:
783: -- save message in debug log
790: ROLLBACK TO Update_RO_Diagnostic_Code;
791:
792: x_return_status := FND_API.G_RET_STS_ERROR;
793:
794: FND_MSG_PUB.Count_And_Get
795: (p_count => x_msg_count,
796: p_data => x_msg_data );
797:
798: -- save message in debug log
805: ROLLBACK TO Update_RO_Diagnostic_Code;
806:
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808:
809: IF FND_MSG_PUB.Check_Msg_Level
810: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
811: THEN
812: if (lc_stat_level >= lc_debug_level) then
813: FND_LOG.STRING(lc_stat_level, lc_mod_name,
806:
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808:
809: IF FND_MSG_PUB.Check_Msg_Level
810: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
811: THEN
812: if (lc_stat_level >= lc_debug_level) then
813: FND_LOG.STRING(lc_stat_level, lc_mod_name,
814: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
810: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
811: THEN
812: if (lc_stat_level >= lc_debug_level) then
813: FND_LOG.STRING(lc_stat_level, lc_mod_name,
814: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
815: end if;
816: FND_MSG_PUB.Add_Exc_Msg
817: (G_PKG_NAME ,
818: lc_api_name );
812: if (lc_stat_level >= lc_debug_level) then
813: FND_LOG.STRING(lc_stat_level, lc_mod_name,
814: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
815: end if;
816: FND_MSG_PUB.Add_Exc_Msg
817: (G_PKG_NAME ,
818: lc_api_name );
819: END IF;
820:
817: (G_PKG_NAME ,
818: lc_api_name );
819: END IF;
820:
821: FND_MSG_PUB.Count_And_Get
822: ( p_count => x_msg_count,
823: p_data => x_msg_data );
824:
825: -- save message in debug log
833:
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835:
836: -- save message in fnd stack
837: IF FND_MSG_PUB.Check_Msg_Level
838: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
839: THEN
840: if (lc_stat_level >= lc_debug_level) then
841: FND_LOG.STRING(lc_stat_level, lc_mod_name,
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835:
836: -- save message in fnd stack
837: IF FND_MSG_PUB.Check_Msg_Level
838: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
839: THEN
840: if (lc_stat_level >= lc_debug_level) then
841: FND_LOG.STRING(lc_stat_level, lc_mod_name,
842: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
838: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
839: THEN
840: if (lc_stat_level >= lc_debug_level) then
841: FND_LOG.STRING(lc_stat_level, lc_mod_name,
842: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
843: end if;
844: FND_MSG_PUB.Add_Exc_Msg
845: (G_PKG_NAME ,
846: lc_api_name );
840: if (lc_stat_level >= lc_debug_level) then
841: FND_LOG.STRING(lc_stat_level, lc_mod_name,
842: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
843: end if;
844: FND_MSG_PUB.Add_Exc_Msg
845: (G_PKG_NAME ,
846: lc_api_name );
847: END IF;
848:
845: (G_PKG_NAME ,
846: lc_api_name );
847: END IF;
848:
849: FND_MSG_PUB.Count_And_Get
850: (p_count => x_msg_count,
851: p_data => x_msg_data );
852:
853: -- save message in debug log
909: END IF;
910:
911: -- Initialize message list if p_init_msg_list is set to TRUE.
912: IF FND_API.to_Boolean( p_init_msg_list ) THEN
913: FND_MSG_PUB.initialize;
914: END IF;
915:
916: IF (lc_proc_level >= lc_debug_level) THEN
917: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
971: COMMIT WORK;
972: END IF;
973:
974: -- Standard call to get message count and IF count is get message info.
975: FND_MSG_PUB.Count_And_Get
976: (p_count => x_msg_count,
977: p_data => x_msg_data );
978:
979: IF (lc_proc_level >= lc_debug_level) THEN
986: ROLLBACK TO Delete_RO_Diagnostic_Code;
987:
988: x_return_status := FND_API.G_RET_STS_ERROR;
989:
990: FND_MSG_PUB.Count_And_Get
991: (p_count => x_msg_count,
992: p_data => x_msg_data );
993:
994: -- save message in debug log
1001: ROLLBACK TO Delete_RO_Diagnostic_Code;
1002:
1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1004:
1005: IF FND_MSG_PUB.Check_Msg_Level
1006: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1007: THEN
1008: if (lc_stat_level >= lc_debug_level) then
1009: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1002:
1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1004:
1005: IF FND_MSG_PUB.Check_Msg_Level
1006: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1007: THEN
1008: if (lc_stat_level >= lc_debug_level) then
1009: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1010: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1006: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1007: THEN
1008: if (lc_stat_level >= lc_debug_level) then
1009: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1010: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1011: end if;
1012: FND_MSG_PUB.Add_Exc_Msg
1013: (G_PKG_NAME ,
1014: lc_api_name );
1008: if (lc_stat_level >= lc_debug_level) then
1009: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1010: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1011: end if;
1012: FND_MSG_PUB.Add_Exc_Msg
1013: (G_PKG_NAME ,
1014: lc_api_name );
1015: END IF;
1016:
1013: (G_PKG_NAME ,
1014: lc_api_name );
1015: END IF;
1016:
1017: FND_MSG_PUB.Count_And_Get
1018: ( p_count => x_msg_count,
1019: p_data => x_msg_data );
1020:
1021: -- save message in debug log
1029:
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1031:
1032: -- save message in fnd stack
1033: IF FND_MSG_PUB.Check_Msg_Level
1034: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1035: THEN
1036: if (lc_stat_level >= lc_debug_level) then
1037: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1031:
1032: -- save message in fnd stack
1033: IF FND_MSG_PUB.Check_Msg_Level
1034: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1035: THEN
1036: if (lc_stat_level >= lc_debug_level) then
1037: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1038: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1034: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1035: THEN
1036: if (lc_stat_level >= lc_debug_level) then
1037: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1038: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1039: end if;
1040: FND_MSG_PUB.Add_Exc_Msg
1041: (G_PKG_NAME ,
1042: lc_api_name );
1036: if (lc_stat_level >= lc_debug_level) then
1037: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1038: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1039: end if;
1040: FND_MSG_PUB.Add_Exc_Msg
1041: (G_PKG_NAME ,
1042: lc_api_name );
1043: END IF;
1044:
1041: (G_PKG_NAME ,
1042: lc_api_name );
1043: END IF;
1044:
1045: FND_MSG_PUB.Count_And_Get
1046: (p_count => x_msg_count,
1047: p_data => x_msg_data );
1048:
1049: -- save message in debug log
1104: END IF;
1105:
1106: -- Initialize message list if p_init_msg_list is set to TRUE.
1107: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1108: FND_MSG_PUB.initialize;
1109: END IF;
1110:
1111: IF (lc_proc_level >= lc_debug_level) THEN
1112: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',
1201: COMMIT WORK;
1202: END IF;
1203:
1204: -- Standard call to get message count and IF count is get message info.
1205: FND_MSG_PUB.Count_And_Get
1206: (p_count => x_msg_count,
1207: p_data => x_msg_data );
1208:
1209: IF (lc_proc_level >= lc_debug_level) THEN
1216: ROLLBACK TO Lock_RO_Diagnostic_Code;
1217:
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219:
1220: FND_MSG_PUB.Count_And_Get
1221: (p_count => x_msg_count,
1222: p_data => x_msg_data );
1223:
1224: -- save message in debug log
1231: ROLLBACK TO Lock_RO_Diagnostic_Code;
1232:
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234:
1235: IF FND_MSG_PUB.Check_Msg_Level
1236: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1237: THEN
1238: if (lc_stat_level >= lc_debug_level) then
1239: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1232:
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234:
1235: IF FND_MSG_PUB.Check_Msg_Level
1236: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1237: THEN
1238: if (lc_stat_level >= lc_debug_level) then
1239: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1240: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1236: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1237: THEN
1238: if (lc_stat_level >= lc_debug_level) then
1239: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1240: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1241: end if;
1242: FND_MSG_PUB.Add_Exc_Msg
1243: (G_PKG_NAME ,
1244: lc_api_name );
1238: if (lc_stat_level >= lc_debug_level) then
1239: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1240: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1241: end if;
1242: FND_MSG_PUB.Add_Exc_Msg
1243: (G_PKG_NAME ,
1244: lc_api_name );
1245: END IF;
1246:
1243: (G_PKG_NAME ,
1244: lc_api_name );
1245: END IF;
1246:
1247: FND_MSG_PUB.Count_And_Get
1248: ( p_count => x_msg_count,
1249: p_data => x_msg_data );
1250:
1251: -- save message in debug log
1259:
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261:
1262: -- save message in fnd stack
1263: IF FND_MSG_PUB.Check_Msg_Level
1264: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1265: THEN
1266: if (lc_stat_level >= lc_debug_level) then
1267: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261:
1262: -- save message in fnd stack
1263: IF FND_MSG_PUB.Check_Msg_Level
1264: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1265: THEN
1266: if (lc_stat_level >= lc_debug_level) then
1267: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1268: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1264: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1265: THEN
1266: if (lc_stat_level >= lc_debug_level) then
1267: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1268: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1269: end if;
1270: FND_MSG_PUB.Add_Exc_Msg
1271: (G_PKG_NAME ,
1272: lc_api_name );
1266: if (lc_stat_level >= lc_debug_level) then
1267: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1268: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1269: end if;
1270: FND_MSG_PUB.Add_Exc_Msg
1271: (G_PKG_NAME ,
1272: lc_api_name );
1273: END IF;
1274:
1271: (G_PKG_NAME ,
1272: lc_api_name );
1273: END IF;
1274:
1275: FND_MSG_PUB.Count_And_Get
1276: (p_count => x_msg_count,
1277: p_data => x_msg_data );
1278:
1279: -- save message in debug log