eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on STANDARD

Line 468: -- Standard check of p_commit.

464:
465: --
466: -- End of main API body.
467:
468: -- Standard check of p_commit.
469: IF (FND_API.To_Boolean(p_commit)) THEN
470: COMMIT WORK;
471: END IF;
472:

Line 473: -- Standard call to get message count and if count is 1, get message info.

469: IF (FND_API.To_Boolean(p_commit)) THEN
470: COMMIT WORK;
471: END IF;
472:
473: -- Standard call to get message count and if count is 1, get message info.
474: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
475: p_data => x_msg_data,
476: p_encoded => 'F');
477:

Line 576: -- or using old standard layout, then no layout component mapping

572: -- This procedure will copy the layout component mapping from
573: -- parent section to the child section when the section is using
574: -- new configurable layout.
575: -- If the section is not using any layout (blank in deliverable_id)
576: -- or using old standard layout, then no layout component mapping
577: -- will be copied over.
578: PROCEDURE Copy_Layout_Comp_Mapping
579: (p_api_version IN NUMBER,
580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 734: -- Standard check of p_commit.

730: END IF;
731: END IF;
732: --
733: -- End of main API body.
734: -- Standard check of p_commit.
735: IF (FND_API.To_Boolean(p_commit)) THEN
736: COMMIT;
737: END IF;
738: -- Standard call to get message count and if count is 1, get message info.

Line 738: -- Standard call to get message count and if count is 1, get message info.

734: -- Standard check of p_commit.
735: IF (FND_API.To_Boolean(p_commit)) THEN
736: COMMIT;
737: END IF;
738: -- Standard call to get message count and if count is 1, get message info.
739: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
740: p_data => x_msg_data,
741: p_encoded => 'F');
742: EXCEPTION

Line 833: -- or standard layout (old). By default, configurable layout will

829: l_is_root_section BOOLEAN := FALSE;
830:
831: -- For 11.5.10
832: -- This flag will be checked to see if use configurable layout
833: -- or standard layout (old). By default, configurable layout will
834: -- be used
835: l_use_configurable_layout BOOLEAN := TRUE;
836: l_deliverable_id NUMBER;
837: l_parent_deli_id NUMBER := NULL;

Line 897: -- Standard Start of API savepoint

893: AND child_section_id = l_c_parent_section_id));
894:
895: BEGIN
896:
897: -- Standard Start of API savepoint
898: SAVEPOINT CREATE_HIERARCHY_SECTION_PVT;
899:
900: -- Standard call to check for call compatibility.
901: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 900: -- Standard call to check for call compatibility.

896:
897: -- Standard Start of API savepoint
898: SAVEPOINT CREATE_HIERARCHY_SECTION_PVT;
899:
900: -- Standard call to check for call compatibility.
901: IF NOT FND_API.Compatible_API_Call(l_api_version,
902: p_api_version,
903: l_api_name,
904: G_PKG_NAME)

Line 1278: -- Standard check of p_commit.

1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;
1276: END IF;
1277: END IF;
1278: -- Standard check of p_commit.
1279: IF (FND_API.To_Boolean(p_commit)) THEN
1280: COMMIT WORK;
1281: END IF;
1282:

Line 1283: -- Standard call to get message count and if count is 1, get message info.

1279: IF (FND_API.To_Boolean(p_commit)) THEN
1280: COMMIT WORK;
1281: END IF;
1282:
1283: -- Standard call to get message count and if count is 1, get message info.
1284: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1285: p_data => x_msg_data,
1286: p_encoded => 'F');
1287:

Line 1514: -- Standard Start of API savepoint

1510: AND mini_site_id = l_c_master_mini_site_id);
1511:
1512: BEGIN
1513:
1514: -- Standard Start of API savepoint
1515: SAVEPOINT UPDATE_HIERARCHY_SECTION_PVT;
1516:
1517: -- Standard call to check for call compatibility.
1518: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 1517: -- Standard call to check for call compatibility.

1513:
1514: -- Standard Start of API savepoint
1515: SAVEPOINT UPDATE_HIERARCHY_SECTION_PVT;
1516:
1517: -- Standard call to check for call compatibility.
1518: IF NOT FND_API.Compatible_API_Call(l_api_version,
1519: p_api_version,
1520: l_api_name,
1521: G_PKG_NAME)

Line 1760: -- Standard check of p_commit.

1756:
1757: --
1758: -- End of main API body.
1759:
1760: -- Standard check of p_commit.
1761: IF (FND_API.To_Boolean(p_commit)) THEN
1762: COMMIT WORK;
1763: END IF;
1764:

Line 1765: -- Standard call to get message count and if count is 1, get message info.

1761: IF (FND_API.To_Boolean(p_commit)) THEN
1762: COMMIT WORK;
1763: END IF;
1764:
1765: -- Standard call to get message count and if count is 1, get message info.
1766: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1767: p_data => x_msg_data,
1768: p_encoded => 'F');
1769:

Line 1853: -- Standard Start of API savepoint

1849: ORDER BY MSS.level_number desc;
1850:
1851: BEGIN
1852:
1853: -- Standard Start of API savepoint
1854: SAVEPOINT DELETE_HIERARCHY_SECTION_PVT;
1855:
1856: -- Standard call to check for call compatibility.
1857: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 1856: -- Standard call to check for call compatibility.

1852:
1853: -- Standard Start of API savepoint
1854: SAVEPOINT DELETE_HIERARCHY_SECTION_PVT;
1855:
1856: -- Standard call to check for call compatibility.
1857: IF NOT FND_API.Compatible_API_Call(l_api_version,
1858: p_api_version,
1859: l_api_name,
1860: G_PKG_NAME)

Line 1946: -- Standard check of p_commit.

1942:
1943: --
1944: -- End of main API body.
1945:
1946: -- Standard check of p_commit.
1947: IF (FND_API.To_Boolean(p_commit)) THEN
1948: COMMIT WORK;
1949: END IF;
1950:

Line 1951: -- Standard call to get message count and if count is 1, get message info.

1947: IF (FND_API.To_Boolean(p_commit)) THEN
1948: COMMIT WORK;
1949: END IF;
1950:
1951: -- Standard call to get message count and if count is 1, get message info.
1952: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1953: p_data => x_msg_data,
1954: p_encoded => 'F');
1955:

Line 2023: -- Standard Start of API savepoint

2019: WHERE access_name = l_c_access_name;
2020:
2021: BEGIN
2022:
2023: -- Standard Start of API savepoint
2024: SAVEPOINT DELETE_HIERARCHY_SECTION_PVT;
2025:
2026: -- Standard call to check for call compatibility.
2027: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 2026: -- Standard call to check for call compatibility.

2022:
2023: -- Standard Start of API savepoint
2024: SAVEPOINT DELETE_HIERARCHY_SECTION_PVT;
2025:
2026: -- Standard call to check for call compatibility.
2027: IF NOT FND_API.Compatible_API_Call(l_api_version,
2028: p_api_version,
2029: l_api_name,
2030: G_PKG_NAME)

Line 2109: -- Standard check of p_commit.

2105:
2106: --
2107: -- End of main API body.
2108:
2109: -- Standard check of p_commit.
2110: IF (FND_API.To_Boolean(p_commit)) THEN
2111: COMMIT WORK;
2112: END IF;
2113:

Line 2114: -- Standard call to get message count and if count is 1, get message info.

2110: IF (FND_API.To_Boolean(p_commit)) THEN
2111: COMMIT WORK;
2112: END IF;
2113:
2114: -- Standard call to get message count and if count is 1, get message info.
2115: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2116: p_data => x_msg_data,
2117: p_encoded => 'F');
2118:

Line 2213: -- Standard Start of API savepoint

2209: AND organization_id = l_c_organization_id;
2210:
2211: BEGIN
2212:
2213: -- Standard Start of API savepoint
2214: SAVEPOINT ASSOCIATE_ITEMS_TO_SECTION_PVT;
2215:
2216: -- Standard call to check for call compatibility.
2217: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 2216: -- Standard call to check for call compatibility.

2212:
2213: -- Standard Start of API savepoint
2214: SAVEPOINT ASSOCIATE_ITEMS_TO_SECTION_PVT;
2215:
2216: -- Standard call to check for call compatibility.
2217: IF NOT FND_API.Compatible_API_Call(l_api_version,
2218: p_api_version,
2219: l_api_name,
2220: G_PKG_NAME)

Line 2333: -- Standard check of p_commit.

2329:
2330: --
2331: -- End of main API body.
2332:
2333: -- Standard check of p_commit.
2334: IF (FND_API.To_Boolean(p_commit)) THEN
2335: COMMIT WORK;
2336: END IF;
2337:

Line 2338: -- Standard call to get message count and if count is 1, get message info.

2334: IF (FND_API.To_Boolean(p_commit)) THEN
2335: COMMIT WORK;
2336: END IF;
2337:
2338: -- Standard call to get message count and if count is 1, get message info.
2339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2340: p_data => x_msg_data,
2341: p_encoded => 'F');
2342:

Line 2433: -- Standard Start of API savepoint

2429: AND organization_id = l_c_organization_id;
2430:
2431: BEGIN
2432:
2433: -- Standard Start of API savepoint
2434: SAVEPOINT ASSOCIATE_SECTIONS_TO_ITEM_PVT;
2435:
2436: -- Standard call to check for call compatibility.
2437: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 2436: -- Standard call to check for call compatibility.

2432:
2433: -- Standard Start of API savepoint
2434: SAVEPOINT ASSOCIATE_SECTIONS_TO_ITEM_PVT;
2435:
2436: -- Standard call to check for call compatibility.
2437: IF NOT FND_API.Compatible_API_Call(l_api_version,
2438: p_api_version,
2439: l_api_name,
2440: G_PKG_NAME)

Line 2543: -- Standard check of p_commit.

2539:
2540: --
2541: -- End of main API body.
2542:
2543: -- Standard check of p_commit.
2544: IF (FND_API.To_Boolean(p_commit)) THEN
2545: COMMIT WORK;
2546: END IF;
2547:

Line 2548: -- Standard call to get message count and if count is 1, get message info.

2544: IF (FND_API.To_Boolean(p_commit)) THEN
2545: COMMIT WORK;
2546: END IF;
2547:
2548: -- Standard call to get message count and if count is 1, get message info.
2549: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2550: p_data => x_msg_data,
2551: p_encoded => 'F');
2552:

Line 2618: -- Standard Start of API savepoint

2614: l_section_id NUMBER;
2615:
2616: BEGIN
2617:
2618: -- Standard Start of API savepoint
2619: SAVEPOINT DISASSOCIATE_SCTS_TO_ITMS_PVT;
2620:
2621: -- Standard call to check for call compatibility.
2622: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 2621: -- Standard call to check for call compatibility.

2617:
2618: -- Standard Start of API savepoint
2619: SAVEPOINT DISASSOCIATE_SCTS_TO_ITMS_PVT;
2620:
2621: -- Standard call to check for call compatibility.
2622: IF NOT FND_API.Compatible_API_Call(l_api_version,
2623: p_api_version,
2624: l_api_name,
2625: G_PKG_NAME)

Line 2672: -- Standard check of p_commit.

2668:
2669: --
2670: -- End of main API body.
2671:
2672: -- Standard check of p_commit.
2673: IF (FND_API.To_Boolean(p_commit)) THEN
2674: COMMIT WORK;
2675: END IF;
2676:

Line 2677: -- Standard call to get message count and if count is 1, get message info.

2673: IF (FND_API.To_Boolean(p_commit)) THEN
2674: COMMIT WORK;
2675: END IF;
2676:
2677: -- Standard call to get message count and if count is 1, get message info.
2678: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2679: p_data => x_msg_data,
2680: p_encoded => 'F');
2681:

Line 2745: -- Standard Start of API savepoint

2741: l_section_id NUMBER;
2742:
2743: BEGIN
2744:
2745: -- Standard Start of API savepoint
2746: SAVEPOINT DISASSOCIATE_SCTS_ITMS_PVT;
2747:
2748: -- Standard call to check for call compatibility.
2749: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 2748: -- Standard call to check for call compatibility.

2744:
2745: -- Standard Start of API savepoint
2746: SAVEPOINT DISASSOCIATE_SCTS_ITMS_PVT;
2747:
2748: -- Standard call to check for call compatibility.
2749: IF NOT FND_API.Compatible_API_Call(l_api_version,
2750: p_api_version,
2751: l_api_name,
2752: G_PKG_NAME)

Line 2796: -- Standard check of p_commit.

2792:
2793: --
2794: -- End of main API body.
2795:
2796: -- Standard check of p_commit.
2797: IF (FND_API.To_Boolean(p_commit)) THEN
2798: COMMIT WORK;
2799: END IF;
2800:

Line 2801: -- Standard call to get message count and if count is 1, get message info.

2797: IF (FND_API.To_Boolean(p_commit)) THEN
2798: COMMIT WORK;
2799: END IF;
2800:
2801: -- Standard call to get message count and if count is 1, get message info.
2802: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2803: p_data => x_msg_data,
2804: p_encoded => 'F');
2805:

Line 2995: -- Standard Start of API savepoint

2991: l_end_date_active DATE;
2992: l_sort_order NUMBER;
2993: BEGIN
2994:
2995: -- Standard Start of API savepoint
2996: SAVEPOINT ASSOCIATE_MSITES_TO_SECTION;
2997:
2998: -- Standard call to check for call compatibility.
2999: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 2998: -- Standard call to check for call compatibility.

2994:
2995: -- Standard Start of API savepoint
2996: SAVEPOINT ASSOCIATE_MSITES_TO_SECTION;
2997:
2998: -- Standard call to check for call compatibility.
2999: IF NOT FND_API.Compatible_API_Call(l_api_version,
3000: p_api_version,
3001: l_api_name,
3002: G_PKG_NAME)

Line 3230: -- Standard check of p_commit.

3226:
3227: --
3228: -- End of main API body.
3229:
3230: -- Standard check of p_commit.
3231: IF (FND_API.To_Boolean(p_commit)) THEN
3232: COMMIT WORK;
3233: END IF;
3234:

Line 3235: -- Standard call to get message count and if count is 1, get message info.

3231: IF (FND_API.To_Boolean(p_commit)) THEN
3232: COMMIT WORK;
3233: END IF;
3234:
3235: -- Standard call to get message count and if count is 1, get message info.
3236: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3237: p_data => x_msg_data,
3238: p_encoded => 'F');
3239:

Line 3309: -- Standard Start of API savepoint

3305: l_master_root_section_id NUMBER;
3306:
3307: BEGIN
3308:
3309: -- Standard Start of API savepoint
3310: SAVEPOINT ASSOCIATE_ROOT_SCT_TO_MSITE;
3311:
3312: -- Standard call to check for call compatibility.
3313: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 3312: -- Standard call to check for call compatibility.

3308:
3309: -- Standard Start of API savepoint
3310: SAVEPOINT ASSOCIATE_ROOT_SCT_TO_MSITE;
3311:
3312: -- Standard call to check for call compatibility.
3313: IF NOT FND_API.Compatible_API_Call(l_api_version,
3314: p_api_version,
3315: l_api_name,
3316: G_PKG_NAME)

Line 3397: -- Standard check of p_commit.

3393:
3394: --
3395: -- End of main API body.
3396:
3397: -- Standard check of p_commit.
3398: IF (FND_API.To_Boolean(p_commit)) THEN
3399: COMMIT WORK;
3400: END IF;
3401:

Line 3402: -- Standard call to get message count and if count is 1, get message info.

3398: IF (FND_API.To_Boolean(p_commit)) THEN
3399: COMMIT WORK;
3400: END IF;
3401:
3402: -- Standard call to get message count and if count is 1, get message info.
3403: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3404: p_data => x_msg_data,
3405: p_encoded => 'F');
3406:

Line 3478: -- Standard Start of API savepoint

3474: l_out_error_tbl INV_ITEM_GRP.ERROR_TBL_TYPE;
3475:
3476: BEGIN
3477:
3478: -- Standard Start of API savepoint
3479: SAVEPOINT UPDATE_HIERARCHY_ITEM_PVT;
3480:
3481: -- Standard call to check for call compatibility.
3482: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 3481: -- Standard call to check for call compatibility.

3477:
3478: -- Standard Start of API savepoint
3479: SAVEPOINT UPDATE_HIERARCHY_ITEM_PVT;
3480:
3481: -- Standard call to check for call compatibility.
3482: IF NOT FND_API.Compatible_API_Call(l_api_version,
3483: p_api_version,
3484: l_api_name,
3485: G_PKG_NAME)

Line 3591: -- Standard check of p_commit.

3587:
3588: --
3589: -- End of main API body.
3590:
3591: -- Standard check of p_commit.
3592: IF (FND_API.To_Boolean(p_commit)) THEN
3593: COMMIT WORK;
3594: END IF;
3595:

Line 3596: -- Standard call to get message count and if count is 1, get message info.

3592: IF (FND_API.To_Boolean(p_commit)) THEN
3593: COMMIT WORK;
3594: END IF;
3595:
3596: -- Standard call to get message count and if count is 1, get message info.
3597: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3598: p_data => x_msg_data,
3599: p_encoded => 'F');
3600:

Line 3694: -- Standard Start of API savepoint

3690: AND mini_site_id <> l_c_master_mini_site_id);
3691:
3692: BEGIN
3693:
3694: -- Standard Start of API savepoint
3695: SAVEPOINT ASSOCIATE_MSITES_TO_ITEM_PVT;
3696:
3697: -- Standard call to check for call compatibility.
3698: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 3697: -- Standard call to check for call compatibility.

3693:
3694: -- Standard Start of API savepoint
3695: SAVEPOINT ASSOCIATE_MSITES_TO_ITEM_PVT;
3696:
3697: -- Standard call to check for call compatibility.
3698: IF NOT FND_API.Compatible_API_Call(l_api_version,
3699: p_api_version,
3700: l_api_name,
3701: G_PKG_NAME)

Line 3774: -- Standard check of p_commit.

3770:
3771: --
3772: -- End of main API body.
3773:
3774: -- Standard check of p_commit.
3775: IF (FND_API.To_Boolean(p_commit)) THEN
3776: COMMIT WORK;
3777: END IF;
3778:

Line 3779: -- Standard call to get message count and if count is 1, get message info.

3775: IF (FND_API.To_Boolean(p_commit)) THEN
3776: COMMIT WORK;
3777: END IF;
3778:
3779: -- Standard call to get message count and if count is 1, get message info.
3780: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3781: p_data => x_msg_data,
3782: p_encoded => 'F');
3783:

Line 3858: -- Standard Start of API savepoint

3854: WHERE mini_site_section_section_id = l_c_msite_section_section_id;
3855:
3856: BEGIN
3857:
3858: -- Standard Start of API savepoint
3859: SAVEPOINT UPDATE_DELETE_SCT_SCTS_PVT;
3860:
3861: -- Standard call to check for call compatibility.
3862: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 3861: -- Standard call to check for call compatibility.

3857:
3858: -- Standard Start of API savepoint
3859: SAVEPOINT UPDATE_DELETE_SCT_SCTS_PVT;
3860:
3861: -- Standard call to check for call compatibility.
3862: IF NOT FND_API.Compatible_API_Call(l_api_version,
3863: p_api_version,
3864: l_api_name,
3865: G_PKG_NAME)

Line 3948: -- Standard check of p_commit.

3944:
3945: --
3946: -- End of main API body.
3947:
3948: -- Standard check of p_commit.
3949: IF (FND_API.To_Boolean(p_commit)) THEN
3950: COMMIT WORK;
3951: END IF;
3952:

Line 3953: -- Standard call to get message count and if count is 1, get message info.

3949: IF (FND_API.To_Boolean(p_commit)) THEN
3950: COMMIT WORK;
3951: END IF;
3952:
3953: -- Standard call to get message count and if count is 1, get message info.
3954: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3955: p_data => x_msg_data,
3956: p_encoded => 'F');
3957:

Line 4187: -- Standard Start of API savepoint

4183: AND mini_site_id = l_c_master_mini_site_id;
4184:
4185: BEGIN
4186:
4187: -- Standard Start of API savepoint
4188: SAVEPOINT CUT_AND_PASTE_SECTION_PVT;
4189:
4190: -- Standard call to check for call compatibility.
4191: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 4190: -- Standard call to check for call compatibility.

4186:
4187: -- Standard Start of API savepoint
4188: SAVEPOINT CUT_AND_PASTE_SECTION_PVT;
4189:
4190: -- Standard call to check for call compatibility.
4191: IF NOT FND_API.Compatible_API_Call(l_api_version,
4192: p_api_version,
4193: l_api_name,
4194: G_PKG_NAME)

Line 4412: -- Standard check of p_commit.

4408: END IF;
4409:
4410: END LOOP; -- end loop r33
4411:
4412: -- Standard check of p_commit.
4413: IF (FND_API.To_Boolean(p_commit)) THEN
4414: COMMIT WORK;
4415: END IF;
4416:

Line 4417: -- Standard call to get message count and if count is 1, get message info.

4413: IF (FND_API.To_Boolean(p_commit)) THEN
4414: COMMIT WORK;
4415: END IF;
4416:
4417: -- Standard call to get message count and if count is 1, get message info.
4418: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4419: p_data => x_msg_data,
4420: p_encoded => 'F');
4421:

Line 4625: -- Standard Start of API savepoint

4621: from ibe_dsp_sections_tl where section_id=l_c_section_id;
4622:
4623: BEGIN
4624:
4625: -- Standard Start of API savepoint
4626: SAVEPOINT COPY_SECTION_REF_CONTENT_PVT;
4627: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
4628: -- Standard call to check for call compatibility.
4629: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 4628: -- Standard call to check for call compatibility.

4624:
4625: -- Standard Start of API savepoint
4626: SAVEPOINT COPY_SECTION_REF_CONTENT_PVT;
4627: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
4628: -- Standard call to check for call compatibility.
4629: IF NOT FND_API.Compatible_API_Call(l_api_version,
4630: p_api_version,
4631: l_api_name,
4632: G_PKG_NAME)

Line 5321: -- Standard check of p_commit.

5317: -- adding commit 11/20/03 ab :to avoid time out in case large number of sections duplicated
5318: COMMIT;
5319: END LOOP;
5320:
5321: -- Standard check of p_commit.
5322: --commented the following as we are already doing commit for each duplicated section
5323: --IF (FND_API.To_Boolean(p_commit)) THEN
5324: -- COMMIT WORK;
5325: --END IF;

Line 5327: -- Standard call to get message count and if count is 1, get message info.

5323: --IF (FND_API.To_Boolean(p_commit)) THEN
5324: -- COMMIT WORK;
5325: --END IF;
5326:
5327: -- Standard call to get message count and if count is 1, get message info.
5328: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5329: p_data => x_msg_data,
5330: p_encoded => 'F');
5331:

Line 6021: -- Standard check of p_commit.

6017: END LOOP;
6018: END IF;
6019: --
6020: -- End of main API body.
6021: -- Standard check of p_commit.
6022: IF (FND_API.To_Boolean(p_commit)) THEN
6023: COMMIT;
6024: END IF;
6025: -- Standard call to get message count and if count is 1, get message info.

Line 6025: -- Standard call to get message count and if count is 1, get message info.

6021: -- Standard check of p_commit.
6022: IF (FND_API.To_Boolean(p_commit)) THEN
6023: COMMIT;
6024: END IF;
6025: -- Standard call to get message count and if count is 1, get message info.
6026: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
6027: p_data => x_msg_data,
6028: p_encoded => 'F');
6029: EXCEPTION

Line 6283: -- No cascading for standard layout

6279: END LOOP;
6280: END IF;
6281: ELSIF (l_new_layout_type = 'F') THEN
6282: IF (l_org_layout_type = 'C') THEN
6283: -- No cascading for standard layout
6284: l_org_deliverable_id := null;
6285: -- Set the section deliverable_id to old processing page
6286: UPDATE ibe_dsp_sections_b
6287: SET deliverable_id = l_org_deliverable_id

Line 6296: -- Standard check of p_commit.

6292: IBE_UTIL.debug('After Calling Update_Hierarchy_Layout_Map');
6293: END IF;
6294: --
6295: -- End of main API body.
6296: -- Standard check of p_commit.
6297: IF (FND_API.To_Boolean(p_commit)) THEN
6298: COMMIT WORK;
6299: END IF;
6300: -- Standard call to get message count and if count is 1, get message info.

Line 6300: -- Standard call to get message count and if count is 1, get message info.

6296: -- Standard check of p_commit.
6297: IF (FND_API.To_Boolean(p_commit)) THEN
6298: COMMIT WORK;
6299: END IF;
6300: -- Standard call to get message count and if count is 1, get message info.
6301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
6302: p_data => x_msg_data,
6303: p_encoded => 'F');
6304: EXCEPTION

Line 6526: -- Standard check of p_commit.

6522: END IF;
6523:
6524: --
6525: -- End of main API body.
6526: -- Standard check of p_commit.
6527: IF (FND_API.To_Boolean(p_commit)) THEN
6528: COMMIT;
6529: END IF;
6530: -- Standard call to get message count and if count is 1, get message info.

Line 6530: -- Standard call to get message count and if count is 1, get message info.

6526: -- Standard check of p_commit.
6527: IF (FND_API.To_Boolean(p_commit)) THEN
6528: COMMIT;
6529: END IF;
6530: -- Standard call to get message count and if count is 1, get message info.
6531: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
6532: p_data => x_msg_data,
6533: p_encoded => 'F');
6534: EXCEPTION

Line 6592: -- Standard Start of API savepoint

6588: l_duplicate_association_status VARCHAR2(1);
6589: l_debug VARCHAR2(1);
6590: BEGIN
6591:
6592: -- Standard Start of API savepoint
6593: SAVEPOINT ASSOCIATE_ITEMS_TO_SECTION_PVT;
6594:
6595: -- Standard call to check for call compatibility.
6596: IF NOT FND_API.Compatible_API_Call(l_api_version,

Line 6595: -- Standard call to check for call compatibility.

6591:
6592: -- Standard Start of API savepoint
6593: SAVEPOINT ASSOCIATE_ITEMS_TO_SECTION_PVT;
6594:
6595: -- Standard call to check for call compatibility.
6596: IF NOT FND_API.Compatible_API_Call(l_api_version,
6597: p_api_version,
6598: l_api_name,
6599: G_PKG_NAME)

Line 6698: -- Standard check of p_commit.

6694: end if;
6695: -- set the x_return status to the API overall status
6696: x_return_status:= l_overall_return_status;
6697: -- End of main API body.
6698: -- Standard check of p_commit.
6699: IF (FND_API.To_Boolean(p_commit)) THEN
6700: COMMIT WORK;
6701: END IF;
6702:

Line 6703: -- Standard call to get message count and if count is 1, get message info.

6699: IF (FND_API.To_Boolean(p_commit)) THEN
6700: COMMIT WORK;
6701: END IF;
6702:
6703: -- Standard call to get message count and if count is 1, get message info.
6704: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
6705: p_data => x_msg_data,
6706: p_encoded => 'F');
6707: EXCEPTION