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.AHL_MC_ITEMGROUP_PVT dependencies on FND_LOG

Line 72: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

68: IF (check_priority_dup_exists%FOUND)
69: THEN
70: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_NON_UNIQUE');
71: FND_MSG_PUB.ADD;
72: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
73: THEN
74: fnd_log.message
75: (
76: fnd_log.level_exception,

Line 74: fnd_log.message

70: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_NON_UNIQUE');
71: FND_MSG_PUB.ADD;
72: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
73: THEN
74: fnd_log.message
75: (
76: fnd_log.level_exception,
77: 'ahl.plsql.'||G_PKG_NAME||'.Validate_priority',
78: true

Line 76: fnd_log.level_exception,

72: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
73: THEN
74: fnd_log.message
75: (
76: fnd_log.level_exception,
77: 'ahl.plsql.'||G_PKG_NAME||'.Validate_priority',
78: true
79: );
80: END IF;

Line 113: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

109: IF (check_revision_dup_exists%FOUND)
110: THEN
111: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_REVISION_NON_UNIQUE');
112: FND_MSG_PUB.ADD;
113: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
114: THEN
115: fnd_log.message
116: (
117: fnd_log.level_exception,

Line 115: fnd_log.message

111: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_REVISION_NON_UNIQUE');
112: FND_MSG_PUB.ADD;
113: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
114: THEN
115: fnd_log.message
116: (
117: fnd_log.level_exception,
118: 'ahl.plsql.'||G_PKG_NAME||'.Validate_IG_revision',
119: true

Line 117: fnd_log.level_exception,

113: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
114: THEN
115: fnd_log.message
116: (
117: fnd_log.level_exception,
118: 'ahl.plsql.'||G_PKG_NAME||'.Validate_IG_revision',
119: true
120: );
121: END IF;

Line 165: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

161: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
162:
163: BEGIN
164:
165: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
166: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API...p_assoc_id => '||p_assoc_id);
167: END IF;
168:
169: OPEN c_get_det(p_assoc_id);

Line 166: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API...p_assoc_id => '||p_assoc_id);

162:
163: BEGIN
164:
165: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
166: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API...p_assoc_id => '||p_assoc_id);
167: END IF;
168:
169: OPEN c_get_det(p_assoc_id);
170: FETCH c_get_det INTO l_get_det;

Line 173: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

169: OPEN c_get_det(p_assoc_id);
170: FETCH c_get_det INTO l_get_det;
171:
172: IF (c_get_det%FOUND) THEN
173: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
174: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Item details found.');
175: END IF;
176:
177: x_item_group_id := l_get_det.item_group_id;

Line 174: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Item details found.');

170: FETCH c_get_det INTO l_get_det;
171:
172: IF (c_get_det%FOUND) THEN
173: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
174: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Item details found.');
175: END IF;
176:
177: x_item_group_id := l_get_det.item_group_id;
178: x_inventory_item_id := l_get_det.inventory_item_id;

Line 184: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

180: x_concatenated_segments := l_get_det.concatenated_segments;
181: x_revision := l_get_det.revision;
182: ELSE
183:
184: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
185: FND_LOG.string(FND_LOG.level_statement,l_full_name,'The item is newly added in the revision');
186: END IF;
187:
188: NULL;

Line 185: FND_LOG.string(FND_LOG.level_statement,l_full_name,'The item is newly added in the revision');

181: x_revision := l_get_det.revision;
182: ELSE
183:
184: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
185: FND_LOG.string(FND_LOG.level_statement,l_full_name,'The item is newly added in the revision');
186: END IF;
187:
188: NULL;
189: END IF;

Line 193: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

189: END IF;
190:
191: CLOSE c_get_det;
192:
193: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
194: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
195: END IF;
196:
197: END get_Item_detail;

Line 194: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');

190:
191: CLOSE c_get_det;
192:
193: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
194: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
195: END IF;
196:
197: END get_Item_detail;
198:

Line 232: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

228: l_interchange_type_tbl t_item_det;
229:
230: BEGIN
231:
232: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
233: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
234: END IF;
235:
236: -- SATHAPLI::Bug# 5566764 fix

Line 233: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');

229:
230: BEGIN
231:
232: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
233: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
234: END IF;
235:
236: -- SATHAPLI::Bug# 5566764 fix
237: -- Initialize API return status to success

Line 273: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

269: WHEN NO_DATA_FOUND THEN
270: RETURN;
271: END;
272:
273: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
274: FND_LOG.string(FND_LOG.level_statement,l_full_name,'After the BEGIN-END block.');
275: END IF;
276:
277: IF (l_item_group_id_tbl.COUNT > 0) THEN

Line 274: FND_LOG.string(FND_LOG.level_statement,l_full_name,'After the BEGIN-END block.');

270: RETURN;
271: END;
272:
273: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
274: FND_LOG.string(FND_LOG.level_statement,l_full_name,'After the BEGIN-END block.');
275: END IF;
276:
277: IF (l_item_group_id_tbl.COUNT > 0) THEN
278: FOR i IN l_item_group_id_tbl.FIRST..l_item_group_id_tbl.LAST

Line 288: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

284: l_invalid_item_instance_tbl(i).revision := l_revision_tbl(i);
285: l_invalid_item_instance_tbl(i).interchange_type := l_interchange_type_tbl(i);
286: END LOOP;
287:
288: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
289: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating '||l_item_group_id_tbl.COUNT||
290: ' items in the IG for update.');
291: END IF;
292:

Line 289: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating '||l_item_group_id_tbl.COUNT||

285: l_invalid_item_instance_tbl(i).interchange_type := l_interchange_type_tbl(i);
286: END LOOP;
287:
288: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
289: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating '||l_item_group_id_tbl.COUNT||
290: ' items in the IG for update.');
291: END IF;
292:
293: -- Call UC procedure to check if active Units are getting affected

Line 306: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

302: x_msg_data => x_msg_data
303: );
304: END IF;
305:
306: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
307: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
308: END IF;
309:
310: END validate_IG_update;

Line 307: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');

303: );
304: END IF;
305:
306: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
307: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
308: END IF;
309:
310: END validate_IG_update;
311:

Line 947: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

943: OR ((l_x_item_assoc_rec.inventory_org_id IS NOT NULL) AND
944: (l_x_item_assoc_rec.inventory_org_id <> l_item_assoc_rec.inventory_org_id))
945: THEN
946: CLOSE Item_assoc_csr;
947: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
948: THEN
949: l_item_key := 'Inventory Item Id '||to_char(l_x_item_assoc_rec.inventory_item_id)||' - '||to_Char(l_item_assoc_rec.inventory_item_id);
950: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
951: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);

Line 950: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

946: CLOSE Item_assoc_csr;
947: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
948: THEN
949: l_item_key := 'Inventory Item Id '||to_char(l_x_item_assoc_rec.inventory_item_id)||' - '||to_Char(l_item_assoc_rec.inventory_item_id);
950: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
951: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
952: l_item_key := 'Inventory Org Id '||to_Char(l_x_item_assoc_rec.inventory_org_id)||' - '||to_char(l_item_assoc_rec.inventory_org_id);
953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
954: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);

Line 953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

949: l_item_key := 'Inventory Item Id '||to_char(l_x_item_assoc_rec.inventory_item_id)||' - '||to_Char(l_item_assoc_rec.inventory_item_id);
950: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
951: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
952: l_item_key := 'Inventory Org Id '||to_Char(l_x_item_assoc_rec.inventory_org_id)||' - '||to_char(l_item_assoc_rec.inventory_org_id);
953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
954: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
955: END IF;
956:
957: FND_MESSAGE.Set_Name('AHL','AHL_COM_KEY_NOUPDATE');

Line 1775: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1771:
1772: -- Initialize API return status to success
1773: x_return_status := FND_API.G_RET_STS_SUCCESS;
1774:
1775: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1776: THEN
1777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1778: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Inside Create_Item_group');
1779: END IF;

Line 1777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1773: x_return_status := FND_API.G_RET_STS_SUCCESS;
1774:
1775: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1776: THEN
1777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1778: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Inside Create_Item_group');
1779: END IF;
1780:
1781: --dbms_output.put_line('Inside Create_Item_group');

Line 1798: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1794: -- Added by skpathak for bug-7437855 on 18-NOV-2008 - Clear l_inventory_list before using.
1795: l_inventory_list.DELETE;
1796:
1797: FOR i IN p_x_items_tbl.FIRST..p_x_items_tbl.LAST LOOP
1798: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1799: THEN
1800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1801: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before validating Item Group Associations');
1802: END IF;

Line 1800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1796:
1797: FOR i IN p_x_items_tbl.FIRST..p_x_items_tbl.LAST LOOP
1798: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1799: THEN
1800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1801: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before validating Item Group Associations');
1802: END IF;
1803:
1804: Validate_Item_Assoc(p_name => p_x_item_group_rec.name,

Line 1813: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1809:
1810: END LOOP;
1811: END IF; /* for count > 0 */
1812:
1813: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1814: THEN
1815: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1816: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After validating Item Group Associations');
1817: END IF;

Line 1815: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1811: END IF; /* for count > 0 */
1812:
1813: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1814: THEN
1815: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1816: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After validating Item Group Associations');
1817: END IF;
1818:
1819:

Line 1826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1822: IF x_msg_count > 0 THEN
1823: RAISE FND_API.G_EXC_ERROR;
1824: END IF;
1825:
1826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1827: THEN
1828: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1829: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before calling Insert_Item_group');
1830: END IF;

Line 1828: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1824: END IF;
1825:
1826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1827: THEN
1828: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1829: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before calling Insert_Item_group');
1830: END IF;
1831:
1832: -- Insert into ahl_item_groups_b and TL.

Line 1835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1831:
1832: -- Insert into ahl_item_groups_b and TL.
1833: Insert_Item_group(p_x_item_group_rec);
1834:
1835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1836: THEN
1837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1838: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After calling Insert_Item_group');
1839: END IF;

Line 1837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1833: Insert_Item_group(p_x_item_group_rec);
1834:
1835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1836: THEN
1837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1838: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After calling Insert_Item_group');
1839: END IF;
1840:
1841:

Line 1844: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1840:
1841:
1842: l_item_group_id := p_x_item_group_rec.item_group_id;
1843:
1844: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1845: THEN
1846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1847: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before loop of Item Association');
1848: END IF;

Line 1846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1842: l_item_group_id := p_x_item_group_rec.item_group_id;
1843:
1844: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1845: THEN
1846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1847: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before loop of Item Association');
1848: END IF;
1849:
1850:

Line 1859: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1855: Create_Association(p_x_items_tbl(i));
1856: END LOOP;
1857: END IF; /* count > 0 */
1858:
1859: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1860: THEN
1861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1862: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After loop of Item Association');
1863: END IF;

Line 1861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1857: END IF; /* count > 0 */
1858:
1859: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1860: THEN
1861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1862: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'After loop of Item Association');
1863: END IF;
1864:
1865: validate_priority(l_item_group_id);

Line 1867: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1863: END IF;
1864:
1865: validate_priority(l_item_group_id);
1866:
1867: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1868: THEN
1869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1870: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'End of create_item_group private');
1871: END IF;

Line 1869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1865: validate_priority(l_item_group_id);
1866:
1867: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1868: THEN
1869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1870: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'End of create_item_group private');
1871: END IF;
1872:
1873:

Line 1887: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1883: Rollback to Create_Item_group_pvt;
1884: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1885: p_data => x_msg_data,
1886: p_encoded => fnd_api.g_false);
1887: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1888: THEN
1889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1890: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Error in create_item_group private');
1891: END IF;

Line 1889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1885: p_data => x_msg_data,
1886: p_encoded => fnd_api.g_false);
1887: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1888: THEN
1889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1890: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Error in create_item_group private');
1891: END IF;
1892:
1893:

Line 1902: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1898: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1899: p_data => x_msg_data,
1900: p_encoded => fnd_api.g_false);
1901: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
1902: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1903: THEN
1904: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1905: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Unexpected error in create_item_group private');
1906: END IF;

Line 1904: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1900: p_encoded => fnd_api.g_false);
1901: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
1902: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1903: THEN
1904: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1905: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Unexpected error in create_item_group private');
1906: END IF;
1907:
1908:

Line 1922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1918: p_data => x_msg_data,
1919: p_encoded => fnd_api.g_false);
1920: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
1921:
1922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1923: THEN
1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1925: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Unknown error in create_item_group private');
1926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1920: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
1921:
1922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1923: THEN
1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1925: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Unknown error in create_item_group private');
1926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1927: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', SQLERRM);
1928: END IF;

Line 1926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1923: THEN
1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1925: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Unknown error in create_item_group private');
1926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1927: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', SQLERRM);
1928: END IF;
1929:
1930: END Create_Item_group;

Line 2034: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2030:
2031: -- Initialize API return status to success
2032: x_return_status := FND_API.G_RET_STS_SUCCESS;
2033:
2034: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2036: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Begin of Modify_Item_group');
2037: END IF;
2038:

Line 2035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2031: -- Initialize API return status to success
2032: x_return_status := FND_API.G_RET_STS_SUCCESS;
2033:
2034: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2036: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Begin of Modify_Item_group');
2037: END IF;
2038:
2039: -- Validate Item Group record.

Line 2117: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2113: END IF;
2114:
2115: END IF;
2116:
2117: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2118: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2119: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Loop to validate Item Association');
2120: END IF;
2121:

Line 2118: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2114:
2115: END IF;
2116:
2117: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2118: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2119: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Loop to validate Item Association');
2120: END IF;
2121:
2122: -- Validate Item Assoc records.

Line 2150: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2146:
2147: END LOOP;
2148: END IF; /* count > 0 */
2149:
2150: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2151: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2152: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2153: END IF;
2154:

Line 2151: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2147: END LOOP;
2148: END IF; /* count > 0 */
2149:
2150: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2151: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2152: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2153: END IF;
2154:
2155: -- Check Error Message stack.

Line 2273: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2269: l_item_group_rec.SOURCE_LANG := NULL;
2270: END IF;
2271: */
2272:
2273: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2274: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2275: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Before calling Item Group Table Handler');
2276: END IF;
2277:

Line 2274: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2270: END IF;
2271: */
2272:
2273: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2274: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2275: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Before calling Item Group Table Handler');
2276: END IF;
2277:
2278: AHL_ITEM_GROUPS_PKG.UPDATE_ROW(

Line 2306: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2302: X_LAST_UPDATE_DATE => sysdate,
2303: X_LAST_UPDATED_BY => fnd_global.USER_ID,
2304: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
2305:
2306: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2307: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2308: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'After Table Handler');
2309: END IF;
2310:

Line 2307: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2303: X_LAST_UPDATED_BY => fnd_global.USER_ID,
2304: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
2305:
2306: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2307: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2308: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'After Table Handler');
2309: END IF;
2310:
2311:

Line 2315: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2311:
2312: END IF; /* update only if operation_flag set */
2313: -- End Updates for Item_Groups.
2314:
2315: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2316: FND_LOG.string(FND_LOG.level_statement,l_full_name,'l_old_item_group_rec.source_item_group_id => '||
2317: l_old_item_group_rec.source_item_group_id);
2318: END IF;
2319:

Line 2316: FND_LOG.string(FND_LOG.level_statement,l_full_name,'l_old_item_group_rec.source_item_group_id => '||

2312: END IF; /* update only if operation_flag set */
2313: -- End Updates for Item_Groups.
2314:
2315: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2316: FND_LOG.string(FND_LOG.level_statement,l_full_name,'l_old_item_group_rec.source_item_group_id => '||
2317: l_old_item_group_rec.source_item_group_id);
2318: END IF;
2319:
2320: -- SATHAPLI::Bug# 5566764 fix

Line 2344: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2340: END LOOP;
2341: END IF;
2342:
2343: IF (l_index > 1) THEN
2344: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2345: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating '||l_index||
2346: ' items in the IG for remove.');
2347: END IF;
2348:

Line 2345: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating '||l_index||

2341: END IF;
2342:
2343: IF (l_index > 1) THEN
2344: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2345: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating '||l_index||
2346: ' items in the IG for remove.');
2347: END IF;
2348:
2349: AHL_UTIL_UC_PKG.Check_Invalidate_Instance

Line 2369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2365: END IF;
2366:
2367: END IF; -- end of l_old_item_group_rec.source_item_group_id IS NOT NULL
2368:
2369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2371: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Item Association Loop');
2372: END IF;
2373:

Line 2370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2366:
2367: END IF; -- end of l_old_item_group_rec.source_item_group_id IS NOT NULL
2368:
2369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2371: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Item Association Loop');
2372: END IF;
2373:
2374: -- Process Item Associations table.

Line 2393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2389: END IF;
2390: END LOOP;
2391: END IF;
2392:
2393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2395: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2396: END IF;
2397:

Line 2394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2390: END LOOP;
2391: END IF;
2392:
2393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2395: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2396: END IF;
2397:
2398: -- The validation of the revision update will be done only for revisions

Line 2404: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2400:
2401: -- SATHAPLI::Bug# 4328454 fix
2402: -- Validate updation of interchange_type_code
2403: IF (l_update_flag = 'Y') THEN
2404: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2405: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Calling validate_IG_update.');
2406: END IF;
2407:
2408: validate_IG_update

Line 2405: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Calling validate_IG_update.');

2401: -- SATHAPLI::Bug# 4328454 fix
2402: -- Validate updation of interchange_type_code
2403: IF (l_update_flag = 'Y') THEN
2404: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2405: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Calling validate_IG_update.');
2406: END IF;
2407:
2408: validate_IG_update
2409: (

Line 2442: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2438: ( p_count => x_msg_count,
2439: p_data => x_msg_data,
2440: p_encoded => fnd_api.g_false);
2441:
2442: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2444: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group',
2445: 'End of Modify_Item_group...x_return_status => '||x_return_status);
2446: END IF;

Line 2443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2439: p_data => x_msg_data,
2440: p_encoded => fnd_api.g_false);
2441:
2442: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2444: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group',
2445: 'End of Modify_Item_group...x_return_status => '||x_return_status);
2446: END IF;
2447:

Line 2458: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2454: p_data => x_msg_data,
2455: p_encoded => fnd_api.g_false);
2456: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2457:
2458: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2459: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2460: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Error in Modify_Item_group');
2461: END IF;
2462:

Line 2459: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2455: p_encoded => fnd_api.g_false);
2456: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2457:
2458: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2459: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2460: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Error in Modify_Item_group');
2461: END IF;
2462:
2463:

Line 2471: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2467: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2468: p_data => x_msg_data,
2469: p_encoded => fnd_api.g_false);
2470: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2471: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2473: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unexpected error in Modify_Item_group');
2474: END IF;
2475:

Line 2472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2468: p_data => x_msg_data,
2469: p_encoded => fnd_api.g_false);
2470: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2471: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2473: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unexpected error in Modify_Item_group');
2474: END IF;
2475:
2476:

Line 2490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2486: p_data => x_msg_data,
2487: p_encoded => fnd_api.g_false);
2488: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2489:
2490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2492: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unknown Error in Modify_Item_group');
2493: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2494: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', SQLERRM);

Line 2491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2487: p_encoded => fnd_api.g_false);
2488: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2489:
2490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2492: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unknown Error in Modify_Item_group');
2493: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2494: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', SQLERRM);
2495: END IF;

Line 2493: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2489:
2490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2492: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unknown Error in Modify_Item_group');
2493: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2494: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', SQLERRM);
2495: END IF;
2496:
2497:

Line 2585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2581:
2582: -- Initialize API return status to success
2583: x_return_status := FND_API.G_RET_STS_SUCCESS;
2584:
2585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2586: THEN
2587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2588: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Begin of Remove_Item_group');
2589: END IF;

Line 2587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2583: x_return_status := FND_API.G_RET_STS_SUCCESS;
2584:
2585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2586: THEN
2587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2588: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Begin of Remove_Item_group');
2589: END IF;
2590:
2591:

Line 2674: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2670: );
2671:
2672: */
2673:
2674: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2675: THEN
2676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2677: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Deleting Item Group');
2678: END IF;

Line 2676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2672: */
2673:
2674: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2675: THEN
2676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2677: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Deleting Item Group');
2678: END IF;
2679:
2680: DELETE AHL_ITEM_ASSOCIATIONS_TL

Line 2696: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2692:
2693: ELSIF l_item_group_rec.status_code ='COMPLETE'
2694: THEN
2695:
2696: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2697: THEN
2698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2699: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Updating Item Group to Removed');
2700: END IF;

Line 2698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2694: THEN
2695:
2696: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2697: THEN
2698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2699: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Updating Item Group to Removed');
2700: END IF;
2701:
2702: Update Ahl_Item_groups_b

Line 2722: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2718: ( p_count => x_msg_count,
2719: p_data => x_msg_data,
2720: p_encoded => fnd_api.g_false);
2721:
2722: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2723: THEN
2724: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2725: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'End of Remove_Item_group');
2726: END IF;

Line 2724: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2720: p_encoded => fnd_api.g_false);
2721:
2722: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2723: THEN
2724: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2725: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'End of Remove_Item_group');
2726: END IF;
2727:
2728:

Line 2738: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2734: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2735: p_data => x_msg_data,
2736: p_encoded => fnd_api.g_false);
2737:
2738: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2739: THEN
2740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2741: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Error in Remove_Item_group');
2742: END IF;

Line 2740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2736: p_encoded => fnd_api.g_false);
2737:
2738: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2739: THEN
2740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2741: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Error in Remove_Item_group');
2742: END IF;
2743:
2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2750: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2746: Rollback to Remove_Item_group_pvt;
2747: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2748: p_data => x_msg_data,
2749: p_encoded => fnd_api.g_false);
2750: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2751: THEN
2752: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2753: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unexpected error in Remove_Item_group');
2754: END IF;

Line 2752: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2748: p_data => x_msg_data,
2749: p_encoded => fnd_api.g_false);
2750: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2751: THEN
2752: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2753: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unexpected error in Remove_Item_group');
2754: END IF;
2755:
2756:

Line 2768: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2764: END IF;
2765: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2766: p_data => x_msg_data,
2767: p_encoded => fnd_api.g_false);
2768: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2769: THEN
2770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2771: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');
2772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2766: p_data => x_msg_data,
2767: p_encoded => fnd_api.g_false);
2768: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2769: THEN
2770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2771: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');
2772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2773: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', SQLERRM);
2774: END IF;

Line 2772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2768: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2769: THEN
2770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2771: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');
2772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2773: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', SQLERRM);
2774: END IF;
2775:
2776:

Line 2899: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2895: -- Initialize API return status to success
2896:
2897: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2898:
2899: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2900: THEN
2901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2902: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Begin Initiate_Itemgroup_Appr');
2903: END IF;

Line 2901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2897: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2898:
2899: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2900: THEN
2901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2902: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Begin Initiate_Itemgroup_Appr');
2903: END IF;
2904:
2905:

Line 3005: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3001: RAISE FND_API.G_EXC_ERROR;
3002: END IF;
3003:
3004:
3005: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3006: THEN
3007: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3008: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'l_active flag is yes');
3009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 3007: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3003:
3004:
3005: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3006: THEN
3007: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3008: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'l_active flag is yes');
3009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3010: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Updating Item group');
3011: END IF;

Line 3009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3005: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3006: THEN
3007: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3008: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'l_active flag is yes');
3009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3010: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Updating Item group');
3011: END IF;
3012:
3013: Update AHL_ITEM_GROUPS_B

Line 3030: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3026: IF l_ACTIVE='Y'
3027: THEN
3028:
3029:
3030: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3031: THEN
3032: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3033: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_generic_aprv_pvt.start_wf_process');
3034: END IF;

Line 3032: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3028:
3029:
3030: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3031: THEN
3032: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3033: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_generic_aprv_pvt.start_wf_process');
3034: END IF;
3035:
3036: AHL_GENERIC_APRV_PVT.START_WF_PROCESS(

Line 3050: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3046: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
3047: P_ITEM_TYPE =>'AHLGAPP');
3048: ELSE
3049:
3050: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3051: THEN
3052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3053: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_mc_itemgroup_pvt.Approve_ItemGroups');
3054: END IF;

Line 3052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3048: ELSE
3049:
3050: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3051: THEN
3052: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3053: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_mc_itemgroup_pvt.Approve_ItemGroups');
3054: END IF;
3055:
3056: AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups

Line 3094: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3090: ( p_count => x_msg_count,
3091: p_data => x_msg_data,
3092: p_encoded => fnd_api.g_false);
3093:
3094: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3095: THEN
3096: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3097: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'End of Initiate_Itemgroup_Appr');
3098: END IF;

Line 3096: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3092: p_encoded => fnd_api.g_false);
3093:
3094: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3095: THEN
3096: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3097: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'End of Initiate_Itemgroup_Appr');
3098: END IF;
3099:
3100:

Line 3108: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3104: Rollback to Initiate_Itemgroup_Appr;
3105: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3106: p_data => x_msg_data,
3107: p_encoded => fnd_api.g_false);
3108: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3109: THEN
3110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3111: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Error in Initiate_Itemgroup_Appr');
3112: END IF;

Line 3110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3106: p_data => x_msg_data,
3107: p_encoded => fnd_api.g_false);
3108: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3109: THEN
3110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3111: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Error in Initiate_Itemgroup_Appr');
3112: END IF;
3113:
3114:

Line 3122: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3118: Rollback to Initiate_Itemgroup_Appr;
3119: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3120: p_data => x_msg_data,
3121: p_encoded => fnd_api.g_false);
3122: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3123: THEN
3124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3125: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unexpected Error in Initiate_Itemgroup_Appr');
3126: END IF;

Line 3124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3120: p_data => x_msg_data,
3121: p_encoded => fnd_api.g_false);
3122: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3123: THEN
3124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3125: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unexpected Error in Initiate_Itemgroup_Appr');
3126: END IF;
3127:
3128:

Line 3141: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3137: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3138: p_data => x_msg_data,
3139: p_encoded => fnd_api.g_false);
3140:
3141: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3142: THEN
3143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3144: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unknown Error in Initiate_Itemgroup_Appr');
3145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 3143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3139: p_encoded => fnd_api.g_false);
3140:
3141: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3142: THEN
3143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3144: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unknown Error in Initiate_Itemgroup_Appr');
3145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3146: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', SQLERRM);
3147: END IF;

Line 3145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3141: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3142: THEN
3143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3144: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unknown Error in Initiate_Itemgroup_Appr');
3145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3146: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', SQLERRM);
3147: END IF;
3148:
3149: END Initiate_Itemgroup_Appr;

Line 3296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3292: -- Initialize API return status to success
3293:
3294: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3295:
3296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3297: THEN
3298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3299: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Begin of Create_ItemGroup_Revision');
3300: END IF;

Line 3298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3294: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3295:
3296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3297: THEN
3298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3299: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Begin of Create_ItemGroup_Revision');
3300: END IF;
3301:
3302:

Line 3360: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3356:
3357:
3358: -- Inserting a new Revision in the Header Table Using table Handler
3359:
3360: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3361: THEN
3362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3363: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Calling Table handler');
3364: END IF;

Line 3362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3358: -- Inserting a new Revision in the Header Table Using table Handler
3359:
3360: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3361: THEN
3362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3363: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Calling Table handler');
3364: END IF;
3365:
3366:

Line 3413: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3409: last_update_login = l_last_update_login
3410: WHERE relationship_id = item_group_rec.relationship_id and
3411: trunc(nvl(active_end_date, sysdate + 1)) > trunc(sysdate);
3412:
3413: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3414: THEN
3415: FND_LOG.STRING
3416: (
3417: FND_LOG.LEVEL_PROCEDURE,

Line 3415: FND_LOG.STRING

3411: trunc(nvl(active_end_date, sysdate + 1)) > trunc(sysdate);
3412:
3413: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3414: THEN
3415: FND_LOG.STRING
3416: (
3417: FND_LOG.LEVEL_PROCEDURE,
3418: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',
3419: 'Updated MC position '||item_group_rec.relationship_id||' with temp_item_group_id '||x_itemgroup_id

Line 3417: FND_LOG.LEVEL_PROCEDURE,

3413: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3414: THEN
3415: FND_LOG.STRING
3416: (
3417: FND_LOG.LEVEL_PROCEDURE,
3418: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',
3419: 'Updated MC position '||item_group_rec.relationship_id||' with temp_item_group_id '||x_itemgroup_id
3420: );
3421: END IF;

Line 3425: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3421: END IF;
3422: END LOOP;
3423: -- TAMAL -- IG Amendments --
3424:
3425: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3426: THEN
3427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3428: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Loop to create Item Association');
3429: END IF;

Line 3427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3423: -- TAMAL -- IG Amendments --
3424:
3425: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3426: THEN
3427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3428: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Loop to create Item Association');
3429: END IF;
3430:
3431: FOR I IN get_itemgroup_assos_det(p_source_ItemGroup_id)

Line 3479: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3475: x_last_update_login => l_last_update_login
3476: );
3477: END LOOP;
3478:
3479: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3480: THEN
3481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3482: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Loop');
3483: END IF;

Line 3481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3477: END LOOP;
3478:
3479: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3480: THEN
3481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3482: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Loop');
3483: END IF;
3484:
3485: -- Standard check of p_commit

Line 3490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3486: IF FND_API.TO_BOOLEAN(p_commit) THEN
3487: COMMIT WORK;
3488: END IF;
3489:
3490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3491: THEN
3492: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3493: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Create_ItemGroup_Revision');
3494: END IF;

Line 3492: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3488: END IF;
3489:
3490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3491: THEN
3492: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3493: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Create_ItemGroup_Revision');
3494: END IF;
3495:
3496:

Line 3505: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3501: Rollback to Create_ItemGroup_Revision;
3502: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3503: p_data => x_msg_data,
3504: p_encoded => fnd_api.g_false);
3505: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3506: THEN
3507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3508: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Error in Create_ItemGroup_Revision');
3509: END IF;

Line 3507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3503: p_data => x_msg_data,
3504: p_encoded => fnd_api.g_false);
3505: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3506: THEN
3507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3508: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Error in Create_ItemGroup_Revision');
3509: END IF;
3510:
3511:

Line 3518: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3514: Rollback to Create_ItemGroup_Revision;
3515: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3516: p_data => x_msg_data,
3517: p_encoded => fnd_api.g_false);
3518: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3519: THEN
3520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3521: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unecpected Error in Create_ItemGroup_Revision');
3522: END IF;

Line 3520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3516: p_data => x_msg_data,
3517: p_encoded => fnd_api.g_false);
3518: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3519: THEN
3520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3521: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unecpected Error in Create_ItemGroup_Revision');
3522: END IF;
3523:
3524:

Line 3536: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3532: END IF;
3533: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3534: p_data => x_msg_data,
3535: p_encoded => fnd_api.g_false);
3536: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3537: THEN
3538: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3539: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');
3540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 3538: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3534: p_data => x_msg_data,
3535: p_encoded => fnd_api.g_false);
3536: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3537: THEN
3538: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3539: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');
3540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3541: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',SQLERRM );
3542:

Line 3540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3536: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3537: THEN
3538: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3539: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');
3540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3541: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',SQLERRM );
3542:
3543: END IF;
3544:

Line 3612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3608: from ahl_item_groups_b_h
3609: where ITEM_GROUP_ID = p_ItemGroups_id;
3610:
3611:
3612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3613: THEN
3614: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3615: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting into History Tables');
3616: END IF;

Line 3614: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3610:
3611:
3612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3613: THEN
3614: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3615: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting into History Tables');
3616: END IF;
3617:
3618:

Line 3717: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3713: WHERE item_group_id = p_ItemGroups_id;
3714:
3715:
3716:
3717: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3718: THEN
3719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3720: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting Item Association into history table Start of Loop');
3721: END IF;

Line 3719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3715:
3716:
3717: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3718: THEN
3719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3720: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting Item Association into history table Start of Loop');
3721: END IF;
3722:
3723:

Line 3771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3767: X_LAST_UPDATE_LOGIN => l_item_assos_det.LAST_UPDATE_LOGIN );
3768:
3769: END LOOP;
3770:
3771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3772: THEN
3773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3774: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Loop');
3775: END IF;

Line 3773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3769: END LOOP;
3770:
3771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3772: THEN
3773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3774: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Loop');
3775: END IF;
3776:
3777:

Line 3920: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3916: -- Initialize API return status to success
3917:
3918: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3919:
3920: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3921: THEN
3922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3923: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Begin of Approve_ItemGroups');
3924: END IF;

Line 3922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3918: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3919:
3920: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3921: THEN
3922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3923: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Begin of Approve_ItemGroups');
3924: END IF;
3925:
3926:

Line 3969: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3965:
3966:
3967: IF l_itemgroup_det.Source_Item_group_id IS NULL THEN
3968:
3969: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3971: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item group id is null');
3972: END IF;
3973:

Line 3970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3966:
3967: IF l_itemgroup_det.Source_Item_group_id IS NULL THEN
3968:
3969: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3971: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item group id is null');
3972: END IF;
3973:
3974: update ahl_item_groups_b

Line 3993: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3989:
3990: ELSE
3991:
3992:
3993: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3994: THEN
3995: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3996: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item Group id is not null');
3997: END IF;

Line 3995: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3991:
3992:
3993: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3994: THEN
3995: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3996: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item Group id is not null');
3997: END IF;
3998:
3999: l_fork_or_merge := Fork_Or_Merge(l_itemgroup_det.item_group_id);

Line 4155: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4151:
4152:
4153: ELSIF l_status = 'APPROVAL_REJECTED' THEN
4154:
4155: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4156: THEN
4157: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4158: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Approval Rejected');
4159: END IF;

Line 4157: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4153: ELSIF l_status = 'APPROVAL_REJECTED' THEN
4154:
4155: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4156: THEN
4157: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4158: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Approval Rejected');
4159: END IF;
4160:
4161: update ahl_item_groups_b

Line 4172: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4168:
4169:
4170: End if;
4171:
4172: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4173: THEN
4174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4175: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Approve_ItemGroups');
4176: END IF;

Line 4174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4170: End if;
4171:
4172: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4173: THEN
4174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4175: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Approve_ItemGroups');
4176: END IF;
4177:
4178:

Line 4188: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4184: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4185: p_data => x_msg_data,
4186: p_encoded => fnd_api.g_false);
4187:
4188: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4189: THEN
4190: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4191: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Error in Approve_ItemGroups');
4192: END IF;

Line 4190: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4186: p_encoded => fnd_api.g_false);
4187:
4188: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4189: THEN
4190: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4191: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Error in Approve_ItemGroups');
4192: END IF;
4193:
4194:

Line 4202: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4198: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4199: p_data => x_msg_data,
4200: p_encoded => fnd_api.g_false);
4201:
4202: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4203: THEN
4204: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4205: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unexpected Error in Approve_ItemGroups');
4206: END IF;

Line 4204: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4200: p_encoded => fnd_api.g_false);
4201:
4202: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4203: THEN
4204: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4205: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unexpected Error in Approve_ItemGroups');
4206: END IF;
4207:
4208: WHEN OTHERS THEN

Line 4220: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4216: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4217: p_data => x_msg_data,
4218: p_encoded => fnd_api.g_false);
4219:
4220: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4221: THEN
4222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4223: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unknown Error in Approve_ItemGroups');
4224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 4222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4218: p_encoded => fnd_api.g_false);
4219:
4220: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4221: THEN
4222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4223: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unknown Error in Approve_ItemGroups');
4224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4225: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', SQLERRM);
4226:

Line 4224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4220: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4221: THEN
4222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4223: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unknown Error in Approve_ItemGroups');
4224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4225: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', SQLERRM);
4226:
4227: END IF;
4228:

Line 4298: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

4294: -- Initialize API return status to success
4295: x_return_status := FND_API.G_RET_STS_SUCCESS;
4296:
4297: -- API body starts here
4298: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4299: THEN
4300: fnd_log.string
4301: (
4302: fnd_log.level_procedure,

Line 4300: fnd_log.string

4296:
4297: -- API body starts here
4298: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4299: THEN
4300: fnd_log.string
4301: (
4302: fnd_log.level_procedure,
4303: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4304: 'At the start of PLSQL procedure'

Line 4302: fnd_log.level_procedure,

4298: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4299: THEN
4300: fnd_log.string
4301: (
4302: fnd_log.level_procedure,
4303: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4304: 'At the start of PLSQL procedure'
4305: );
4306: END IF;

Line 4369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

4365: RAISE FND_API.G_EXC_ERROR;
4366: END IF;
4367: END IF;
4368:
4369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4370: THEN
4371: fnd_log.string
4372: (
4373: fnd_log.level_procedure,

Line 4371: fnd_log.string

4367: END IF;
4368:
4369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4370: THEN
4371: fnd_log.string
4372: (
4373: fnd_log.level_procedure,
4374: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
4375: 'At the end of PLSQL procedure'

Line 4373: fnd_log.level_procedure,

4369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4370: THEN
4371: fnd_log.string
4372: (
4373: fnd_log.level_procedure,
4374: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
4375: 'At the end of PLSQL procedure'
4376: );
4377: END IF;