APPS.PA_BILLING_SCHEDULE_PVT dependencies on PA_UTILS

Line 141: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

137: x_return_status => l_return_status );
138:
139: IF l_return_status = FND_API.G_RET_STS_ERROR
140: THEN
141: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
142: p_msg_name => l_error_msg_code);
143:
144: x_msg_data := l_error_msg_code;
145: x_return_status := 'E';

Line 166: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

162: AND record_version_number = p_record_version_number
163: FOR UPDATE OF record_version_number NOWAIT;
164: EXCEPTION
165: WHEN TIMEOUT_ON_RESOURCE THEN
166: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
167: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
168: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
169: x_return_status := 'E' ;
170: WHEN NO_DATA_FOUND THEN

Line 172: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

168: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
169: x_return_status := 'E' ;
170: WHEN NO_DATA_FOUND THEN
171: if p_calling_module = 'FORM' then
172: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
173: p_msg_name => 'FORM_RECORD_CHANGED');
174: x_msg_data := 'FORM_RECORD_CHANGED';
175: else
176: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 176: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

172: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
173: p_msg_name => 'FORM_RECORD_CHANGED');
174: x_msg_data := 'FORM_RECORD_CHANGED';
175: else
176: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
177: p_msg_name => 'PA_XC_RECORD_CHANGED');
178: x_msg_data := 'PA_XC_RECORD_CHANGED';
179: end if;
180: x_return_status := 'E' ;

Line 183: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

179: end if;
180: x_return_status := 'E' ;
181: WHEN OTHERS THEN
182: IF SQLCODE = -54 THEN
183: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
184: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
185: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
186: x_return_status := 'E' ;
187: ELSE

Line 200: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

196: AND record_version_number = p_record_version_number;
197: EXCEPTION
198: WHEN NO_DATA_FOUND THEN
199: if p_calling_module = 'FORM' then
200: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
201: p_msg_name => 'FORM_RECORD_CHANGED');
202: x_msg_data := 'FORM_RECORD_CHANGED';
203: else
204: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 204: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

200: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
201: p_msg_name => 'FORM_RECORD_CHANGED');
202: x_msg_data := 'FORM_RECORD_CHANGED';
203: else
204: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
205: p_msg_name => 'PA_XC_RECORD_CHANGED');
206: x_msg_data := 'PA_XC_RECORD_CHANGED';
207: end if;
208: x_return_status := 'E' ;

Line 211: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

207: end if;
208: x_return_status := 'E' ;
209: WHEN OTHERS THEN
210: IF SQLCODE = -54 THEN
211: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
212: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
213: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
214: x_return_status := 'E' ;
215: END IF;

Line 368: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

364: AND record_version_number = p_record_version_number
365: FOR UPDATE OF record_version_number NOWAIT;
366: EXCEPTION
367: WHEN TIMEOUT_ON_RESOURCE THEN
368: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
369: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
370: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
371: x_return_status := 'E' ;
372: WHEN NO_DATA_FOUND THEN

Line 374: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

370: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
371: x_return_status := 'E' ;
372: WHEN NO_DATA_FOUND THEN
373: if p_calling_module = 'FORM' then
374: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
375: p_msg_name => 'FORM_RECORD_CHANGED');
376: x_msg_data := 'FORM_RECORD_CHANGED';
377: else
378: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 378: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

374: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
375: p_msg_name => 'FORM_RECORD_CHANGED');
376: x_msg_data := 'FORM_RECORD_CHANGED';
377: else
378: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
379: p_msg_name => 'PA_XC_RECORD_CHANGED');
380: x_msg_data := 'PA_XC_RECORD_CHANGED';
381: end if;
382: x_return_status := 'E' ;

Line 385: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

381: end if;
382: x_return_status := 'E' ;
383: WHEN OTHERS THEN
384: IF SQLCODE = -54 THEN
385: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
386: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
387: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
388: x_return_status := 'E' ;
389: ELSE

Line 402: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

398: AND record_version_number = p_record_version_number;
399: EXCEPTION
400: WHEN NO_DATA_FOUND THEN
401: if p_calling_module = 'FORM' then
402: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
403: p_msg_name => 'FORM_RECORD_CHANGED');
404: x_msg_data := 'FORM_RECORD_CHANGED';
405: else
406: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 406: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

402: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
403: p_msg_name => 'FORM_RECORD_CHANGED');
404: x_msg_data := 'FORM_RECORD_CHANGED';
405: else
406: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
407: p_msg_name => 'PA_XC_RECORD_CHANGED');
408: x_msg_data := 'PA_XC_RECORD_CHANGED';
409: end if;
410: x_return_status := 'E' ;

Line 413: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

409: end if;
410: x_return_status := 'E' ;
411: WHEN OTHERS THEN
412: IF SQLCODE = -54 THEN
413: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
414: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
415: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
416: x_return_status := 'E' ;
417: END IF;

Line 570: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

566: AND record_version_number = p_record_version_number
567: FOR UPDATE OF record_version_number NOWAIT;
568: EXCEPTION
569: WHEN TIMEOUT_ON_RESOURCE THEN
570: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
571: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
572: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
573: x_return_status := 'E' ;
574: WHEN NO_DATA_FOUND THEN

Line 576: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

572: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
573: x_return_status := 'E' ;
574: WHEN NO_DATA_FOUND THEN
575: if p_calling_module = 'FORM' then
576: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
577: p_msg_name => 'FORM_RECORD_CHANGED');
578: x_msg_data := 'FORM_RECORD_CHANGED';
579: else
580: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 580: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

576: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
577: p_msg_name => 'FORM_RECORD_CHANGED');
578: x_msg_data := 'FORM_RECORD_CHANGED';
579: else
580: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
581: p_msg_name => 'PA_XC_RECORD_CHANGED');
582: x_msg_data := 'PA_XC_RECORD_CHANGED';
583: end if;
584: x_return_status := 'E' ;

Line 587: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

583: end if;
584: x_return_status := 'E' ;
585: WHEN OTHERS THEN
586: IF SQLCODE = -54 THEN
587: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
588: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
589: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
590: x_return_status := 'E' ;
591: ELSE

Line 604: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

600: AND record_version_number = p_record_version_number;
601: EXCEPTION
602: WHEN NO_DATA_FOUND THEN
603: if p_calling_module = 'FORM' then
604: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
605: p_msg_name => 'FORM_RECORD_CHANGED');
606: x_msg_data := 'FORM_RECORD_CHANGED';
607: else
608: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 608: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

604: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
605: p_msg_name => 'FORM_RECORD_CHANGED');
606: x_msg_data := 'FORM_RECORD_CHANGED';
607: else
608: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
609: p_msg_name => 'PA_XC_RECORD_CHANGED');
610: x_msg_data := 'PA_XC_RECORD_CHANGED';
611: end if;
612: x_return_status := 'E' ;

Line 615: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

611: end if;
612: x_return_status := 'E' ;
613: WHEN OTHERS THEN
614: IF SQLCODE = -54 THEN
615: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
616: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
617: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
618: x_return_status := 'E' ;
619: END IF;

Line 634: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

630: AND record_version_number = p_record_version_number
631: FOR UPDATE OF record_version_number NOWAIT;
632: EXCEPTION
633: WHEN TIMEOUT_ON_RESOURCE THEN
634: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
635: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
636: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
637: x_return_status := 'E' ;
638: WHEN NO_DATA_FOUND THEN

Line 640: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

636: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
637: x_return_status := 'E' ;
638: WHEN NO_DATA_FOUND THEN
639: if p_calling_module = 'FORM' then
640: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
641: p_msg_name => 'FORM_RECORD_CHANGED');
642: x_msg_data := 'FORM_RECORD_CHANGED';
643: else
644: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 644: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

640: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
641: p_msg_name => 'FORM_RECORD_CHANGED');
642: x_msg_data := 'FORM_RECORD_CHANGED';
643: else
644: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
645: p_msg_name => 'PA_XC_RECORD_CHANGED');
646: x_msg_data := 'PA_XC_RECORD_CHANGED';
647: end if;
648: x_return_status := 'E' ;

Line 651: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

647: end if;
648: x_return_status := 'E' ;
649: WHEN OTHERS THEN
650: IF SQLCODE = -54 THEN
651: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
652: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
653: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
654: x_return_status := 'E' ;
655: ELSE

Line 668: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

664: AND record_version_number = p_record_version_number;
665: EXCEPTION
666: WHEN NO_DATA_FOUND THEN
667: if p_calling_module = 'FORM' then
668: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
669: p_msg_name => 'FORM_RECORD_CHANGED');
670: x_msg_data := 'FORM_RECORD_CHANGED';
671: else
672: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 672: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

668: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
669: p_msg_name => 'FORM_RECORD_CHANGED');
670: x_msg_data := 'FORM_RECORD_CHANGED';
671: else
672: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
673: p_msg_name => 'PA_XC_RECORD_CHANGED');
674: x_msg_data := 'PA_XC_RECORD_CHANGED';
675: end if;
676: x_return_status := 'E' ;

Line 679: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

675: end if;
676: x_return_status := 'E' ;
677: WHEN OTHERS THEN
678: IF SQLCODE = -54 THEN
679: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
680: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
681: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
682: x_return_status := 'E' ;
683: END IF;

Line 922: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

918: END IF;
919:
920: IF p_labor_multiplier < 0
921: THEN
922: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
923: p_msg_name => 'PA_PRJ_LB_MULT_GR_ZR' );
924: x_msg_count := FND_MSG_PUB.count_msg;
925: x_msg_data := 'PA_PRJ_LB_MULT_GR_ZR';
926: x_return_status := 'E';

Line 939: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

935: x_return_status => l_return_status );
936:
937: IF l_return_status = FND_API.G_RET_STS_ERROR
938: THEN
939: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
940: p_msg_name => l_error_msg_code);
941: x_msg_data := l_error_msg_code;
942: x_return_status := 'E';
943: RAISE FND_API.G_EXC_ERROR;

Line 954: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

950: x_return_status => l_return_status );
951:
952: IF l_return_status = FND_API.G_RET_STS_ERROR
953: THEN
954: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
955: p_msg_name => l_error_msg_code);
956: x_msg_data := l_error_msg_code;
957: x_return_status := 'E';
958: RAISE FND_API.G_EXC_ERROR;

Line 1004: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1000: );
1001:
1002:
1003: ELSE
1004: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1005: p_msg_name => 'PA_PRJ_DATE_OVERLAP' );
1006: x_msg_data := 'PA_PRJ_DATE_OVERLAP';
1007: x_return_status := 'E';
1008: RAISE FND_API.G_EXC_ERROR;

Line 1127: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1123: END IF;
1124:
1125: IF p_labor_multiplier < 0
1126: THEN
1127: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1128: p_msg_name => 'PA_PRJ_LB_MULT_GR_ZR' );
1129: x_msg_count := FND_MSG_PUB.count_msg;
1130: x_msg_data := 'PA_PRJ_LB_MULT_GR_ZR';
1131: x_return_status := 'E';

Line 1145: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1141: x_return_status => l_return_status );
1142:
1143: IF l_return_status = FND_API.G_RET_STS_ERROR
1144: THEN
1145: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1146: p_msg_name => l_error_msg_code);
1147: x_msg_data := l_error_msg_code;
1148: x_return_status := 'E';
1149: RAISE FND_API.G_EXC_ERROR;

Line 1161: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1157: x_return_status => l_return_status );
1158:
1159: IF l_return_status = FND_API.G_RET_STS_ERROR
1160: THEN
1161: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1162: p_msg_name => l_error_msg_code);
1163: x_msg_data := l_error_msg_code;
1164: x_return_status := 'E';
1165: RAISE FND_API.G_EXC_ERROR;

Line 1184: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1180: AND record_version_number = p_record_version_number
1181: FOR UPDATE OF record_version_number NOWAIT;
1182: EXCEPTION
1183: WHEN TIMEOUT_ON_RESOURCE THEN
1184: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1185: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1186: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1187: x_return_status := 'E' ;
1188: WHEN NO_DATA_FOUND THEN

Line 1190: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

1186: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1187: x_return_status := 'E' ;
1188: WHEN NO_DATA_FOUND THEN
1189: if p_calling_module = 'FORM' then
1190: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1191: p_msg_name => 'FORM_RECORD_CHANGED');
1192: x_msg_data := 'FORM_RECORD_CHANGED';
1193: else
1194: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 1194: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1190: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1191: p_msg_name => 'FORM_RECORD_CHANGED');
1192: x_msg_data := 'FORM_RECORD_CHANGED';
1193: else
1194: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1195: p_msg_name => 'PA_XC_RECORD_CHANGED');
1196: x_msg_data := 'PA_XC_RECORD_CHANGED';
1197: end if;
1198: x_return_status := 'E' ;

Line 1201: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1197: end if;
1198: x_return_status := 'E' ;
1199: WHEN OTHERS THEN
1200: IF SQLCODE = -54 THEN
1201: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1202: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1203: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1204: x_return_status := 'E' ;
1205: ELSE

Line 1218: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

1214: AND record_version_number = p_record_version_number;
1215: EXCEPTION
1216: WHEN NO_DATA_FOUND THEN
1217: if p_calling_module = 'FORM' then
1218: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1219: p_msg_name => 'FORM_RECORD_CHANGED');
1220: x_msg_data := 'FORM_RECORD_CHANGED';
1221: else
1222: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 1222: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1218: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1219: p_msg_name => 'FORM_RECORD_CHANGED');
1220: x_msg_data := 'FORM_RECORD_CHANGED';
1221: else
1222: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1223: p_msg_name => 'PA_XC_RECORD_CHANGED');
1224: x_msg_data := 'PA_XC_RECORD_CHANGED';
1225: end if;
1226: x_return_status := 'E' ;

Line 1229: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1225: end if;
1226: x_return_status := 'E' ;
1227: WHEN OTHERS THEN
1228: IF SQLCODE = -54 THEN
1229: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1230: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1231: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1232: x_return_status := 'E' ;
1233: END IF;

Line 1264: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1260: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
1261: WHERE labor_multiplier_id = p_labor_multiplier_id
1262: AND RECORD_VERSION_NUMBER = p_RECORD_VERSION_NUMBER;
1263: ELSE
1264: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1265: p_msg_name => 'PA_PRJ_DATE_OVERLAP' );
1266: x_msg_data := 'PA_PRJ_DATE_OVERLAP';
1267: x_return_status := 'E';
1268: RAISE FND_API.G_EXC_ERROR;

Line 1390: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1386: AND record_version_number = p_record_version_number
1387: FOR UPDATE OF record_version_number NOWAIT;
1388: EXCEPTION
1389: WHEN TIMEOUT_ON_RESOURCE THEN
1390: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1391: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1392: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1393: x_return_status := 'E' ;
1394: WHEN NO_DATA_FOUND THEN

Line 1396: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

1392: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1393: x_return_status := 'E' ;
1394: WHEN NO_DATA_FOUND THEN
1395: if p_calling_module = 'FORM' then
1396: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1397: p_msg_name => 'FORM_RECORD_CHANGED');
1398: x_msg_data := 'FORM_RECORD_CHANGED';
1399: else
1400: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 1400: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1396: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1397: p_msg_name => 'FORM_RECORD_CHANGED');
1398: x_msg_data := 'FORM_RECORD_CHANGED';
1399: else
1400: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1401: p_msg_name => 'PA_XC_RECORD_CHANGED');
1402: x_msg_data := 'PA_XC_RECORD_CHANGED';
1403: end if;
1404: x_return_status := 'E' ;

Line 1407: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1403: end if;
1404: x_return_status := 'E' ;
1405: WHEN OTHERS THEN
1406: IF SQLCODE = -54 THEN
1407: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1408: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1409: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1410: x_return_status := 'E' ;
1411: ELSE

Line 1424: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

1420: AND record_version_number = p_record_version_number;
1421: EXCEPTION
1422: WHEN NO_DATA_FOUND THEN
1423: if p_calling_module = 'FORM' then
1424: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1425: p_msg_name => 'FORM_RECORD_CHANGED');
1426: x_msg_data := 'FORM_RECORD_CHANGED';
1427: else
1428: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 1428: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1424: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1425: p_msg_name => 'FORM_RECORD_CHANGED');
1426: x_msg_data := 'FORM_RECORD_CHANGED';
1427: else
1428: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1429: p_msg_name => 'PA_XC_RECORD_CHANGED');
1430: x_msg_data := 'PA_XC_RECORD_CHANGED';
1431: end if;
1432: x_return_status := 'E' ;

Line 1435: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1431: end if;
1432: x_return_status := 'E' ;
1433: WHEN OTHERS THEN
1434: IF SQLCODE = -54 THEN
1435: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1436: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1437: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1438: x_return_status := 'E' ;
1439: END IF;