DBA Data[Home] [Help]

APPS.MSC_LAUNCH_PLAN_PK dependencies on FND_MESSAGE

Line 1158: fnd_message.set_name('MSC',v_lookup_name);

1154: Close temp_plan_exist_Cur;
1155: end if;
1156: retcode := 2;
1157: if v_lookup_name is not null then
1158: fnd_message.set_name('MSC',v_lookup_name);
1159: fnd_message.set_token('PLAN_NAME',v_rec_c1.compile_designator);
1160: errbuf := fnd_message.get;
1161: end if;
1162: when OTHERS THEN

Line 1159: fnd_message.set_token('PLAN_NAME',v_rec_c1.compile_designator);

1155: end if;
1156: retcode := 2;
1157: if v_lookup_name is not null then
1158: fnd_message.set_name('MSC',v_lookup_name);
1159: fnd_message.set_token('PLAN_NAME',v_rec_c1.compile_designator);
1160: errbuf := fnd_message.get;
1161: end if;
1162: when OTHERS THEN
1163: retcode := 2;

Line 1160: errbuf := fnd_message.get;

1156: retcode := 2;
1157: if v_lookup_name is not null then
1158: fnd_message.set_name('MSC',v_lookup_name);
1159: fnd_message.set_token('PLAN_NAME',v_rec_c1.compile_designator);
1160: errbuf := fnd_message.get;
1161: end if;
1162: when OTHERS THEN
1163: retcode := 2;
1164: errbuf := sqlerrm;

Line 1263: fnd_message.set_name('MSC','MSC_X_API_INVALID_PLAN_NAME');

1259: open plan_name_cur(p_org_plan_id);
1260: fetch plan_name_cur into v_org_plan_name_Cur;
1261: if plan_name_Cur%notfound then
1262: retcode := 2;
1263: fnd_message.set_name('MSC','MSC_X_API_INVALID_PLAN_NAME');
1264: errbuf := fnd_message.get;
1265: raise error_deletion;
1266: END IF;
1267: close plan_name_cur;

Line 1264: errbuf := fnd_message.get;

1260: fetch plan_name_cur into v_org_plan_name_Cur;
1261: if plan_name_Cur%notfound then
1262: retcode := 2;
1263: fnd_message.set_name('MSC','MSC_X_API_INVALID_PLAN_NAME');
1264: errbuf := fnd_message.get;
1265: raise error_deletion;
1266: END IF;
1267: close plan_name_cur;
1268:

Line 1279: fnd_message.set_name('MSC','MSC_X_API_INVALID_PLAN_NAME');

1275: fetch plan_name_cur into v_temp_plan_name_Cur;
1276: if plan_name_Cur%notfound or v_temp_plan_name_cur.plan_completion_date is null
1277: or p_org_plan_id <> v_temp_plan_name_cur.copy_plan_id then
1278: retcode := 2;
1279: fnd_message.set_name('MSC','MSC_X_API_INVALID_PLAN_NAME');
1280: errbuf := fnd_message.get;
1281: close plan_name_cur;
1282: raise error_deletion;
1283: end if;

Line 1280: errbuf := fnd_message.get;

1276: if plan_name_Cur%notfound or v_temp_plan_name_cur.plan_completion_date is null
1277: or p_org_plan_id <> v_temp_plan_name_cur.copy_plan_id then
1278: retcode := 2;
1279: fnd_message.set_name('MSC','MSC_X_API_INVALID_PLAN_NAME');
1280: errbuf := fnd_message.get;
1281: close plan_name_cur;
1282: raise error_deletion;
1283: end if;
1284: close plan_name_cur;

Line 1290: fnd_message.set_name('MSC','MSC_X_API_INVALID_PLAN_NAME');

1286: open desig_cur(p_temp_plan_id);
1287: fetch desig_cur into v_temp_desig_cur;
1288: if desig_cur%notfound then
1289: retcode:= 2;
1290: fnd_message.set_name('MSC','MSC_X_API_INVALID_PLAN_NAME');
1291: errbuf := fnd_message.get;
1292: close desig_cur;
1293: raise error_deletion;
1294: end if;

Line 1291: errbuf := fnd_message.get;

1287: fetch desig_cur into v_temp_desig_cur;
1288: if desig_cur%notfound then
1289: retcode:= 2;
1290: fnd_message.set_name('MSC','MSC_X_API_INVALID_PLAN_NAME');
1291: errbuf := fnd_message.get;
1292: close desig_cur;
1293: raise error_deletion;
1294: end if;
1295: close desig_cur;

Line 2009: fnd_message.set_name('MSC',v_lookup_name);

2005: EXCEPTION
2006: when v_ex_error_plan_launch then
2007: retcode := 2;
2008: if v_lookup_name is not null then
2009: fnd_message.set_name('MSC',v_lookup_name);
2010: fnd_message.set_token('PLAN_NAME',v_rec_c1.compile_designator);
2011: errbuf := fnd_message.get;
2012: end if;
2013: when OTHERS THEN

Line 2010: fnd_message.set_token('PLAN_NAME',v_rec_c1.compile_designator);

2006: when v_ex_error_plan_launch then
2007: retcode := 2;
2008: if v_lookup_name is not null then
2009: fnd_message.set_name('MSC',v_lookup_name);
2010: fnd_message.set_token('PLAN_NAME',v_rec_c1.compile_designator);
2011: errbuf := fnd_message.get;
2012: end if;
2013: when OTHERS THEN
2014: retcode := 2;

Line 2011: errbuf := fnd_message.get;

2007: retcode := 2;
2008: if v_lookup_name is not null then
2009: fnd_message.set_name('MSC',v_lookup_name);
2010: fnd_message.set_token('PLAN_NAME',v_rec_c1.compile_designator);
2011: errbuf := fnd_message.get;
2012: end if;
2013: when OTHERS THEN
2014: retcode := 2;
2015: errbuf := sqlerrm;