DBA Data[Home] [Help]

APPS.GMD_SUBSTITUTION_PUB dependencies on GMD_API_GRP

Line 179: IF NOT gmd_api_grp.setup_done THEN

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;

Line 180: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 182: IF NOT gmd_api_grp.setup_done THEN

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 */

Line 302: IF NOT (gmd_api_grp.check_orgn_status(l_substitution_hdr_rec.owner_organization_id)) THEN

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;

Line 315: l_substitution_hdr_rec.created_by := gmd_api_grp.user_id;

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:

Line 317: l_substitution_hdr_rec.last_updated_by := gmd_api_grp.user_id;

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

Line 318: l_substitution_hdr_rec.last_update_login := gmd_api_grp.login_id;

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

Line 367: IF NOT (GMD_API_GRP.orgnaccessible (l_substitution_hdr_rec.owner_organization_id)) THEN

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

Line 459: l_substitution_dtl_rec.created_by := gmd_api_grp.user_id;

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:

Line 461: l_substitution_dtl_rec.last_updated_by := gmd_api_grp.user_id;

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

Line 462: l_substitution_dtl_rec.last_update_login := gmd_api_grp.login_id;

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:

Line 601: l_formula_substitution_rec.created_by := gmd_api_grp.user_id;

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:

Line 603: l_formula_substitution_rec.last_updated_by := gmd_api_grp.user_id;

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;

Line 604: l_formula_substitution_rec.last_update_login := gmd_api_grp.login_id;

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:

Line 710: IF NOT gmd_api_grp.setup_done THEN

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;

Line 711: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 713: IF NOT gmd_api_grp.setup_done THEN

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 */

Line 850: l_formula_substitution_rec.created_by := gmd_api_grp.user_id;

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:

Line 852: l_formula_substitution_rec.last_updated_by := gmd_api_grp.user_id;

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;

Line 853: l_formula_substitution_rec.last_update_login := gmd_api_grp.login_id;

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:

Line 946: IF NOT gmd_api_grp.setup_done THEN

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;

Line 947: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 949: IF NOT gmd_api_grp.setup_done THEN

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 */

Line 1143: l_substitution_hdr_rec.last_updated_by := gmd_api_grp.user_id;

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

Line 1144: l_substitution_hdr_rec.last_update_login := gmd_api_grp.login_id;

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

Line 1251: IF NOT gmd_api_grp.setup_done THEN

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;

Line 1252: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 1254: IF NOT gmd_api_grp.setup_done THEN

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 */

Line 1417: l_substitution_dtl_rec.last_updated_by := gmd_api_grp.user_id;

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

Line 1418: l_substitution_dtl_rec.last_update_login := gmd_api_grp.login_id;

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

Line 1514: IF NOT gmd_api_grp.setup_done THEN

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;

Line 1515: gmd_api_grp.setup_done := gmd_api_grp.setup;

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;

Line 1517: IF NOT gmd_api_grp.setup_done THEN

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 */