175: fnd_msg_pub.initialize;
176: END IF;
177:
178: /* Intialize the setup fields */
179: IF NOT gmd_api_grp.setup_done THEN
180: gmd_api_grp.setup_done := gmd_api_grp.setup;
181: END IF;
182: IF NOT gmd_api_grp.setup_done THEN
183: RAISE setup_failure;
176: END IF;
177:
178: /* Intialize the setup fields */
179: IF NOT gmd_api_grp.setup_done THEN
180: gmd_api_grp.setup_done := gmd_api_grp.setup;
181: END IF;
182: IF NOT gmd_api_grp.setup_done THEN
183: RAISE setup_failure;
184: END IF;
178: /* Intialize the setup fields */
179: IF NOT gmd_api_grp.setup_done THEN
180: gmd_api_grp.setup_done := gmd_api_grp.setup;
181: END IF;
182: IF NOT gmd_api_grp.setup_done THEN
183: RAISE setup_failure;
184: END IF;
185:
186: /* Make sure we are call compatible */
298: FND_MSG_PUB.Add;
299: RAISE substitution_creation_failure;
300: ELSE
301: --Check the organization id passed is process enabled if not raise an error message
302: IF NOT (gmd_api_grp.check_orgn_status(l_substitution_hdr_rec.owner_organization_id)) THEN
303: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
304: FND_MESSAGE.SET_TOKEN('ORGN_ID', l_substitution_hdr_rec.owner_organization_id);
305: FND_MSG_PUB.Add;
306: RAISE substitution_creation_failure;
311: END IF;
312:
313: -- Set the standard who columns
314: l_substitution_hdr_rec.creation_date := sysdate;
315: l_substitution_hdr_rec.created_by := gmd_api_grp.user_id;
316: l_substitution_hdr_rec.last_update_date := sysdate;
317: l_substitution_hdr_rec.last_updated_by := gmd_api_grp.user_id;
318: l_substitution_hdr_rec.last_update_login := gmd_api_grp.login_id;
319:
313: -- Set the standard who columns
314: l_substitution_hdr_rec.creation_date := sysdate;
315: l_substitution_hdr_rec.created_by := gmd_api_grp.user_id;
316: l_substitution_hdr_rec.last_update_date := sysdate;
317: l_substitution_hdr_rec.last_updated_by := gmd_api_grp.user_id;
318: l_substitution_hdr_rec.last_update_login := gmd_api_grp.login_id;
319:
320: /* Business Rules at header level */
321: -- Validation 1
314: l_substitution_hdr_rec.creation_date := sysdate;
315: l_substitution_hdr_rec.created_by := gmd_api_grp.user_id;
316: l_substitution_hdr_rec.last_update_date := sysdate;
317: l_substitution_hdr_rec.last_updated_by := gmd_api_grp.user_id;
318: l_substitution_hdr_rec.last_update_login := gmd_api_grp.login_id;
319:
320: /* Business Rules at header level */
321: -- Validation 1
322: -- Check if the substitution exists
363: END IF;
364:
365: -- Validation 4
366: -- Check the Organization Access to the responsibility
367: IF NOT (GMD_API_GRP.orgnaccessible (l_substitution_hdr_rec.owner_organization_id)) THEN
368: RAISE substitution_creation_failure;
369: END IF;
370:
371: --Validation 5
455: END IF;
456:
457: -- Set the standard who columns
458: l_substitution_dtl_rec.creation_date := sysdate;
459: l_substitution_dtl_rec.created_by := gmd_api_grp.user_id;
460: l_substitution_dtl_rec.last_update_date := sysdate;
461: l_substitution_dtl_rec.last_updated_by := gmd_api_grp.user_id;
462: l_substitution_dtl_rec.last_update_login := gmd_api_grp.login_id;
463:
457: -- Set the standard who columns
458: l_substitution_dtl_rec.creation_date := sysdate;
459: l_substitution_dtl_rec.created_by := gmd_api_grp.user_id;
460: l_substitution_dtl_rec.last_update_date := sysdate;
461: l_substitution_dtl_rec.last_updated_by := gmd_api_grp.user_id;
462: l_substitution_dtl_rec.last_update_login := gmd_api_grp.login_id;
463:
464: /* Business Rules at Detail level */
465: -- Validation 1
458: l_substitution_dtl_rec.creation_date := sysdate;
459: l_substitution_dtl_rec.created_by := gmd_api_grp.user_id;
460: l_substitution_dtl_rec.last_update_date := sysdate;
461: l_substitution_dtl_rec.last_updated_by := gmd_api_grp.user_id;
462: l_substitution_dtl_rec.last_update_login := gmd_api_grp.login_id;
463:
464: /* Business Rules at Detail level */
465: -- Validation 1
466:
597: l_dummy := 0;
598:
599: -- Set the standard who columns
600: l_formula_substitution_rec.creation_date := sysdate;
601: l_formula_substitution_rec.created_by := gmd_api_grp.user_id;
602: l_formula_substitution_rec.last_update_date := sysdate;
603: l_formula_substitution_rec.last_updated_by := gmd_api_grp.user_id;
604: l_formula_substitution_rec.last_update_login := gmd_api_grp.login_id;
605:
599: -- Set the standard who columns
600: l_formula_substitution_rec.creation_date := sysdate;
601: l_formula_substitution_rec.created_by := gmd_api_grp.user_id;
602: l_formula_substitution_rec.last_update_date := sysdate;
603: l_formula_substitution_rec.last_updated_by := gmd_api_grp.user_id;
604: l_formula_substitution_rec.last_update_login := gmd_api_grp.login_id;
605:
606: l_formula_substitution_tbl(i) := l_formula_substitution_rec;
607: END LOOP;
600: l_formula_substitution_rec.creation_date := sysdate;
601: l_formula_substitution_rec.created_by := gmd_api_grp.user_id;
602: l_formula_substitution_rec.last_update_date := sysdate;
603: l_formula_substitution_rec.last_updated_by := gmd_api_grp.user_id;
604: l_formula_substitution_rec.last_update_login := gmd_api_grp.login_id;
605:
606: l_formula_substitution_tbl(i) := l_formula_substitution_rec;
607: END LOOP;
608:
706: fnd_msg_pub.initialize;
707: END IF;
708:
709: /* Intialize the setup fields */
710: IF NOT gmd_api_grp.setup_done THEN
711: gmd_api_grp.setup_done := gmd_api_grp.setup;
712: END IF;
713: IF NOT gmd_api_grp.setup_done THEN
714: RAISE setup_failure;
707: END IF;
708:
709: /* Intialize the setup fields */
710: IF NOT gmd_api_grp.setup_done THEN
711: gmd_api_grp.setup_done := gmd_api_grp.setup;
712: END IF;
713: IF NOT gmd_api_grp.setup_done THEN
714: RAISE setup_failure;
715: END IF;
709: /* Intialize the setup fields */
710: IF NOT gmd_api_grp.setup_done THEN
711: gmd_api_grp.setup_done := gmd_api_grp.setup;
712: END IF;
713: IF NOT gmd_api_grp.setup_done THEN
714: RAISE setup_failure;
715: END IF;
716:
717: /* Make sure we are call compatible */
846: l_dummy := 0;
847:
848: -- Set the standard who columns
849: l_formula_substitution_rec.creation_date := sysdate;
850: l_formula_substitution_rec.created_by := gmd_api_grp.user_id;
851: l_formula_substitution_rec.last_update_date := sysdate;
852: l_formula_substitution_rec.last_updated_by := gmd_api_grp.user_id;
853: l_formula_substitution_rec.last_update_login := gmd_api_grp.login_id;
854:
848: -- Set the standard who columns
849: l_formula_substitution_rec.creation_date := sysdate;
850: l_formula_substitution_rec.created_by := gmd_api_grp.user_id;
851: l_formula_substitution_rec.last_update_date := sysdate;
852: l_formula_substitution_rec.last_updated_by := gmd_api_grp.user_id;
853: l_formula_substitution_rec.last_update_login := gmd_api_grp.login_id;
854:
855: l_formula_substitution_tbl(i) := l_formula_substitution_rec;
856: END LOOP;
849: l_formula_substitution_rec.creation_date := sysdate;
850: l_formula_substitution_rec.created_by := gmd_api_grp.user_id;
851: l_formula_substitution_rec.last_update_date := sysdate;
852: l_formula_substitution_rec.last_updated_by := gmd_api_grp.user_id;
853: l_formula_substitution_rec.last_update_login := gmd_api_grp.login_id;
854:
855: l_formula_substitution_tbl(i) := l_formula_substitution_rec;
856: END LOOP;
857:
942: fnd_msg_pub.initialize;
943: END IF;
944:
945: /* Intialize the setup fields */
946: IF NOT gmd_api_grp.setup_done THEN
947: gmd_api_grp.setup_done := gmd_api_grp.setup;
948: END IF;
949: IF NOT gmd_api_grp.setup_done THEN
950: RAISE setup_failure;
943: END IF;
944:
945: /* Intialize the setup fields */
946: IF NOT gmd_api_grp.setup_done THEN
947: gmd_api_grp.setup_done := gmd_api_grp.setup;
948: END IF;
949: IF NOT gmd_api_grp.setup_done THEN
950: RAISE setup_failure;
951: END IF;
945: /* Intialize the setup fields */
946: IF NOT gmd_api_grp.setup_done THEN
947: gmd_api_grp.setup_done := gmd_api_grp.setup;
948: END IF;
949: IF NOT gmd_api_grp.setup_done THEN
950: RAISE setup_failure;
951: END IF;
952:
953: /* Make sure we are call compatible */
1139: END IF;
1140:
1141: -- Assign values
1142: l_substitution_hdr_rec.last_update_date := SYSDATE;
1143: l_substitution_hdr_rec.last_updated_by := gmd_api_grp.user_id;
1144: l_substitution_hdr_rec.last_update_login := gmd_api_grp.login_id;
1145: END LOOP;
1146:
1147: --Call the Pvt Substitution header API
1140:
1141: -- Assign values
1142: l_substitution_hdr_rec.last_update_date := SYSDATE;
1143: l_substitution_hdr_rec.last_updated_by := gmd_api_grp.user_id;
1144: l_substitution_hdr_rec.last_update_login := gmd_api_grp.login_id;
1145: END LOOP;
1146:
1147: --Call the Pvt Substitution header API
1148: GMD_SUBSTITUTION_PVT.Update_substitution_header
1247: fnd_msg_pub.initialize;
1248: END IF;
1249:
1250: /* Intialize the setup fields */
1251: IF NOT gmd_api_grp.setup_done THEN
1252: gmd_api_grp.setup_done := gmd_api_grp.setup;
1253: END IF;
1254: IF NOT gmd_api_grp.setup_done THEN
1255: RAISE setup_failure;
1248: END IF;
1249:
1250: /* Intialize the setup fields */
1251: IF NOT gmd_api_grp.setup_done THEN
1252: gmd_api_grp.setup_done := gmd_api_grp.setup;
1253: END IF;
1254: IF NOT gmd_api_grp.setup_done THEN
1255: RAISE setup_failure;
1256: END IF;
1250: /* Intialize the setup fields */
1251: IF NOT gmd_api_grp.setup_done THEN
1252: gmd_api_grp.setup_done := gmd_api_grp.setup;
1253: END IF;
1254: IF NOT gmd_api_grp.setup_done THEN
1255: RAISE setup_failure;
1256: END IF;
1257:
1258: /* Make sure we are call compatible */
1413: END IF;
1414:
1415: -- Assign values
1416: l_substitution_dtl_rec.last_update_date := SYSDATE;
1417: l_substitution_dtl_rec.last_updated_by := gmd_api_grp.user_id;
1418: l_substitution_dtl_rec.last_update_login := gmd_api_grp.login_id;
1419: END LOOP;
1420:
1421: -- call the pvt API
1414:
1415: -- Assign values
1416: l_substitution_dtl_rec.last_update_date := SYSDATE;
1417: l_substitution_dtl_rec.last_updated_by := gmd_api_grp.user_id;
1418: l_substitution_dtl_rec.last_update_login := gmd_api_grp.login_id;
1419: END LOOP;
1420:
1421: -- call the pvt API
1422: GMD_SUBSTITUTION_PVT.Update_substitution_detail
1510: fnd_msg_pub.initialize;
1511: END IF;
1512:
1513: /* Intialize the setup fields */
1514: IF NOT gmd_api_grp.setup_done THEN
1515: gmd_api_grp.setup_done := gmd_api_grp.setup;
1516: END IF;
1517: IF NOT gmd_api_grp.setup_done THEN
1518: RAISE setup_failure;
1511: END IF;
1512:
1513: /* Intialize the setup fields */
1514: IF NOT gmd_api_grp.setup_done THEN
1515: gmd_api_grp.setup_done := gmd_api_grp.setup;
1516: END IF;
1517: IF NOT gmd_api_grp.setup_done THEN
1518: RAISE setup_failure;
1519: END IF;
1513: /* Intialize the setup fields */
1514: IF NOT gmd_api_grp.setup_done THEN
1515: gmd_api_grp.setup_done := gmd_api_grp.setup;
1516: END IF;
1517: IF NOT gmd_api_grp.setup_done THEN
1518: RAISE setup_failure;
1519: END IF;
1520:
1521: /* Make sure we are call compatible */