DBA Data[Home] [Help]

APPS.GME_BATCHSTEP_ACT_PVT dependencies on GME_COMMON_PVT

Line 71: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

67: x_return_status := fnd_api.g_ret_sts_success;
68:
69: IF p_org_code IS NULL
70: THEN
71: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
72: 'FIELD_NAME',
73: 'ORGANIZATION'
74: );
75: RAISE fnd_api.g_exc_error;

Line 78: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

74: );
75: RAISE fnd_api.g_exc_error;
76: ELSIF p_batch_no IS NULL
77: THEN
78: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
79: 'FIELD_NAME',
80: 'BATCH NUMBER'
81: );
82: RAISE fnd_api.g_exc_error;

Line 85: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

81: );
82: RAISE fnd_api.g_exc_error;
83: ELSIF p_batchstep_no IS NULL
84: THEN
85: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
86: 'FIELD_NAME',
87: 'BATCH STEP NUMBER'
88: );
89: RAISE fnd_api.g_exc_error;

Line 93: OPEN cur_get_batch_dtl (gme_common_pvt.g_organization_id, p_batch_no);

89: RAISE fnd_api.g_exc_error;
90: END IF;
91:
92: -- Validate input param one by one to see if it identifies an activity correctly
93: OPEN cur_get_batch_dtl (gme_common_pvt.g_organization_id, p_batch_no);
94: FETCH cur_get_batch_dtl INTO x_batch_id, x_batch_status;
95:
96: IF cur_get_batch_dtl%NOTFOUND
97: THEN

Line 99: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');

95:
96: IF cur_get_batch_dtl%NOTFOUND
97: THEN
98: CLOSE cur_get_batch_dtl;
99: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');
100: RAISE fnd_api.g_exc_error;
101: END IF;
102:
103: CLOSE cur_get_batch_dtl;

Line 111: gme_common_pvt.log_message ('PC_INV_BATCHSTEP_NO');

107:
108: IF cur_get_batchstep_dtl%NOTFOUND
109: THEN
110: CLOSE cur_get_batchstep_dtl;
111: gme_common_pvt.log_message ('PC_INV_BATCHSTEP_NO');
112: RAISE fnd_api.g_exc_error;
113: END IF;
114:
115: CLOSE cur_get_batchstep_dtl;

Line 126: gme_common_pvt.log_message ('GME_STEP_ACTIVITY_NOT_FOUND',

122:
123: IF cur_get_activity_id%NOTFOUND
124: THEN
125: CLOSE cur_get_activity_id;
126: gme_common_pvt.log_message ('GME_STEP_ACTIVITY_NOT_FOUND',
127: 'ACTIVITY',
128: p_activity,
129: 'STEP_NO',
130: p_batchstep_no

Line 259: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_INS');

255:
256: IF l_batch_type = 10
257: THEN
258: CLOSE cur_check_fpo;
259: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_INS');
260: RAISE fnd_api.g_exc_error;
261: END IF;
262:
263: CLOSE cur_check_fpo;

Line 271: gme_common_pvt.log_message ('GME_BAD_ACTIVITY');

267:
268: IF cur_check_activity%NOTFOUND
269: THEN
270: CLOSE cur_check_activity;
271: gme_common_pvt.log_message ('GME_BAD_ACTIVITY');
272: RAISE fnd_api.g_exc_error;
273: END IF;
274:
275: CLOSE cur_check_activity;

Line 283: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND',

279:
280: IF cur_get_step_dtl%NOTFOUND
281: THEN
282: CLOSE cur_get_step_dtl;
283: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND',
284: 'STEP_ID',
285: p_step_id
286: );
287: RAISE fnd_api.g_exc_error;

Line 294: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');

290: CLOSE cur_get_step_dtl;
291:
292: IF l_step_dtl.step_status IN (4, 5)
293: THEN -- Closed or cancelled step
294: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
295: RAISE fnd_api.g_exc_error;
296: END IF;
297:
298: -- check ASQC property - can't insert into WIP step for ASQC batch

Line 305: gme_common_pvt.log_message ('GME_INVALID_ASQC_ACTION_ACTV');

301: CLOSE cur_get_batch_asqc;
302:
303: IF l_batch_asqc = 1 AND l_step_dtl.step_status = 2
304: THEN
305: gme_common_pvt.log_message ('GME_INVALID_ASQC_ACTION_ACTV');
306: RAISE fnd_api.g_exc_error;
307: END IF;
308:
309: -- check plan activity factor

Line 313: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

309: -- check plan activity factor
310: IF l_step_dtl.step_status = 1
311: AND p_batchstep_activity_rec.plan_activity_factor IS NULL
312: THEN
313: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
314: 'FIELD_NAME',
315: 'PLAN_ACTIVITY_FACTOR'
316: );
317: RAISE fnd_api.g_exc_error;

Line 324: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

320: -- check actual activity factor
321: IF l_step_dtl.step_status IN (2, 3)
322: AND p_batchstep_activity_rec.actual_activity_factor IS NULL
323: THEN
324: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
325: 'FIELD_NAME',
326: 'ACTUAL_ACTIVITY_FACTOR'
327: );
328: RAISE fnd_api.g_exc_error;

Line 352: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',

348: OR p_batchstep_activity_rec.plan_start_date >
349: l_step_dtl.plan_cmplt_date
350: )
351: THEN
352: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
353: 'ACTIVITY',
354: p_batchstep_activity_rec.activity
355: );
356: RAISE fnd_api.g_exc_error;

Line 365: gme_common_pvt.log_message ('PM_BADSTARTDATE');

361: AND (p_batchstep_activity_rec.plan_start_date >
362: p_batchstep_activity_rec.plan_cmplt_date
363: )
364: THEN
365: gme_common_pvt.log_message ('PM_BADSTARTDATE');
366: RAISE fnd_api.g_exc_error;
367: END IF;
368:
369: IF p_batchstep_activity_rec.plan_cmplt_date IS NOT NULL

Line 374: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',

370: AND (p_batchstep_activity_rec.plan_cmplt_date >
371: l_step_dtl.plan_cmplt_date
372: )
373: THEN
374: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
375: 'ACTIVITY',
376: p_batchstep_activity_rec.activity
377: );
378: RAISE fnd_api.g_exc_error;

Line 404: gme_common_pvt.g_timestamp

400: THEN
401: -- Check that actual start date is not in the future
402: IF p_batchstep_activity_rec.actual_start_date IS NOT NULL
403: AND p_batchstep_activity_rec.actual_start_date >
404: gme_common_pvt.g_timestamp
405: THEN
406: gme_common_pvt.log_message (p_message_code => 'SY_NOFUTUREDATE',
407: p_product_code => 'GMA'
408: );

Line 406: gme_common_pvt.log_message (p_message_code => 'SY_NOFUTUREDATE',

402: IF p_batchstep_activity_rec.actual_start_date IS NOT NULL
403: AND p_batchstep_activity_rec.actual_start_date >
404: gme_common_pvt.g_timestamp
405: THEN
406: gme_common_pvt.log_message (p_message_code => 'SY_NOFUTUREDATE',
407: p_product_code => 'GMA'
408: );
409: RAISE fnd_api.g_exc_error;
410: END IF;

Line 420: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',

416: OR p_batchstep_activity_rec.actual_start_date >
417: l_step_dtl.actual_cmplt_date
418: )
419: THEN
420: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
421: 'ACTIVITY',
422: p_batchstep_activity_rec.activity
423: );
424: RAISE fnd_api.g_exc_error;

Line 442: gme_common_pvt.g_timestamp

438: THEN
439: -- Check that actual cmplt date is not in the future
440: IF p_batchstep_activity_rec.actual_cmplt_date IS NOT NULL
441: AND p_batchstep_activity_rec.actual_cmplt_date >
442: gme_common_pvt.g_timestamp
443: THEN
444: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
445: fnd_msg_pub.ADD;
446: RAISE fnd_api.g_exc_error;

Line 455: gme_common_pvt.log_message ('PM_BADSTARTDATE');

451: AND (p_batchstep_activity_rec.actual_start_date >
452: p_batchstep_activity_rec.actual_cmplt_date
453: )
454: THEN
455: gme_common_pvt.log_message ('PM_BADSTARTDATE');
456: RAISE fnd_api.g_exc_error;
457: END IF;
458:
459: IF p_batchstep_activity_rec.actual_cmplt_date IS NOT NULL

Line 463: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',

459: IF p_batchstep_activity_rec.actual_cmplt_date IS NOT NULL
460: AND p_batchstep_activity_rec.actual_cmplt_date >
461: l_step_dtl.actual_cmplt_date
462: THEN
463: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
464: 'ACTIVITY',
465: p_batchstep_activity_rec.activity
466: );
467: RAISE fnd_api.g_exc_error;

Line 493: gme_common_pvt.log_message ('GME_ZERO_ACT_FACT');

489: END IF;
490:
491: IF l_activity_factor = 0
492: THEN
493: gme_common_pvt.log_message ('GME_ZERO_ACT_FACT');
494: RAISE fnd_api.g_exc_error;
495: END IF;
496:
497: --{

Line 722: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

718: x_return_status := fnd_api.g_ret_sts_success;
719:
720: IF p_batchstep_activity_rec.activity IS NULL
721: THEN
722: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
723: 'FIELD_NAME',
724: 'ACTIVITY'
725: );
726: RAISE fnd_api.g_exc_error;

Line 739: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND',

735:
736: IF cur_validate_step%NOTFOUND
737: THEN
738: CLOSE cur_validate_step;
739: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND',
740: 'STEP_ID',
741: l_batchstep_id
742: );
743: RAISE fnd_api.g_exc_error;

Line 819: gme_common_pvt.log_message (p_message_code => 'GME_RESOURCE_NOT_ATTACH',

815:
816: -- check that there are resources and that there is one (and only one) primary resource
817: IF p_batchstep_resource_tbl.COUNT = 0
818: THEN
819: gme_common_pvt.log_message (p_message_code => 'GME_RESOURCE_NOT_ATTACH',
820: p_token1_name => 'ACTIVITY',
821: p_token1_value => p_batchstep_activity_rec.activity,
822: p_token2_name => 'STEPNO',
823: p_token2_value => p_batchstep_no

Line 882: gme_common_pvt.log_message ('GME_ONLY_ONE_PRIM_RSRC',

878: END LOOP;
879:
880: IF l_prim_rsrc_count <> 1
881: THEN
882: gme_common_pvt.log_message ('GME_ONLY_ONE_PRIM_RSRC',
883: 'ACTIVITY',
884: l_batchstep_activity_rec.activity,
885: 'STEPNO',
886: p_batchstep_no

Line 1111: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1107: IF ( p_batchstep_activity_rec.activity IS NULL
1108: AND p_batchstep_activity_rec.batchstep_activity_id IS NULL
1109: )
1110: THEN
1111: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1112: 'FIELD_NAME',
1113: 'ACTIVITY'
1114: );
1115: RAISE fnd_api.g_exc_error;

Line 1129: gme_common_pvt.log_message ('GME_ACTID_NOT_FOUND');

1125:
1126: IF cur_get_dtl%NOTFOUND
1127: THEN
1128: CLOSE cur_get_dtl;
1129: gme_common_pvt.log_message ('GME_ACTID_NOT_FOUND');
1130: RAISE fnd_api.g_exc_error;
1131: END IF;
1132:
1133: CLOSE cur_get_dtl;

Line 1176: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_EDIT');

1172:
1173: IF l_batch_type = 10
1174: THEN
1175: CLOSE cur_check_fpo;
1176: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_EDIT');
1177: RAISE fnd_api.g_exc_error;
1178: END IF;
1179:
1180: CLOSE cur_check_fpo;

Line 1202: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');

1198: l_seq_dep_ind := l_batchstep_activity_rec.sequence_dependent_ind;
1199:
1200: IF l_step_status IN (4, 5)
1201: THEN
1202: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
1203: RAISE fnd_api.g_exc_error;
1204: END IF;
1205:
1206: IF p_batchstep_activity_rec.offset_interval = fnd_api.g_miss_num

Line 1208: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1204: END IF;
1205:
1206: IF p_batchstep_activity_rec.offset_interval = fnd_api.g_miss_num
1207: THEN
1208: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1209: 'FIELD_NAME',
1210: 'offset_interval'
1211: );
1212: RAISE fnd_api.g_exc_error;

Line 1232: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1228: IF l_step_status IN (1, 2)
1229: THEN
1230: IF p_batchstep_activity_rec.plan_start_date = fnd_api.g_miss_date
1231: THEN
1232: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1233: 'FIELD_NAME',
1234: 'plan_start_date'
1235: );
1236: RAISE fnd_api.g_exc_error;

Line 1248: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',

1244: l_step_dtl.plan_start_date
1245: OR p_batchstep_activity_rec.plan_start_date >
1246: l_step_dtl.plan_cmplt_date
1247: THEN
1248: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
1249: 'ACTIVITY',
1250: l_activity
1251: );
1252: RAISE fnd_api.g_exc_error;

Line 1263: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1259: END IF;
1260:
1261: IF p_batchstep_activity_rec.plan_cmplt_date = fnd_api.g_miss_date
1262: THEN
1263: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1264: 'FIELD_NAME',
1265: 'plan_cmplt_date'
1266: );
1267: RAISE fnd_api.g_exc_error;

Line 1277: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',

1273: -- Check that the activity plan dates fall within the step dates.
1274: IF p_batchstep_activity_rec.plan_cmplt_date >
1275: l_step_dtl.plan_cmplt_date
1276: THEN
1277: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
1278: 'ACTIVITY',
1279: l_activity
1280: );
1281: RAISE fnd_api.g_exc_error;

Line 1295: gme_common_pvt.log_message ('PM_BADSTARTDATE');

1291: AND l_batchstep_activity_rec.plan_start_date >
1292: l_batchstep_activity_rec.plan_cmplt_date
1293: )
1294: THEN
1295: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1296: RAISE fnd_api.g_exc_error;
1297: END IF;
1298: END IF;
1299:

Line 1304: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1300: IF l_step_dtl.step_status IN (2, 3)
1301: THEN
1302: IF p_batchstep_activity_rec.actual_start_date = fnd_api.g_miss_date
1303: THEN
1304: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1305: 'FIELD_NAME',
1306: 'actual_start_date'
1307: );
1308: RAISE fnd_api.g_exc_error;

Line 1316: gme_common_pvt.g_timestamp

1312: )
1313: THEN
1314: -- Check that actual start date is not in the future
1315: IF p_batchstep_activity_rec.actual_start_date >
1316: gme_common_pvt.g_timestamp
1317: THEN
1318: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1319: fnd_msg_pub.ADD;
1320: RAISE fnd_api.g_exc_error;

Line 1330: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',

1326: OR p_batchstep_activity_rec.actual_start_date >
1327: l_step_dtl.actual_cmplt_date
1328: )
1329: THEN
1330: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
1331: 'ACTIVITY',
1332: l_activity
1333: );
1334: RAISE fnd_api.g_exc_error;

Line 1348: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1344: IF l_step_dtl.step_status = 3
1345: THEN
1346: IF p_batchstep_activity_rec.actual_cmplt_date = fnd_api.g_miss_date
1347: THEN
1348: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1349: 'FIELD_NAME',
1350: 'actual_cmplt_date'
1351: );
1352: RAISE fnd_api.g_exc_error;

Line 1360: gme_common_pvt.g_timestamp

1356: )
1357: THEN
1358: -- Check that actual cmplt date is not in the future
1359: IF p_batchstep_activity_rec.actual_cmplt_date >
1360: gme_common_pvt.g_timestamp
1361: THEN
1362: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1363: fnd_msg_pub.ADD;
1364: RAISE fnd_api.g_exc_error;

Line 1371: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',

1367: IF p_batchstep_activity_rec.actual_cmplt_date IS NOT NULL
1368: AND p_batchstep_activity_rec.actual_cmplt_date >
1369: l_step_dtl.actual_cmplt_date
1370: THEN
1371: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
1372: 'ACTIVITY',
1373: l_activity
1374: );
1375: RAISE fnd_api.g_exc_error;

Line 1390: gme_common_pvt.log_message ('PM_BADSTARTDATE');

1386: AND (l_batchstep_activity_rec.actual_start_date >
1387: l_batchstep_activity_rec.actual_cmplt_date
1388: )
1389: THEN
1390: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1391: RAISE fnd_api.g_exc_error;
1392: END IF;
1393:
1394: -- check that activities dates are within resource dates

Line 1428: gme_common_pvt.log_message ('GME_RSRC_DATES_NOT_ALLOWED',

1424: CLOSE cur_dates;
1425:
1426: IF l_resource IS NOT NULL
1427: THEN
1428: gme_common_pvt.log_message ('GME_RSRC_DATES_NOT_ALLOWED',
1429: 'RESOURCE',
1430: 'l_resource'
1431: );
1432: RAISE fnd_api.g_exc_error;

Line 1441: gme_common_pvt.log_message ('GME_PLAN_ACTV_FACT_NOTNULL');

1437: IF p_batchstep_activity_rec.plan_activity_factor =
1438: fnd_api.g_miss_num
1439: AND l_batchstep_activity_rec.plan_activity_factor IS NOT NULL
1440: THEN
1441: gme_common_pvt.log_message ('GME_PLAN_ACTV_FACT_NOTNULL');
1442: RAISE fnd_api.g_exc_error;
1443: END IF;
1444:
1445: IF ( p_batchstep_activity_rec.plan_activity_factor IS NOT NULL

Line 1466: gme_common_pvt.log_message ('GME_ACTUAL_ACTV_FACT_NOTNULL');

1462: IF p_batchstep_activity_rec.actual_activity_factor =
1463: fnd_api.g_miss_num
1464: AND l_batchstep_activity_rec.actual_activity_factor IS NOT NULL
1465: THEN
1466: gme_common_pvt.log_message ('GME_ACTUAL_ACTV_FACT_NOTNULL');
1467: RAISE fnd_api.g_exc_error;
1468: END IF;
1469:
1470: IF ( p_batchstep_activity_rec.actual_activity_factor IS NOT NULL

Line 1645: gme_common_pvt.log_message ('GME_NO_CHANGE_TO_UPD');

1641: END IF;
1642:
1643: IF NOT (l_field_updated)
1644: THEN
1645: gme_common_pvt.log_message ('GME_NO_CHANGE_TO_UPD');
1646: RAISE fnd_api.g_exc_error;
1647: END IF;
1648:
1649: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)

Line 1753: gme_common_pvt.log_message ('GME_RECORD_LOCKED',

1749: END IF;
1750: EXCEPTION
1751: WHEN app_exception.record_lock_exception
1752: THEN
1753: gme_common_pvt.log_message ('GME_RECORD_LOCKED',
1754: 'TABLE_NAME',
1755: 'GME_BATCH_STEP_ACTIVITIES',
1756: 'RECORD',
1757: 'Activity',

Line 1882: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1878: x_return_status := fnd_api.g_ret_sts_success;
1879:
1880: IF (p_batchstep_activity_id IS NULL AND p_activity IS NULL)
1881: THEN
1882: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1883: 'FIELD_NAME',
1884: 'ACTIVITY'
1885: );
1886: RAISE fnd_api.g_exc_error;

Line 1935: gme_common_pvt.log_message ('GME_ACTID_NOT_FOUND');

1931:
1932: IF cur_get_step_dtl%NOTFOUND
1933: THEN
1934: CLOSE cur_get_step_dtl;
1935: gme_common_pvt.log_message ('GME_ACTID_NOT_FOUND');
1936: RAISE fnd_api.g_exc_error;
1937: END IF;
1938:
1939: CLOSE cur_get_step_dtl;

Line 1950: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_DEL');

1946:
1947: IF l_batch_type = 10
1948: THEN
1949: CLOSE cur_check_fpo;
1950: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_DEL');
1951: RAISE fnd_api.g_exc_error;
1952: END IF;
1953:
1954: CLOSE cur_check_fpo;

Line 1966: gme_common_pvt.log_message ('PM_WRONG_STATUS');

1962: END IF;
1963:
1964: IF l_batch_status <> 1
1965: THEN
1966: gme_common_pvt.log_message ('PM_WRONG_STATUS');
1967: RAISE fnd_api.g_exc_error;
1968: END IF;
1969:
1970: OPEN cur_get_activity_count (l_batchstep_id);

Line 1975: gme_common_pvt.log_message ('GME_ACTIVITY_NOT_ATTACH');

1971: FETCH cur_get_activity_count INTO l_cnt;
1972:
1973: IF l_cnt = 1
1974: THEN
1975: gme_common_pvt.log_message ('GME_ACTIVITY_NOT_ATTACH');
1976: RAISE fnd_api.g_exc_error;
1977: END IF;
1978:
1979: l_batchstep_activity_rec.batch_id := l_batch_id;

Line 2048: gme_common_pvt.log_message ('GME_RECORD_LOCKED',

2044: END IF;
2045: EXCEPTION
2046: WHEN app_exception.record_lock_exception
2047: THEN
2048: gme_common_pvt.log_message ('GME_RECORD_LOCKED',
2049: 'TABLE_NAME',
2050: 'GME_BATCH_STEP_ACTIVITIES',
2051: 'RECORD',
2052: 'Activity',