[Home] [Help]
77: FROM HZ_STOCK_MARKETS
78: WHERE stock_exchange_id = l_stock_exchange_id;
79:
80: if l_count > 0 THEN
81: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
82: FND_MESSAGE.SET_TOKEN('COLUMN', 'stock_exchange_id');
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_ERROR;
85: end if;
78: WHERE stock_exchange_id = l_stock_exchange_id;
79:
80: if l_count > 0 THEN
81: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
82: FND_MESSAGE.SET_TOKEN('COLUMN', 'stock_exchange_id');
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_ERROR;
85: end if;
86:
162: BEGIN
163: -- check primary key
164: IF p_stock_markets_rec.stock_exchange_id is NULL OR
165: p_stock_markets_rec.stock_exchange_id = FND_API.G_MISS_NUM THEN
166: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
167: FND_MESSAGE.SET_TOKEN('COLUMN', 'stock_exchange_id');
168: FND_MSG_PUB.ADD;
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
163: -- check primary key
164: IF p_stock_markets_rec.stock_exchange_id is NULL OR
165: p_stock_markets_rec.stock_exchange_id = FND_API.G_MISS_NUM THEN
166: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
167: FND_MESSAGE.SET_TOKEN('COLUMN', 'stock_exchange_id');
168: FND_MSG_PUB.ADD;
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171:
171:
172: -- check last_update_date
173: IF p_last_update_date is NULL OR
174: p_last_update_date = FND_API.G_MISS_DATE THEN
175: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
176: FND_MESSAGE.SET_TOKEN('COLUMN', 'last_update_date');
177: FND_MSG_PUB.ADD;
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
172: -- check last_update_date
173: IF p_last_update_date is NULL OR
174: p_last_update_date = FND_API.G_MISS_DATE THEN
175: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
176: FND_MESSAGE.SET_TOKEN('COLUMN', 'last_update_date');
177: FND_MSG_PUB.ADD;
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
189: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
190: FOR UPDATE NOWAIT;
191:
192: EXCEPTION WHEN NO_DATA_FOUND THEN
193: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
194: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_STOCK_MARKETS');
195: FND_MSG_PUB.ADD;
196: RAISE FND_API.G_EXC_ERROR;
197: end;
190: FOR UPDATE NOWAIT;
191:
192: EXCEPTION WHEN NO_DATA_FOUND THEN
193: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
194: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_STOCK_MARKETS');
195: FND_MSG_PUB.ADD;
196: RAISE FND_API.G_EXC_ERROR;
197: end;
198:
294: FROM HZ_SECURITY_ISSUED
295: WHERE security_issued_id = l_security_issued_id;
296:
297: if l_count > 0 THEN
298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
299: FND_MESSAGE.SET_TOKEN('COLUMN', 'security_issued_id');
300: FND_MSG_PUB.ADD;
301: RAISE FND_API.G_EXC_ERROR;
302: end if;
295: WHERE security_issued_id = l_security_issued_id;
296:
297: if l_count > 0 THEN
298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
299: FND_MESSAGE.SET_TOKEN('COLUMN', 'security_issued_id');
300: FND_MSG_PUB.ADD;
301: RAISE FND_API.G_EXC_ERROR;
302: end if;
303:
387: -- check required field:
388: IF p_security_issued_rec.security_issued_id is NULL OR
389: p_security_issued_rec.security_issued_id = FND_API.G_MISS_NUM THEN
390:
391: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
392: FND_MESSAGE.SET_TOKEN('COLUMN', 'security_issued_id');
393: FND_MSG_PUB.ADD;
394: RAISE FND_API.G_EXC_ERROR;
395:
388: IF p_security_issued_rec.security_issued_id is NULL OR
389: p_security_issued_rec.security_issued_id = FND_API.G_MISS_NUM THEN
390:
391: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
392: FND_MESSAGE.SET_TOKEN('COLUMN', 'security_issued_id');
393: FND_MSG_PUB.ADD;
394: RAISE FND_API.G_EXC_ERROR;
395:
396: END IF;
397:
398: IF p_last_update_date IS NULL OR
399: p_last_update_date = FND_API.G_MISS_DATE
400: THEN
401: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
402: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
403: FND_MSG_PUB.ADD;
404: RAISE FND_API.G_EXC_ERROR;
405: END IF;
398: IF p_last_update_date IS NULL OR
399: p_last_update_date = FND_API.G_MISS_DATE
400: THEN
401: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
402: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
403: FND_MSG_PUB.ADD;
404: RAISE FND_API.G_EXC_ERROR;
405: END IF;
406: begin
414: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
415: FOR UPDATE NOWAIT;
416:
417: EXCEPTION WHEN NO_DATA_FOUND THEN
418: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
419: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_SECURITY_ISSUED');
420: FND_MSG_PUB.ADD;
421: RAISE FND_API.G_EXC_ERROR;
422: end;
415: FOR UPDATE NOWAIT;
416:
417: EXCEPTION WHEN NO_DATA_FOUND THEN
418: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
419: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_SECURITY_ISSUED');
420: FND_MSG_PUB.ADD;
421: RAISE FND_API.G_EXC_ERROR;
422: end;
423:
527:
528: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
529: RAISE FND_API.G_EXC_ERROR;
530: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
531: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
532: FND_MESSAGE.SET_TOKEN('PROCEDURE',
533: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_REPORTS_PRE');
534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
535: FND_MSG_PUB.ADD;
528: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
529: RAISE FND_API.G_EXC_ERROR;
530: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
531: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
532: FND_MESSAGE.SET_TOKEN('PROCEDURE',
533: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_REPORTS_PRE');
534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
535: FND_MSG_PUB.ADD;
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
531: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
532: FND_MESSAGE.SET_TOKEN('PROCEDURE',
533: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_REPORTS_PRE');
534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
535: FND_MSG_PUB.ADD;
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538: END IF;
561: FROM HZ_FINANCIAL_REPORTS
562: WHERE financial_report_id = l_financial_report_id;
563:
564: IF l_count > 0 THEN
565: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
566: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');
567: FND_MSG_PUB.ADD;
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
562: WHERE financial_report_id = l_financial_report_id;
563:
564: IF l_count > 0 THEN
565: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
566: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');
567: FND_MSG_PUB.ADD;
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570: END IF;
640:
641: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
642: RAISE FND_API.G_EXC_ERROR;
643: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
644: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
645: FND_MESSAGE.SET_TOKEN('PROCEDURE',
646: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_REPORTS_POST');
647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
648: FND_MSG_PUB.ADD;
641: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
642: RAISE FND_API.G_EXC_ERROR;
643: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
644: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
645: FND_MESSAGE.SET_TOKEN('PROCEDURE',
646: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_REPORTS_POST');
647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
648: FND_MSG_PUB.ADD;
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
643: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
644: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
645: FND_MESSAGE.SET_TOKEN('PROCEDURE',
646: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_REPORTS_POST');
647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
648: FND_MSG_PUB.ADD;
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651: END IF;
700: -- check required fields:
701: IF p_financial_reports_rec.financial_report_id is NULL OR
702: p_financial_reports_rec.financial_report_id = FND_API.G_MISS_NUM
703: THEN
704: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
705: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
701: IF p_financial_reports_rec.financial_report_id is NULL OR
702: p_financial_reports_rec.financial_report_id = FND_API.G_MISS_NUM
703: THEN
704: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
705: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709:
709:
710: IF p_last_update_date IS NULL OR
711: p_last_update_date = FND_API.G_MISS_DATE
712: THEN
713: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
714: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
715: FND_MSG_PUB.ADD;
716: RAISE FND_API.G_EXC_ERROR;
717: END IF;
710: IF p_last_update_date IS NULL OR
711: p_last_update_date = FND_API.G_MISS_DATE
712: THEN
713: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
714: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
715: FND_MSG_PUB.ADD;
716: RAISE FND_API.G_EXC_ERROR;
717: END IF;
718:
727: FOR UPDATE NOWAIT;
728:
729: EXCEPTION
730: WHEN NO_DATA_FOUND THEN
731: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
732: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_REPORTS');
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END;
728:
729: EXCEPTION
730: WHEN NO_DATA_FOUND THEN
731: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
732: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_REPORTS');
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END;
736:
750:
751: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
752: RAISE FND_API.G_EXC_ERROR;
753: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
754: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
755: FND_MESSAGE.SET_TOKEN('PROCEDURE',
756: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_REPORTS_PRE');
757: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
758: FND_MSG_PUB.ADD;
751: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
752: RAISE FND_API.G_EXC_ERROR;
753: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
754: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
755: FND_MESSAGE.SET_TOKEN('PROCEDURE',
756: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_REPORTS_PRE');
757: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
758: FND_MSG_PUB.ADD;
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
754: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
755: FND_MESSAGE.SET_TOKEN('PROCEDURE',
756: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_REPORTS_PRE');
757: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
758: FND_MSG_PUB.ADD;
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END IF;
761: END IF;
832:
833: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
834: RAISE FND_API.G_EXC_ERROR;
835: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
836: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
837: FND_MESSAGE.SET_TOKEN('PROCEDURE',
838: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_REPORTS_POST');
839: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
840: FND_MSG_PUB.ADD;
833: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
834: RAISE FND_API.G_EXC_ERROR;
835: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
836: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
837: FND_MESSAGE.SET_TOKEN('PROCEDURE',
838: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_REPORTS_POST');
839: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
836: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
837: FND_MESSAGE.SET_TOKEN('PROCEDURE',
838: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_REPORTS_POST');
839: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843: END IF;
915: FROM HZ_FINANCIAL_NUMBERS
916: WHERE financial_number_id = l_financial_number_id;
917:
918: IF l_count > 0 THEN
919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
920: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_number_id');
921: FND_MSG_PUB.ADD;
922: RAISE FND_API.G_EXC_ERROR;
923: END IF;
916: WHERE financial_number_id = l_financial_number_id;
917:
918: IF l_count > 0 THEN
919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
920: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_number_id');
921: FND_MSG_PUB.ADD;
922: RAISE FND_API.G_EXC_ERROR;
923: END IF;
924: END IF;
984:
985: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
986: RAISE FND_API.G_EXC_ERROR;
987: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
988: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
989: FND_MESSAGE.SET_TOKEN('PROCEDURE',
990: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_NUMBERS_PRE');
991: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
992: FND_MSG_PUB.ADD;
985: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
986: RAISE FND_API.G_EXC_ERROR;
987: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
988: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
989: FND_MESSAGE.SET_TOKEN('PROCEDURE',
990: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_NUMBERS_PRE');
991: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
992: FND_MSG_PUB.ADD;
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
988: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
989: FND_MESSAGE.SET_TOKEN('PROCEDURE',
990: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_NUMBERS_PRE');
991: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
992: FND_MSG_PUB.ADD;
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;
995: END IF;
1039:
1040: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1041: RAISE FND_API.G_EXC_ERROR;
1042: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1043: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1044: FND_MESSAGE.SET_TOKEN('PROCEDURE',
1045: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_NUMBERS_POST');
1046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1047: FND_MSG_PUB.ADD;
1040: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1041: RAISE FND_API.G_EXC_ERROR;
1042: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1043: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1044: FND_MESSAGE.SET_TOKEN('PROCEDURE',
1045: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_NUMBERS_POST');
1046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1047: FND_MSG_PUB.ADD;
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1043: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1044: FND_MESSAGE.SET_TOKEN('PROCEDURE',
1045: 'HZ_ORG_INFO_CRMHK.CREATE_FINANCIAL_NUMBERS_POST');
1046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1047: FND_MSG_PUB.ADD;
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END IF;
1050: END IF;
1105: -- check required fields:
1106: IF p_financial_numbers_rec.financial_number_id is NULL OR
1107: p_financial_numbers_rec.financial_number_id = FND_API.G_MISS_NUM
1108: THEN
1109: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1110: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_number_id');
1111: FND_MSG_PUB.ADD;
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;
1106: IF p_financial_numbers_rec.financial_number_id is NULL OR
1107: p_financial_numbers_rec.financial_number_id = FND_API.G_MISS_NUM
1108: THEN
1109: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1110: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_number_id');
1111: FND_MSG_PUB.ADD;
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;
1114:
1114:
1115: IF p_last_update_date IS NULL OR
1116: p_last_update_date = FND_API.G_MISS_DATE
1117: THEN
1118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1119: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1120: FND_MSG_PUB.ADD;
1121: RAISE FND_API.G_EXC_ERROR;
1122: END IF;
1115: IF p_last_update_date IS NULL OR
1116: p_last_update_date = FND_API.G_MISS_DATE
1117: THEN
1118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1119: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1120: FND_MSG_PUB.ADD;
1121: RAISE FND_API.G_EXC_ERROR;
1122: END IF;
1123:
1132: FOR UPDATE NOWAIT;
1133:
1134: EXCEPTION
1135: WHEN NO_DATA_FOUND THEN
1136: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1137: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_NUMBERS');
1138: FND_MSG_PUB.ADD;
1139: RAISE FND_API.G_EXC_ERROR;
1140: END;
1133:
1134: EXCEPTION
1135: WHEN NO_DATA_FOUND THEN
1136: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1137: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_NUMBERS');
1138: FND_MSG_PUB.ADD;
1139: RAISE FND_API.G_EXC_ERROR;
1140: END;
1141:
1185:
1186: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1187: RAISE FND_API.G_EXC_ERROR;
1188: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1190: FND_MESSAGE.SET_TOKEN('PROCEDURE',
1191: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_NUMBERS_PRE');
1192: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1193: FND_MSG_PUB.ADD;
1186: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1187: RAISE FND_API.G_EXC_ERROR;
1188: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1190: FND_MESSAGE.SET_TOKEN('PROCEDURE',
1191: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_NUMBERS_PRE');
1192: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1193: FND_MSG_PUB.ADD;
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1188: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1190: FND_MESSAGE.SET_TOKEN('PROCEDURE',
1191: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_NUMBERS_PRE');
1192: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1193: FND_MSG_PUB.ADD;
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: END IF;
1196: END IF;
1254:
1255: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1256: RAISE FND_API.G_EXC_ERROR;
1257: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1258: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1259: FND_MESSAGE.SET_TOKEN('PROCEDURE',
1260: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_NUMBERS_POST');
1261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1262: FND_MSG_PUB.ADD;
1255: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1256: RAISE FND_API.G_EXC_ERROR;
1257: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1258: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1259: FND_MESSAGE.SET_TOKEN('PROCEDURE',
1260: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_NUMBERS_POST');
1261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1262: FND_MSG_PUB.ADD;
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1257: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1258: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
1259: FND_MESSAGE.SET_TOKEN('PROCEDURE',
1260: 'HZ_ORG_INFO_CRMHK.UPDATE_FINANCIAL_NUMBERS_POST');
1261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1262: FND_MSG_PUB.ADD;
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: END IF;
1265: END IF;
1328: FROM HZ_CERTIFICATIONS
1329: WHERE certification_id = l_certification_id;
1330:
1331: if l_count > 0 THEN
1332: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1333: FND_MESSAGE.SET_TOKEN('COLUMN', 'certification_id');
1334: FND_MSG_PUB.ADD;
1335: RAISE FND_API.G_EXC_ERROR;
1336: end if;
1329: WHERE certification_id = l_certification_id;
1330:
1331: if l_count > 0 THEN
1332: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1333: FND_MESSAGE.SET_TOKEN('COLUMN', 'certification_id');
1334: FND_MSG_PUB.ADD;
1335: RAISE FND_API.G_EXC_ERROR;
1336: end if;
1337:
1417: -- check required fields:
1418: IF p_certifications_rec.certification_id is NULL OR
1419: p_certifications_rec.certification_id = FND_API.G_MISS_NUM THEN
1420:
1421: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1422: FND_MESSAGE.SET_TOKEN('COLUMN', 'certification_id');
1423: FND_MSG_PUB.ADD;
1424: RAISE FND_API.G_EXC_ERROR;
1425:
1418: IF p_certifications_rec.certification_id is NULL OR
1419: p_certifications_rec.certification_id = FND_API.G_MISS_NUM THEN
1420:
1421: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1422: FND_MESSAGE.SET_TOKEN('COLUMN', 'certification_id');
1423: FND_MSG_PUB.ADD;
1424: RAISE FND_API.G_EXC_ERROR;
1425:
1426: END IF;
1427:
1428: IF p_last_update_date IS NULL OR
1429: p_last_update_date = FND_API.G_MISS_DATE
1430: THEN
1431: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1432: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1433: FND_MSG_PUB.ADD;
1434: RAISE FND_API.G_EXC_ERROR;
1435: END IF;
1428: IF p_last_update_date IS NULL OR
1429: p_last_update_date = FND_API.G_MISS_DATE
1430: THEN
1431: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1432: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1433: FND_MSG_PUB.ADD;
1434: RAISE FND_API.G_EXC_ERROR;
1435: END IF;
1436: begin
1444: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
1445: FOR UPDATE NOWAIT;
1446:
1447: EXCEPTION WHEN NO_DATA_FOUND THEN
1448: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1449: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CERTIFICATIONS');
1450: FND_MSG_PUB.ADD;
1451: RAISE FND_API.G_EXC_ERROR;
1452: end;
1445: FOR UPDATE NOWAIT;
1446:
1447: EXCEPTION WHEN NO_DATA_FOUND THEN
1448: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1449: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CERTIFICATIONS');
1450: FND_MSG_PUB.ADD;
1451: RAISE FND_API.G_EXC_ERROR;
1452: end;
1453:
1554: FROM HZ_INDUSTRIAL_REFERENCE
1555: WHERE industry_reference_id = l_industry_reference_id;
1556:
1557: if l_count > 0 THEN
1558: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1559: FND_MESSAGE.SET_TOKEN('COLUMN', 'industry_reference_id');
1560: FND_MSG_PUB.ADD;
1561: RAISE FND_API.G_EXC_ERROR;
1562: end if;
1555: WHERE industry_reference_id = l_industry_reference_id;
1556:
1557: if l_count > 0 THEN
1558: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1559: FND_MESSAGE.SET_TOKEN('COLUMN', 'industry_reference_id');
1560: FND_MSG_PUB.ADD;
1561: RAISE FND_API.G_EXC_ERROR;
1562: end if;
1563:
1642: -- check required fields:
1643: IF p_industrial_reference_rec.industry_reference_id is NULL OR
1644: p_industrial_reference_rec.industry_reference_id = FND_API.G_MISS_NUM THEN
1645:
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1647: FND_MESSAGE.SET_TOKEN('COLUMN', 'industry_reference_id');
1648: FND_MSG_PUB.ADD;
1649: RAISE FND_API.G_EXC_ERROR;
1650:
1643: IF p_industrial_reference_rec.industry_reference_id is NULL OR
1644: p_industrial_reference_rec.industry_reference_id = FND_API.G_MISS_NUM THEN
1645:
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1647: FND_MESSAGE.SET_TOKEN('COLUMN', 'industry_reference_id');
1648: FND_MSG_PUB.ADD;
1649: RAISE FND_API.G_EXC_ERROR;
1650:
1651: END IF;
1652:
1653: IF p_last_update_date IS NULL OR
1654: p_last_update_date = FND_API.G_MISS_DATE
1655: THEN
1656: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1657: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1658: FND_MSG_PUB.ADD;
1659: RAISE FND_API.G_EXC_ERROR;
1660: END IF;
1653: IF p_last_update_date IS NULL OR
1654: p_last_update_date = FND_API.G_MISS_DATE
1655: THEN
1656: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1657: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1658: FND_MSG_PUB.ADD;
1659: RAISE FND_API.G_EXC_ERROR;
1660: END IF;
1661: begin
1669: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
1670: FOR UPDATE NOWAIT;
1671:
1672: EXCEPTION WHEN NO_DATA_FOUND THEN
1673: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1674: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_REFERENCE');
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_ERROR;
1677: end;
1670: FOR UPDATE NOWAIT;
1671:
1672: EXCEPTION WHEN NO_DATA_FOUND THEN
1673: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1674: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_REFERENCE');
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_ERROR;
1677: end;
1678:
1777: FROM HZ_INDUSTRIAL_CLASSES
1778: WHERE industrial_class_id = l_industrial_class_id;
1779:
1780: if l_count > 0 THEN
1781: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1782: FND_MESSAGE.SET_TOKEN('COLUMN', 'industrial_class_id');
1783: FND_MSG_PUB.ADD;
1784: RAISE FND_API.G_EXC_ERROR;
1785: end if;
1778: WHERE industrial_class_id = l_industrial_class_id;
1779:
1780: if l_count > 0 THEN
1781: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1782: FND_MESSAGE.SET_TOKEN('COLUMN', 'industrial_class_id');
1783: FND_MSG_PUB.ADD;
1784: RAISE FND_API.G_EXC_ERROR;
1785: end if;
1786:
1864: -- check required field:
1865: IF p_industrial_classes_rec.industrial_class_id is NULL OR
1866: p_industrial_classes_rec.industrial_class_id = FND_API.G_MISS_NUM THEN
1867:
1868: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1869: FND_MESSAGE.SET_TOKEN('COLUMN', 'industrial_class_id');
1870: FND_MSG_PUB.ADD;
1871: RAISE FND_API.G_EXC_ERROR;
1872:
1865: IF p_industrial_classes_rec.industrial_class_id is NULL OR
1866: p_industrial_classes_rec.industrial_class_id = FND_API.G_MISS_NUM THEN
1867:
1868: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1869: FND_MESSAGE.SET_TOKEN('COLUMN', 'industrial_class_id');
1870: FND_MSG_PUB.ADD;
1871: RAISE FND_API.G_EXC_ERROR;
1872:
1873: END IF;
1874:
1875: IF p_last_update_date IS NULL OR
1876: p_last_update_date = FND_API.G_MISS_DATE
1877: THEN
1878: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1879: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1880: FND_MSG_PUB.ADD;
1881: RAISE FND_API.G_EXC_ERROR;
1882: END IF;
1875: IF p_last_update_date IS NULL OR
1876: p_last_update_date = FND_API.G_MISS_DATE
1877: THEN
1878: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1879: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
1880: FND_MSG_PUB.ADD;
1881: RAISE FND_API.G_EXC_ERROR;
1882: END IF;
1883: begin
1891: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
1892: FOR UPDATE NOWAIT;
1893:
1894: EXCEPTION WHEN NO_DATA_FOUND THEN
1895: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1896: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_CLASSES');
1897: FND_MSG_PUB.ADD;
1898: RAISE FND_API.G_EXC_ERROR;
1899: end;
1892: FOR UPDATE NOWAIT;
1893:
1894: EXCEPTION WHEN NO_DATA_FOUND THEN
1895: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1896: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_CLASSES');
1897: FND_MSG_PUB.ADD;
1898: RAISE FND_API.G_EXC_ERROR;
1899: end;
1900:
2048:
2049: -- Check whether primary key has been passed in.
2050: IF p_industrial_class_id IS NULL OR
2051: p_industrial_class_id = FND_API.G_MISS_NUM THEN
2052: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2053: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'industrial_class_id' );
2054: FND_MSG_PUB.ADD;
2055: RAISE FND_API.G_EXC_ERROR;
2056: END IF;
2049: -- Check whether primary key has been passed in.
2050: IF p_industrial_class_id IS NULL OR
2051: p_industrial_class_id = FND_API.G_MISS_NUM THEN
2052: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2053: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'industrial_class_id' );
2054: FND_MSG_PUB.ADD;
2055: RAISE FND_API.G_EXC_ERROR;
2056: END IF;
2057:
2058: OPEN c1;
2059: FETCH c1 INTO lrec;
2060: IF c1%NOTFOUND THEN
2061:
2062: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2063: FND_MESSAGE.SET_TOKEN('RECORD', 'industrial_class');
2064: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_industrial_class_id));
2065: FND_MSG_PUB.ADD;
2066: RAISE FND_API.G_EXC_ERROR;
2059: FETCH c1 INTO lrec;
2060: IF c1%NOTFOUND THEN
2061:
2062: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2063: FND_MESSAGE.SET_TOKEN('RECORD', 'industrial_class');
2064: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_industrial_class_id));
2065: FND_MSG_PUB.ADD;
2066: RAISE FND_API.G_EXC_ERROR;
2067:
2060: IF c1%NOTFOUND THEN
2061:
2062: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2063: FND_MESSAGE.SET_TOKEN('RECORD', 'industrial_class');
2064: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_industrial_class_id));
2065: FND_MSG_PUB.ADD;
2066: RAISE FND_API.G_EXC_ERROR;
2067:
2068: ELSE
2092:
2093: WHEN OTHERS THEN
2094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2095:
2096: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2097: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2098: FND_MSG_PUB.ADD;
2099:
2100: FND_MSG_PUB.Count_And_Get(
2093: WHEN OTHERS THEN
2094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2095:
2096: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2097: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2098: FND_MSG_PUB.ADD;
2099:
2100: FND_MSG_PUB.Count_And_Get(
2101: p_encoded => FND_API.G_FALSE,
2160:
2161: -- Check whether primary key has been passed in.
2162: IF p_stock_exchange_id IS NULL OR
2163: p_stock_exchange_id = FND_API.G_MISS_NUM THEN
2164: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2165: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'stock_exchange_id' );
2166: FND_MSG_PUB.ADD;
2167: RAISE FND_API.G_EXC_ERROR;
2168: END IF;
2161: -- Check whether primary key has been passed in.
2162: IF p_stock_exchange_id IS NULL OR
2163: p_stock_exchange_id = FND_API.G_MISS_NUM THEN
2164: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2165: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'stock_exchange_id' );
2166: FND_MSG_PUB.ADD;
2167: RAISE FND_API.G_EXC_ERROR;
2168: END IF;
2169:
2169:
2170: OPEN c1;
2171: FETCH c1 INTO lrec;
2172: IF c1%NOTFOUND THEN
2173: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2174: FND_MESSAGE.SET_TOKEN('RECORD', 'stock_markets');
2175: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_stock_exchange_id));
2176: FND_MSG_PUB.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2170: OPEN c1;
2171: FETCH c1 INTO lrec;
2172: IF c1%NOTFOUND THEN
2173: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2174: FND_MESSAGE.SET_TOKEN('RECORD', 'stock_markets');
2175: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_stock_exchange_id));
2176: FND_MSG_PUB.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2178: ELSE
2171: FETCH c1 INTO lrec;
2172: IF c1%NOTFOUND THEN
2173: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2174: FND_MESSAGE.SET_TOKEN('RECORD', 'stock_markets');
2175: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_stock_exchange_id));
2176: FND_MSG_PUB.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2178: ELSE
2179: x_stock_markets_rec.stock_exchange_id := lrec.stock_exchange_id;
2199: p_data => x_msg_data);
2200:
2201: WHEN OTHERS THEN
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2203: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2204: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2205: FND_MSG_PUB.ADD;
2206:
2207: FND_MSG_PUB.Count_And_Get(
2200:
2201: WHEN OTHERS THEN
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2203: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2204: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2205: FND_MSG_PUB.ADD;
2206:
2207: FND_MSG_PUB.Count_And_Get(
2208: p_encoded => FND_API.G_FALSE,
2277:
2278: -- Check whether primary key has been passed in.
2279: IF p_security_issued_id IS NULL OR
2280: p_security_issued_id = FND_API.G_MISS_NUM THEN
2281: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2282: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'security_issued_id' );
2283: FND_MSG_PUB.ADD;
2284: RAISE FND_API.G_EXC_ERROR;
2285: END IF;
2278: -- Check whether primary key has been passed in.
2279: IF p_security_issued_id IS NULL OR
2280: p_security_issued_id = FND_API.G_MISS_NUM THEN
2281: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2282: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'security_issued_id' );
2283: FND_MSG_PUB.ADD;
2284: RAISE FND_API.G_EXC_ERROR;
2285: END IF;
2286:
2286:
2287: OPEN c1;
2288: FETCH c1 INTO lrec;
2289: IF c1%NOTFOUND THEN
2290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2291: FND_MESSAGE.SET_TOKEN('RECORD', 'security_issued');
2292: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_security_issued_id));
2293: FND_MSG_PUB.ADD;
2294: RAISE FND_API.G_EXC_ERROR;
2287: OPEN c1;
2288: FETCH c1 INTO lrec;
2289: IF c1%NOTFOUND THEN
2290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2291: FND_MESSAGE.SET_TOKEN('RECORD', 'security_issued');
2292: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_security_issued_id));
2293: FND_MSG_PUB.ADD;
2294: RAISE FND_API.G_EXC_ERROR;
2295: ELSE
2288: FETCH c1 INTO lrec;
2289: IF c1%NOTFOUND THEN
2290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2291: FND_MESSAGE.SET_TOKEN('RECORD', 'security_issued');
2292: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_security_issued_id));
2293: FND_MSG_PUB.ADD;
2294: RAISE FND_API.G_EXC_ERROR;
2295: ELSE
2296: x_security_issued_rec.security_issued_id := lrec.security_issued_id;
2325:
2326: WHEN OTHERS THEN
2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2328:
2329: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2330: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2331: FND_MSG_PUB.ADD;
2332:
2333: FND_MSG_PUB.Count_And_Get(
2326: WHEN OTHERS THEN
2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2328:
2329: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2330: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2331: FND_MSG_PUB.ADD;
2332:
2333: FND_MSG_PUB.Count_And_Get(
2334: p_encoded => FND_API.G_FALSE,
2400:
2401: -- Check whether primary key has been passed in.
2402: IF p_certification_id IS NULL OR
2403: p_certification_id = FND_API.G_MISS_NUM THEN
2404: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2405: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'certification_id' );
2406: FND_MSG_PUB.ADD;
2407: RAISE FND_API.G_EXC_ERROR;
2408: END IF;
2401: -- Check whether primary key has been passed in.
2402: IF p_certification_id IS NULL OR
2403: p_certification_id = FND_API.G_MISS_NUM THEN
2404: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2405: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'certification_id' );
2406: FND_MSG_PUB.ADD;
2407: RAISE FND_API.G_EXC_ERROR;
2408: END IF;
2409:
2410: OPEN c1;
2411: FETCH c1 INTO lrec;
2412: IF c1%NOTFOUND THEN
2413:
2414: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2415: FND_MESSAGE.SET_TOKEN('RECORD', 'certifications');
2416: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_certification_id));
2417: FND_MSG_PUB.ADD;
2418: RAISE FND_API.G_EXC_ERROR;
2411: FETCH c1 INTO lrec;
2412: IF c1%NOTFOUND THEN
2413:
2414: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2415: FND_MESSAGE.SET_TOKEN('RECORD', 'certifications');
2416: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_certification_id));
2417: FND_MSG_PUB.ADD;
2418: RAISE FND_API.G_EXC_ERROR;
2419:
2412: IF c1%NOTFOUND THEN
2413:
2414: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2415: FND_MESSAGE.SET_TOKEN('RECORD', 'certifications');
2416: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_certification_id));
2417: FND_MSG_PUB.ADD;
2418: RAISE FND_API.G_EXC_ERROR;
2419:
2420: ELSE
2450:
2451: WHEN OTHERS THEN
2452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2453:
2454: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2455: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2456: FND_MSG_PUB.ADD;
2457:
2458: FND_MSG_PUB.Count_And_Get(
2451: WHEN OTHERS THEN
2452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2453:
2454: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2455: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2456: FND_MSG_PUB.ADD;
2457:
2458: FND_MSG_PUB.Count_And_Get(
2459: p_encoded => FND_API.G_FALSE,
2523: FROM HZ_INDUSTRIAL_CLASS_APP
2524: WHERE code_applied_id = l_code_applied_id;
2525:
2526: if l_count > 0 THEN
2527: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2528: FND_MESSAGE.SET_TOKEN('COLUMN', 'code_applied_id');
2529: FND_MSG_PUB.ADD;
2530: RAISE FND_API.G_EXC_ERROR;
2531: end if;
2524: WHERE code_applied_id = l_code_applied_id;
2525:
2526: if l_count > 0 THEN
2527: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2528: FND_MESSAGE.SET_TOKEN('COLUMN', 'code_applied_id');
2529: FND_MSG_PUB.ADD;
2530: RAISE FND_API.G_EXC_ERROR;
2531: end if;
2532:
2612: -- check required field:
2613: IF p_industrial_class_app_rec.code_applied_id is NULL OR
2614: p_industrial_class_app_rec.code_applied_id = FND_API.G_MISS_NUM THEN
2615:
2616: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
2617: FND_MESSAGE.SET_TOKEN('COLUMN', 'code_applied_id');
2618: FND_MSG_PUB.ADD;
2619: RAISE FND_API.G_EXC_ERROR;
2620:
2613: IF p_industrial_class_app_rec.code_applied_id is NULL OR
2614: p_industrial_class_app_rec.code_applied_id = FND_API.G_MISS_NUM THEN
2615:
2616: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
2617: FND_MESSAGE.SET_TOKEN('COLUMN', 'code_applied_id');
2618: FND_MSG_PUB.ADD;
2619: RAISE FND_API.G_EXC_ERROR;
2620:
2621: END IF;
2622:
2623: IF p_last_update_date IS NULL OR
2624: p_last_update_date = FND_API.G_MISS_DATE
2625: THEN
2626: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
2627: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
2628: FND_MSG_PUB.ADD;
2629: RAISE FND_API.G_EXC_ERROR;
2630: END IF;
2623: IF p_last_update_date IS NULL OR
2624: p_last_update_date = FND_API.G_MISS_DATE
2625: THEN
2626: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
2627: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
2628: FND_MSG_PUB.ADD;
2629: RAISE FND_API.G_EXC_ERROR;
2630: END IF;
2631: begin
2639: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
2640: FOR UPDATE NOWAIT;
2641:
2642: EXCEPTION WHEN NO_DATA_FOUND THEN
2643: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2644: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_CLASS_APP');
2645: FND_MSG_PUB.ADD;
2646: RAISE FND_API.G_EXC_ERROR;
2647: end;
2640: FOR UPDATE NOWAIT;
2641:
2642: EXCEPTION WHEN NO_DATA_FOUND THEN
2643: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2644: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_INDUSTRIAL_CLASS_APP');
2645: FND_MSG_PUB.ADD;
2646: RAISE FND_API.G_EXC_ERROR;
2647: end;
2648:
2765:
2766: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2767: RAISE FND_API.G_EXC_ERROR;
2768: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2769: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2770: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2771: 'HZ_ORG_INFO_CRMHK.CREATE_STOCK_MARKETS_PRE');
2772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2773: FND_MSG_PUB.ADD;
2766: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2767: RAISE FND_API.G_EXC_ERROR;
2768: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2769: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2770: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2771: 'HZ_ORG_INFO_CRMHK.CREATE_STOCK_MARKETS_PRE');
2772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2773: FND_MSG_PUB.ADD;
2774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2768: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2769: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2770: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2771: 'HZ_ORG_INFO_CRMHK.CREATE_STOCK_MARKETS_PRE');
2772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2773: FND_MSG_PUB.ADD;
2774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2775: END IF;
2776:
2794:
2795: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2796: RAISE FND_API.G_EXC_ERROR;
2797: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2799: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2800: 'HZ_ORG_INFO_CRMHK.CREATE_STOCK_MARKETS_POST');
2801: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2802: FND_MSG_PUB.ADD;
2795: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2796: RAISE FND_API.G_EXC_ERROR;
2797: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2799: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2800: 'HZ_ORG_INFO_CRMHK.CREATE_STOCK_MARKETS_POST');
2801: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2802: FND_MSG_PUB.ADD;
2803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2797: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2799: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2800: 'HZ_ORG_INFO_CRMHK.CREATE_STOCK_MARKETS_POST');
2801: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2802: FND_MSG_PUB.ADD;
2803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2804: END IF;
2805:
2843: WHEN OTHERS THEN
2844: ROLLBACK TO create_stock_markets_pub;
2845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2846:
2847: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2848: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2849: FND_MSG_PUB.ADD;
2850:
2851: FND_MSG_PUB.Count_And_Get(
2844: ROLLBACK TO create_stock_markets_pub;
2845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2846:
2847: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2848: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2849: FND_MSG_PUB.ADD;
2850:
2851: FND_MSG_PUB.Count_And_Get(
2852: p_encoded => FND_API.G_FALSE,
2935:
2936: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2937: RAISE FND_API.G_EXC_ERROR;
2938: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2939: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2940: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2941: 'HZ_ORG_INFO_CRMHK.UPDATE_STOCK_MARKETS_PRE');
2942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2943: FND_MSG_PUB.ADD;
2936: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2937: RAISE FND_API.G_EXC_ERROR;
2938: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2939: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2940: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2941: 'HZ_ORG_INFO_CRMHK.UPDATE_STOCK_MARKETS_PRE');
2942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2943: FND_MSG_PUB.ADD;
2944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2938: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2939: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2940: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2941: 'HZ_ORG_INFO_CRMHK.UPDATE_STOCK_MARKETS_PRE');
2942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2943: FND_MSG_PUB.ADD;
2944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2945: END IF;
2946:
2979:
2980: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2981: RAISE FND_API.G_EXC_ERROR;
2982: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2983: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2984: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2985: 'HZ_ORG_INFO_CRMHK.UPDATE_STOCK_MARKETS_POST');
2986: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2987: FND_MSG_PUB.ADD;
2980: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2981: RAISE FND_API.G_EXC_ERROR;
2982: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2983: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2984: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2985: 'HZ_ORG_INFO_CRMHK.UPDATE_STOCK_MARKETS_POST');
2986: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2987: FND_MSG_PUB.ADD;
2988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2982: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2983: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
2984: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2985: 'HZ_ORG_INFO_CRMHK.UPDATE_STOCK_MARKETS_POST');
2986: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2987: FND_MSG_PUB.ADD;
2988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2989: END IF;
2990:
3028: WHEN OTHERS THEN
3029: ROLLBACK TO update_stock_markets_pub;
3030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3031:
3032: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3034: FND_MSG_PUB.ADD;
3035:
3036: FND_MSG_PUB.Count_And_Get(
3029: ROLLBACK TO update_stock_markets_pub;
3030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3031:
3032: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3034: FND_MSG_PUB.ADD;
3035:
3036: FND_MSG_PUB.Count_And_Get(
3037: p_encoded => FND_API.G_FALSE,
3119:
3120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3124: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3125: 'HZ_ORG_INFO_CRMHK.CREATE_SECURITY_ISSUED_PRE');
3126: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3127: FND_MSG_PUB.ADD;
3120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3124: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3125: 'HZ_ORG_INFO_CRMHK.CREATE_SECURITY_ISSUED_PRE');
3126: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3127: FND_MSG_PUB.ADD;
3128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3124: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3125: 'HZ_ORG_INFO_CRMHK.CREATE_SECURITY_ISSUED_PRE');
3126: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3127: FND_MSG_PUB.ADD;
3128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3129: END IF;
3130:
3148:
3149: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3150: RAISE FND_API.G_EXC_ERROR;
3151: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3152: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3153: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3154: 'HZ_ORG_INFO_CRMHK.CREATE_SECURITY_ISSUED_POST');
3155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3156: FND_MSG_PUB.ADD;
3149: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3150: RAISE FND_API.G_EXC_ERROR;
3151: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3152: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3153: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3154: 'HZ_ORG_INFO_CRMHK.CREATE_SECURITY_ISSUED_POST');
3155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3156: FND_MSG_PUB.ADD;
3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3151: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3152: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3153: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3154: 'HZ_ORG_INFO_CRMHK.CREATE_SECURITY_ISSUED_POST');
3155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3156: FND_MSG_PUB.ADD;
3157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3158: END IF;
3159:
3197: WHEN OTHERS THEN
3198: ROLLBACK TO create_security_issued_pub;
3199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3200:
3201: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3203: FND_MSG_PUB.ADD;
3204:
3205: FND_MSG_PUB.Count_And_Get(
3198: ROLLBACK TO create_security_issued_pub;
3199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3200:
3201: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3203: FND_MSG_PUB.ADD;
3204:
3205: FND_MSG_PUB.Count_And_Get(
3206: p_encoded => FND_API.G_FALSE,
3304:
3305: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3306: RAISE FND_API.G_EXC_ERROR;
3307: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3308: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3309: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3310: 'HZ_ORG_INFO_CRMHK.UPDATE_SECURITY_ISSUED_PRE');
3311: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3312: FND_MSG_PUB.ADD;
3305: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3306: RAISE FND_API.G_EXC_ERROR;
3307: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3308: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3309: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3310: 'HZ_ORG_INFO_CRMHK.UPDATE_SECURITY_ISSUED_PRE');
3311: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3312: FND_MSG_PUB.ADD;
3313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3307: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3308: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3309: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3310: 'HZ_ORG_INFO_CRMHK.UPDATE_SECURITY_ISSUED_PRE');
3311: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3312: FND_MSG_PUB.ADD;
3313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3314: END IF;
3315:
3333:
3334: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3335: RAISE FND_API.G_EXC_ERROR;
3336: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3338: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3339: 'HZ_ORG_INFO_CRMHK.UPDATE_SECURITY_ISSUED_POST');
3340: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3341: FND_MSG_PUB.ADD;
3334: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3335: RAISE FND_API.G_EXC_ERROR;
3336: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3338: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3339: 'HZ_ORG_INFO_CRMHK.UPDATE_SECURITY_ISSUED_POST');
3340: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3341: FND_MSG_PUB.ADD;
3342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3336: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
3338: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3339: 'HZ_ORG_INFO_CRMHK.UPDATE_SECURITY_ISSUED_POST');
3340: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3341: FND_MSG_PUB.ADD;
3342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3343: END IF;
3344:
3382: WHEN OTHERS THEN
3383: ROLLBACK TO update_security_issued_pub;
3384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3385:
3386: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3387: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3388: FND_MSG_PUB.ADD;
3389:
3390: FND_MSG_PUB.Count_And_Get(
3383: ROLLBACK TO update_security_issued_pub;
3384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3385:
3386: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3387: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3388: FND_MSG_PUB.ADD;
3389:
3390: FND_MSG_PUB.Count_And_Get(
3391: p_encoded => FND_API.G_FALSE,
3563: WHEN OTHERS THEN
3564: ROLLBACK TO create_financial_reports_pub;
3565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3566:
3567: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3568: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3569: FND_MSG_PUB.ADD;
3570:
3571: FND_MSG_PUB.Count_And_Get(
3564: ROLLBACK TO create_financial_reports_pub;
3565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3566:
3567: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3568: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3569: FND_MSG_PUB.ADD;
3570:
3571: FND_MSG_PUB.Count_And_Get(
3572: p_encoded => FND_API.G_FALSE,
3753: WHEN OTHERS THEN
3754: ROLLBACK TO update_financial_reports_pub;
3755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3756:
3757: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3758: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3759: FND_MSG_PUB.ADD;
3760:
3761: FND_MSG_PUB.Count_And_Get(
3754: ROLLBACK TO update_financial_reports_pub;
3755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3756:
3757: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3758: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3759: FND_MSG_PUB.ADD;
3760:
3761: FND_MSG_PUB.Count_And_Get(
3762: p_encoded => FND_API.G_FALSE,
3916: WHEN OTHERS THEN
3917: ROLLBACK TO create_financial_numbers_pub;
3918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3919:
3920: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3922: FND_MSG_PUB.ADD;
3923:
3924: FND_MSG_PUB.Count_And_Get(
3917: ROLLBACK TO create_financial_numbers_pub;
3918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3919:
3920: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3922: FND_MSG_PUB.ADD;
3923:
3924: FND_MSG_PUB.Count_And_Get(
3925: p_encoded => FND_API.G_FALSE,
4095: WHEN OTHERS THEN
4096: ROLLBACK TO update_financial_numbers_pub;
4097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4098:
4099: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4101: FND_MSG_PUB.ADD;
4102:
4103: FND_MSG_PUB.Count_And_Get(
4096: ROLLBACK TO update_financial_numbers_pub;
4097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4098:
4099: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4101: FND_MSG_PUB.ADD;
4102:
4103: FND_MSG_PUB.Count_And_Get(
4104: p_encoded => FND_API.G_FALSE,
4187:
4188: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4189: RAISE FND_API.G_EXC_ERROR;
4190: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4191: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4192: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4193: 'HZ_ORG_INFO_CRMHK.CREATE_CERTIFICATIONS_PRE');
4194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4195: FND_MSG_PUB.ADD;
4188: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4189: RAISE FND_API.G_EXC_ERROR;
4190: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4191: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4192: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4193: 'HZ_ORG_INFO_CRMHK.CREATE_CERTIFICATIONS_PRE');
4194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4195: FND_MSG_PUB.ADD;
4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4190: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4191: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4192: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4193: 'HZ_ORG_INFO_CRMHK.CREATE_CERTIFICATIONS_PRE');
4194: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4195: FND_MSG_PUB.ADD;
4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4197: END IF;
4198:
4216:
4217: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4218: RAISE FND_API.G_EXC_ERROR;
4219: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4220: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4221: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4222: 'HZ_ORG_INFO_CRMHK.CREATE_CERTIFICATIONS_POST');
4223: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4224: FND_MSG_PUB.ADD;
4217: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4218: RAISE FND_API.G_EXC_ERROR;
4219: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4220: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4221: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4222: 'HZ_ORG_INFO_CRMHK.CREATE_CERTIFICATIONS_POST');
4223: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4224: FND_MSG_PUB.ADD;
4225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4219: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4220: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4221: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4222: 'HZ_ORG_INFO_CRMHK.CREATE_CERTIFICATIONS_POST');
4223: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4224: FND_MSG_PUB.ADD;
4225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4226: END IF;
4227:
4270: WHEN OTHERS THEN
4271: ROLLBACK TO create_certifications_pub;
4272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4273:
4274: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4276: FND_MSG_PUB.ADD;
4277:
4278: FND_MSG_PUB.Count_And_Get(
4271: ROLLBACK TO create_certifications_pub;
4272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4273:
4274: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4276: FND_MSG_PUB.ADD;
4277:
4278: FND_MSG_PUB.Count_And_Get(
4279: p_encoded => FND_API.G_FALSE,
4377:
4378: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4379: RAISE FND_API.G_EXC_ERROR;
4380: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4381: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4382: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4383: 'HZ_ORG_INFO_CRMHK.UPDATE_CERTIFICATIONS_PRE');
4384: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4385: FND_MSG_PUB.ADD;
4378: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4379: RAISE FND_API.G_EXC_ERROR;
4380: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4381: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4382: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4383: 'HZ_ORG_INFO_CRMHK.UPDATE_CERTIFICATIONS_PRE');
4384: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4385: FND_MSG_PUB.ADD;
4386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4380: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4381: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4382: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4383: 'HZ_ORG_INFO_CRMHK.UPDATE_CERTIFICATIONS_PRE');
4384: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4385: FND_MSG_PUB.ADD;
4386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4387: END IF;
4388:
4406:
4407: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4408: RAISE FND_API.G_EXC_ERROR;
4409: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4410: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4411: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4412: 'HZ_ORG_INFO_CRMHK.UPDATE_CERTIFICATIONS_POST');
4413: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4414: FND_MSG_PUB.ADD;
4407: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4408: RAISE FND_API.G_EXC_ERROR;
4409: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4410: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4411: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4412: 'HZ_ORG_INFO_CRMHK.UPDATE_CERTIFICATIONS_POST');
4413: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4414: FND_MSG_PUB.ADD;
4415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4409: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4410: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4411: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4412: 'HZ_ORG_INFO_CRMHK.UPDATE_CERTIFICATIONS_POST');
4413: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4414: FND_MSG_PUB.ADD;
4415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4416: END IF;
4417:
4461: WHEN OTHERS THEN
4462: ROLLBACK TO update_certifications_pub;
4463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4464:
4465: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4467: FND_MSG_PUB.ADD;
4468:
4469: FND_MSG_PUB.Count_And_Get(
4462: ROLLBACK TO update_certifications_pub;
4463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4464:
4465: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4467: FND_MSG_PUB.ADD;
4468:
4469: FND_MSG_PUB.Count_And_Get(
4470: p_encoded => FND_API.G_FALSE,
4552:
4553: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4554: RAISE FND_API.G_EXC_ERROR;
4555: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4556: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4557: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4558: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_REF_PRE');
4559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4560: FND_MSG_PUB.ADD;
4553: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4554: RAISE FND_API.G_EXC_ERROR;
4555: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4556: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4557: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4558: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_REF_PRE');
4559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4560: FND_MSG_PUB.ADD;
4561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4556: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4557: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4558: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_REF_PRE');
4559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4560: FND_MSG_PUB.ADD;
4561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4562: END IF;
4563:
4581:
4582: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4583: RAISE FND_API.G_EXC_ERROR;
4584: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4585: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4586: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4587: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_REF_POST');
4588: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4589: FND_MSG_PUB.ADD;
4582: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4583: RAISE FND_API.G_EXC_ERROR;
4584: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4585: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4586: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4587: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_REF_POST');
4588: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4589: FND_MSG_PUB.ADD;
4590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4584: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4585: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4586: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4587: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_REF_POST');
4588: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4589: FND_MSG_PUB.ADD;
4590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4591: END IF;
4592:
4624: WHEN OTHERS THEN
4625: ROLLBACK TO create_industrial_ref_pub;
4626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4627:
4628: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4630: FND_MSG_PUB.ADD;
4631:
4632: FND_MSG_PUB.Count_And_Get(
4625: ROLLBACK TO create_industrial_ref_pub;
4626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4627:
4628: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4630: FND_MSG_PUB.ADD;
4631:
4632: FND_MSG_PUB.Count_And_Get(
4633: p_encoded => FND_API.G_FALSE,
4714:
4715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4716: RAISE FND_API.G_EXC_ERROR;
4717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4718: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4719: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4720: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_REF_PRE');
4721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4722: FND_MSG_PUB.ADD;
4715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4716: RAISE FND_API.G_EXC_ERROR;
4717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4718: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4719: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4720: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_REF_PRE');
4721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4722: FND_MSG_PUB.ADD;
4723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4718: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4719: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4720: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_REF_PRE');
4721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4722: FND_MSG_PUB.ADD;
4723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4724: END IF;
4725:
4742:
4743: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4744: RAISE FND_API.G_EXC_ERROR;
4745: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4747: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4748: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_REF_POST');
4749: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4750: FND_MSG_PUB.ADD;
4743: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4744: RAISE FND_API.G_EXC_ERROR;
4745: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4747: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4748: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_REF_POST');
4749: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4750: FND_MSG_PUB.ADD;
4751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4745: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4747: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4748: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_REF_POST');
4749: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4750: FND_MSG_PUB.ADD;
4751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4752: END IF;
4753:
4784: WHEN OTHERS THEN
4785: ROLLBACK TO update_industrial_ref_pub;
4786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4787:
4788: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4789: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4790: FND_MSG_PUB.ADD;
4791:
4792: FND_MSG_PUB.Count_And_Get(
4785: ROLLBACK TO update_industrial_ref_pub;
4786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4787:
4788: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4789: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4790: FND_MSG_PUB.ADD;
4791:
4792: FND_MSG_PUB.Count_And_Get(
4793: p_encoded => FND_API.G_FALSE,
4874:
4875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4876: RAISE FND_API.G_EXC_ERROR;
4877: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4878: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4879: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4880: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_CLASSES_PRE');
4881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4882: FND_MSG_PUB.ADD;
4875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4876: RAISE FND_API.G_EXC_ERROR;
4877: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4878: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4879: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4880: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_CLASSES_PRE');
4881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4882: FND_MSG_PUB.ADD;
4883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4877: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4878: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4879: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4880: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_CLASSES_PRE');
4881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4882: FND_MSG_PUB.ADD;
4883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4884: END IF;
4885:
4902:
4903: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4904: RAISE FND_API.G_EXC_ERROR;
4905: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4906: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4907: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4908: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_CLASSES_POST');
4909: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4910: FND_MSG_PUB.ADD;
4903: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4904: RAISE FND_API.G_EXC_ERROR;
4905: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4906: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4907: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4908: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_CLASSES_POST');
4909: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4910: FND_MSG_PUB.ADD;
4911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4905: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4906: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
4907: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4908: 'HZ_ORG_INFO_CRMHK.CREATE_INDUSTRIAL_CLASSES_POST');
4909: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4910: FND_MSG_PUB.ADD;
4911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4912: END IF;
4913:
4944: WHEN OTHERS THEN
4945: ROLLBACK TO create_industrial_classes_pub;
4946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4947:
4948: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4949: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4950: FND_MSG_PUB.ADD;
4951:
4952: FND_MSG_PUB.Count_And_Get(
4945: ROLLBACK TO create_industrial_classes_pub;
4946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4947:
4948: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4949: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4950: FND_MSG_PUB.ADD;
4951:
4952: FND_MSG_PUB.Count_And_Get(
4953: p_encoded => FND_API.G_FALSE,
5047:
5048: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5049: RAISE FND_API.G_EXC_ERROR;
5050: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5051: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5052: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5053: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_CLASSES_PRE');
5054: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5055: FND_MSG_PUB.ADD;
5048: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5049: RAISE FND_API.G_EXC_ERROR;
5050: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5051: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5052: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5053: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_CLASSES_PRE');
5054: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5055: FND_MSG_PUB.ADD;
5056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5050: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5051: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5052: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5053: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_CLASSES_PRE');
5054: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5055: FND_MSG_PUB.ADD;
5056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5057: END IF;
5058:
5076:
5077: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5078: RAISE FND_API.G_EXC_ERROR;
5079: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5080: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5081: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5082: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_CLASSES_POST');
5083: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5084: FND_MSG_PUB.ADD;
5077: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5078: RAISE FND_API.G_EXC_ERROR;
5079: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5080: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5081: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5082: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_CLASSES_POST');
5083: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5084: FND_MSG_PUB.ADD;
5085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5079: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5080: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5081: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5082: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUSTRIAL_CLASSES_POST');
5083: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5084: FND_MSG_PUB.ADD;
5085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5086: END IF;
5087:
5118: WHEN OTHERS THEN
5119: ROLLBACK TO update_industrial_classes_pub;
5120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5121:
5122: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
5123: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5124: FND_MSG_PUB.ADD;
5125:
5126: FND_MSG_PUB.Count_And_Get(
5119: ROLLBACK TO update_industrial_classes_pub;
5120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5121:
5122: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
5123: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5124: FND_MSG_PUB.ADD;
5125:
5126: FND_MSG_PUB.Count_And_Get(
5127: p_encoded => FND_API.G_FALSE,
5208:
5209: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5210: RAISE FND_API.G_EXC_ERROR;
5211: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5212: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5213: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5214: 'HZ_ORG_INFO_CRMHK.CREATE_INDUS_CLASS_APP_PRE');
5215: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5216: FND_MSG_PUB.ADD;
5209: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5210: RAISE FND_API.G_EXC_ERROR;
5211: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5212: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5213: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5214: 'HZ_ORG_INFO_CRMHK.CREATE_INDUS_CLASS_APP_PRE');
5215: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5216: FND_MSG_PUB.ADD;
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5211: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5212: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5213: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5214: 'HZ_ORG_INFO_CRMHK.CREATE_INDUS_CLASS_APP_PRE');
5215: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5216: FND_MSG_PUB.ADD;
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: END IF;
5219:
5237:
5238: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5239: RAISE FND_API.G_EXC_ERROR;
5240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5241: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5242: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5243: 'HZ_ORG_INFO_CRMHK.CREATE_INDUS_CLASS_APP_POST');
5244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5245: FND_MSG_PUB.ADD;
5238: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5239: RAISE FND_API.G_EXC_ERROR;
5240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5241: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5242: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5243: 'HZ_ORG_INFO_CRMHK.CREATE_INDUS_CLASS_APP_POST');
5244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5245: FND_MSG_PUB.ADD;
5246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5241: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5242: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5243: 'HZ_ORG_INFO_CRMHK.CREATE_INDUS_CLASS_APP_POST');
5244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5245: FND_MSG_PUB.ADD;
5246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5247: END IF;
5248:
5279: WHEN OTHERS THEN
5280: ROLLBACK TO create_indus_class_app_pub;
5281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5282:
5283: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
5284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5285: FND_MSG_PUB.ADD;
5286:
5287: FND_MSG_PUB.Count_And_Get(
5280: ROLLBACK TO create_indus_class_app_pub;
5281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5282:
5283: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
5284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5285: FND_MSG_PUB.ADD;
5286:
5287: FND_MSG_PUB.Count_And_Get(
5288: p_encoded => FND_API.G_FALSE,
5369:
5370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5371: RAISE FND_API.G_EXC_ERROR;
5372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5374: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5375: 'HZ_ORG_INFO_CRMHK.CREATE_INDUS_CLASS_APP_PRE');
5376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5377: FND_MSG_PUB.ADD;
5370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5371: RAISE FND_API.G_EXC_ERROR;
5372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5374: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5375: 'HZ_ORG_INFO_CRMHK.CREATE_INDUS_CLASS_APP_PRE');
5376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5377: FND_MSG_PUB.ADD;
5378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5374: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5375: 'HZ_ORG_INFO_CRMHK.CREATE_INDUS_CLASS_APP_PRE');
5376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5377: FND_MSG_PUB.ADD;
5378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5379: END IF;
5380:
5398:
5399: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5400: RAISE FND_API.G_EXC_ERROR;
5401: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5402: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5403: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5404: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUS_CLASS_APP_POST');
5405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5406: FND_MSG_PUB.ADD;
5399: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5400: RAISE FND_API.G_EXC_ERROR;
5401: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5402: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5403: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5404: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUS_CLASS_APP_POST');
5405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5406: FND_MSG_PUB.ADD;
5407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5401: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5402: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
5403: FND_MESSAGE.SET_TOKEN('PROCEDURE',
5404: 'HZ_ORG_INFO_CRMHK.UPDATE_INDUS_CLASS_APP_POST');
5405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5406: FND_MSG_PUB.ADD;
5407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5408: END IF;
5409:
5440: WHEN OTHERS THEN
5441: ROLLBACK TO update_indus_class_app_pub;
5442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5443:
5444: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
5445: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5446: FND_MSG_PUB.ADD;
5447:
5448: FND_MSG_PUB.Count_And_Get(
5441: ROLLBACK TO update_indus_class_app_pub;
5442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5443:
5444: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
5445: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5446: FND_MSG_PUB.ADD;
5447:
5448: FND_MSG_PUB.Count_And_Get(
5449: p_encoded => FND_API.G_FALSE,
5488: --Check whether primary key has been passed in.
5489: IF p_financial_report_id IS NULL OR
5490: p_financial_report_id = FND_API.G_MISS_NUM THEN
5491:
5492: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
5493: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');
5494: FND_MSG_PUB.ADD;
5495: RAISE FND_API.G_EXC_ERROR;
5496: END IF;
5489: IF p_financial_report_id IS NULL OR
5490: p_financial_report_id = FND_API.G_MISS_NUM THEN
5491:
5492: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
5493: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');
5494: FND_MSG_PUB.ADD;
5495: RAISE FND_API.G_EXC_ERROR;
5496: END IF;
5497:
5556: WHERE financial_report_id = p_financial_report_id;
5557:
5558: EXCEPTION
5559: WHEN NO_DATA_FOUND THEN
5560: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
5561: FND_MESSAGE.SET_TOKEN('RECORD', 'financial report');
5562: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_financial_report_id));
5563: FND_MSG_PUB.ADD;
5564: RAISE FND_API.G_EXC_ERROR;
5557:
5558: EXCEPTION
5559: WHEN NO_DATA_FOUND THEN
5560: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
5561: FND_MESSAGE.SET_TOKEN('RECORD', 'financial report');
5562: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_financial_report_id));
5563: FND_MSG_PUB.ADD;
5564: RAISE FND_API.G_EXC_ERROR;
5565: END;
5558: EXCEPTION
5559: WHEN NO_DATA_FOUND THEN
5560: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
5561: FND_MESSAGE.SET_TOKEN('RECORD', 'financial report');
5562: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_financial_report_id));
5563: FND_MSG_PUB.ADD;
5564: RAISE FND_API.G_EXC_ERROR;
5565: END;
5566: --Standard call to get message count and if count is 1, get message info.
5585: p_data => x_msg_data);
5586: WHEN OTHERS THEN
5587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5588:
5589: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
5590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5591: FND_MSG_PUB.ADD;
5592:
5593: FND_MSG_PUB.Count_And_Get(
5586: WHEN OTHERS THEN
5587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5588:
5589: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
5590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5591: FND_MSG_PUB.ADD;
5592:
5593: FND_MSG_PUB.Count_And_Get(
5594: p_encoded => FND_API.G_FALSE,
5633: --Check whether primary key has been passed in.
5634: IF p_financial_number_id IS NULL OR
5635: p_financial_number_id = FND_API.G_MISS_NUM THEN
5636:
5637: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
5638: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_number_id');
5639: FND_MSG_PUB.ADD;
5640: RAISE FND_API.G_EXC_ERROR;
5641: END IF;
5634: IF p_financial_number_id IS NULL OR
5635: p_financial_number_id = FND_API.G_MISS_NUM THEN
5636:
5637: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
5638: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_number_id');
5639: FND_MSG_PUB.ADD;
5640: RAISE FND_API.G_EXC_ERROR;
5641: END IF;
5642:
5668: WHERE financial_number_id = p_financial_number_id;
5669:
5670: EXCEPTION
5671: WHEN NO_DATA_FOUND THEN
5672: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
5673: FND_MESSAGE.SET_TOKEN('RECORD', 'credit rating');
5674: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_financial_number_id));
5675: FND_MSG_PUB.ADD;
5676: RAISE FND_API.G_EXC_ERROR;
5669:
5670: EXCEPTION
5671: WHEN NO_DATA_FOUND THEN
5672: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
5673: FND_MESSAGE.SET_TOKEN('RECORD', 'credit rating');
5674: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_financial_number_id));
5675: FND_MSG_PUB.ADD;
5676: RAISE FND_API.G_EXC_ERROR;
5677: END;
5670: EXCEPTION
5671: WHEN NO_DATA_FOUND THEN
5672: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
5673: FND_MESSAGE.SET_TOKEN('RECORD', 'credit rating');
5674: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_financial_number_id));
5675: FND_MSG_PUB.ADD;
5676: RAISE FND_API.G_EXC_ERROR;
5677: END;
5678: --Standard call to get message count and if count is 1, get message info.
5697: p_data => x_msg_data);
5698: WHEN OTHERS THEN
5699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5700:
5701: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
5702: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5703: FND_MSG_PUB.ADD;
5704:
5705: FND_MSG_PUB.Count_And_Get(
5698: WHEN OTHERS THEN
5699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5700:
5701: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
5702: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5703: FND_MSG_PUB.ADD;
5704:
5705: FND_MSG_PUB.Count_And_Get(
5706: p_encoded => FND_API.G_FALSE,