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 726: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

722: x_return_status := fnd_api.g_ret_sts_success;
723:
724: IF p_batchstep_activity_rec.activity IS NULL
725: THEN
726: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
727: 'FIELD_NAME',
728: 'ACTIVITY'
729: );
730: RAISE fnd_api.g_exc_error;

Line 743: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND',

739:
740: IF cur_validate_step%NOTFOUND
741: THEN
742: CLOSE cur_validate_step;
743: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND',
744: 'STEP_ID',
745: l_batchstep_id
746: );
747: RAISE fnd_api.g_exc_error;

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

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

Line 889: gme_common_pvt.log_message ('GME_ONLY_ONE_PRIM_RSRC',

885: END LOOP;
886:
887: IF l_prim_rsrc_count <> 1
888: THEN
889: gme_common_pvt.log_message ('GME_ONLY_ONE_PRIM_RSRC',
890: 'ACTIVITY',
891: l_batchstep_activity_rec.activity,
892: 'STEPNO',
893: p_batchstep_no

Line 1118: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1114: IF ( p_batchstep_activity_rec.activity IS NULL
1115: AND p_batchstep_activity_rec.batchstep_activity_id IS NULL
1116: )
1117: THEN
1118: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1119: 'FIELD_NAME',
1120: 'ACTIVITY'
1121: );
1122: RAISE fnd_api.g_exc_error;

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

1132:
1133: IF cur_get_dtl%NOTFOUND
1134: THEN
1135: CLOSE cur_get_dtl;
1136: gme_common_pvt.log_message ('GME_ACTID_NOT_FOUND');
1137: RAISE fnd_api.g_exc_error;
1138: END IF;
1139:
1140: CLOSE cur_get_dtl;

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

1179:
1180: IF l_batch_type = 10
1181: THEN
1182: CLOSE cur_check_fpo;
1183: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_EDIT');
1184: RAISE fnd_api.g_exc_error;
1185: END IF;
1186:
1187: CLOSE cur_check_fpo;

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

1205: l_seq_dep_ind := l_batchstep_activity_rec.sequence_dependent_ind;
1206:
1207: IF l_step_status IN (4, 5)
1208: THEN
1209: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
1210: RAISE fnd_api.g_exc_error;
1211: END IF;
1212:
1213: IF p_batchstep_activity_rec.offset_interval = fnd_api.g_miss_num

Line 1215: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1211: END IF;
1212:
1213: IF p_batchstep_activity_rec.offset_interval = fnd_api.g_miss_num
1214: THEN
1215: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1216: 'FIELD_NAME',
1217: 'offset_interval'
1218: );
1219: RAISE fnd_api.g_exc_error;

Line 1239: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1235: IF l_step_status IN (1, 2)
1236: THEN
1237: IF p_batchstep_activity_rec.plan_start_date = fnd_api.g_miss_date
1238: THEN
1239: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1240: 'FIELD_NAME',
1241: 'plan_start_date'
1242: );
1243: RAISE fnd_api.g_exc_error;

Line 1255: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',

1251: l_step_dtl.plan_start_date
1252: OR p_batchstep_activity_rec.plan_start_date >
1253: l_step_dtl.plan_cmplt_date
1254: THEN
1255: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
1256: 'ACTIVITY',
1257: l_activity
1258: );
1259: RAISE fnd_api.g_exc_error;

Line 1270: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1266: END IF;
1267:
1268: IF p_batchstep_activity_rec.plan_cmplt_date = fnd_api.g_miss_date
1269: THEN
1270: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1271: 'FIELD_NAME',
1272: 'plan_cmplt_date'
1273: );
1274: RAISE fnd_api.g_exc_error;

Line 1284: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',

1280: -- Check that the activity plan dates fall within the step dates.
1281: IF p_batchstep_activity_rec.plan_cmplt_date >
1282: l_step_dtl.plan_cmplt_date
1283: THEN
1284: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
1285: 'ACTIVITY',
1286: l_activity
1287: );
1288: RAISE fnd_api.g_exc_error;

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

1298: AND l_batchstep_activity_rec.plan_start_date >
1299: l_batchstep_activity_rec.plan_cmplt_date
1300: )
1301: THEN
1302: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1303: RAISE fnd_api.g_exc_error;
1304: END IF;
1305: END IF;
1306:

Line 1311: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1307: IF l_step_dtl.step_status IN (2, 3)
1308: THEN
1309: IF p_batchstep_activity_rec.actual_start_date = fnd_api.g_miss_date
1310: THEN
1311: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1312: 'FIELD_NAME',
1313: 'actual_start_date'
1314: );
1315: RAISE fnd_api.g_exc_error;

Line 1323: gme_common_pvt.g_timestamp

1319: )
1320: THEN
1321: -- Check that actual start date is not in the future
1322: IF p_batchstep_activity_rec.actual_start_date >
1323: gme_common_pvt.g_timestamp
1324: THEN
1325: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1326: fnd_msg_pub.ADD;
1327: RAISE fnd_api.g_exc_error;

Line 1337: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',

1333: OR p_batchstep_activity_rec.actual_start_date >
1334: l_step_dtl.actual_cmplt_date
1335: )
1336: THEN
1337: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
1338: 'ACTIVITY',
1339: l_activity
1340: );
1341: RAISE fnd_api.g_exc_error;

Line 1355: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1351: IF l_step_dtl.step_status = 3
1352: THEN
1353: IF p_batchstep_activity_rec.actual_cmplt_date = fnd_api.g_miss_date
1354: THEN
1355: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1356: 'FIELD_NAME',
1357: 'actual_cmplt_date'
1358: );
1359: RAISE fnd_api.g_exc_error;

Line 1367: gme_common_pvt.g_timestamp

1363: )
1364: THEN
1365: -- Check that actual cmplt date is not in the future
1366: IF p_batchstep_activity_rec.actual_cmplt_date >
1367: gme_common_pvt.g_timestamp
1368: THEN
1369: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1370: fnd_msg_pub.ADD;
1371: RAISE fnd_api.g_exc_error;

Line 1378: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',

1374: IF p_batchstep_activity_rec.actual_cmplt_date IS NOT NULL
1375: AND p_batchstep_activity_rec.actual_cmplt_date >
1376: l_step_dtl.actual_cmplt_date
1377: THEN
1378: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
1379: 'ACTIVITY',
1380: l_activity
1381: );
1382: RAISE fnd_api.g_exc_error;

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

1393: AND (l_batchstep_activity_rec.actual_start_date >
1394: l_batchstep_activity_rec.actual_cmplt_date
1395: )
1396: THEN
1397: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1398: RAISE fnd_api.g_exc_error;
1399: END IF;
1400:
1401: -- check that activities dates are within resource dates

Line 1435: gme_common_pvt.log_message ('GME_RSRC_DATES_NOT_ALLOWED',

1431: CLOSE cur_dates;
1432:
1433: IF l_resource IS NOT NULL
1434: THEN
1435: gme_common_pvt.log_message ('GME_RSRC_DATES_NOT_ALLOWED',
1436: 'RESOURCE',
1437: 'l_resource'
1438: );
1439: RAISE fnd_api.g_exc_error;

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

1444: IF p_batchstep_activity_rec.plan_activity_factor =
1445: fnd_api.g_miss_num
1446: AND l_batchstep_activity_rec.plan_activity_factor IS NOT NULL
1447: THEN
1448: gme_common_pvt.log_message ('GME_PLAN_ACTV_FACT_NOTNULL');
1449: RAISE fnd_api.g_exc_error;
1450: END IF;
1451:
1452: IF ( p_batchstep_activity_rec.plan_activity_factor IS NOT NULL

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

1469: IF p_batchstep_activity_rec.actual_activity_factor =
1470: fnd_api.g_miss_num
1471: AND l_batchstep_activity_rec.actual_activity_factor IS NOT NULL
1472: THEN
1473: gme_common_pvt.log_message ('GME_ACTUAL_ACTV_FACT_NOTNULL');
1474: RAISE fnd_api.g_exc_error;
1475: END IF;
1476:
1477: IF ( p_batchstep_activity_rec.actual_activity_factor IS NOT NULL

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

1648: END IF;
1649:
1650: IF NOT (l_field_updated)
1651: THEN
1652: gme_common_pvt.log_message ('GME_NO_CHANGE_TO_UPD');
1653: RAISE fnd_api.g_exc_error;
1654: END IF;
1655:
1656: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)

Line 1760: gme_common_pvt.log_message ('GME_RECORD_LOCKED',

1756: END IF;
1757: EXCEPTION
1758: WHEN app_exception.record_lock_exception
1759: THEN
1760: gme_common_pvt.log_message ('GME_RECORD_LOCKED',
1761: 'TABLE_NAME',
1762: 'GME_BATCH_STEP_ACTIVITIES',
1763: 'RECORD',
1764: 'Activity',

Line 1889: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

1885: x_return_status := fnd_api.g_ret_sts_success;
1886:
1887: IF (p_batchstep_activity_id IS NULL AND p_activity IS NULL)
1888: THEN
1889: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1890: 'FIELD_NAME',
1891: 'ACTIVITY'
1892: );
1893: RAISE fnd_api.g_exc_error;

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

1938:
1939: IF cur_get_step_dtl%NOTFOUND
1940: THEN
1941: CLOSE cur_get_step_dtl;
1942: gme_common_pvt.log_message ('GME_ACTID_NOT_FOUND');
1943: RAISE fnd_api.g_exc_error;
1944: END IF;
1945:
1946: CLOSE cur_get_step_dtl;

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

1953:
1954: IF l_batch_type = 10
1955: THEN
1956: CLOSE cur_check_fpo;
1957: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_DEL');
1958: RAISE fnd_api.g_exc_error;
1959: END IF;
1960:
1961: CLOSE cur_check_fpo;

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

1969: END IF;
1970:
1971: IF l_batch_status <> 1
1972: THEN
1973: gme_common_pvt.log_message ('PM_WRONG_STATUS');
1974: RAISE fnd_api.g_exc_error;
1975: END IF;
1976:
1977: OPEN cur_get_activity_count (l_batchstep_id);

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

1978: FETCH cur_get_activity_count INTO l_cnt;
1979:
1980: IF l_cnt = 1
1981: THEN
1982: gme_common_pvt.log_message ('GME_ACTIVITY_NOT_ATTACH');
1983: RAISE fnd_api.g_exc_error;
1984: END IF;
1985:
1986: l_batchstep_activity_rec.batch_id := l_batch_id;

Line 2055: gme_common_pvt.log_message ('GME_RECORD_LOCKED',

2051: END IF;
2052: EXCEPTION
2053: WHEN app_exception.record_lock_exception
2054: THEN
2055: gme_common_pvt.log_message ('GME_RECORD_LOCKED',
2056: 'TABLE_NAME',
2057: 'GME_BATCH_STEP_ACTIVITIES',
2058: 'RECORD',
2059: 'Activity',