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 945: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

941: OR ((l_x_item_assoc_rec.inventory_org_id IS NOT NULL) AND
942: (l_x_item_assoc_rec.inventory_org_id <> l_item_assoc_rec.inventory_org_id))
943: THEN
944: CLOSE Item_assoc_csr;
945: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
946: THEN
947: 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);
948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
949: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);

Line 948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

944: CLOSE Item_assoc_csr;
945: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
946: THEN
947: 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);
948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
949: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
950: 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);
951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
952: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);

Line 951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

947: 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);
948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
949: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
950: 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);
951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
952: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
953: END IF;
954:
955: FND_MESSAGE.Set_Name('AHL','AHL_COM_KEY_NOUPDATE');

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

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

Line 1775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1798: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1813: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1826: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1835: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1859: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1867: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1887: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1902: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

Line 1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 2031: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

2103: END IF;
2104:
2105: END IF;
2106:
2107: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2109: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Loop to validate Item Association');
2110: END IF;
2111:

Line 2108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2104:
2105: END IF;
2106:
2107: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2109: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Loop to validate Item Association');
2110: END IF;
2111:
2112: -- Validate Item Assoc records.

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

2136:
2137: END LOOP;
2138: END IF; /* count > 0 */
2139:
2140: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2141: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2142: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2143: END IF;
2144:

Line 2141: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2137: END LOOP;
2138: END IF; /* count > 0 */
2139:
2140: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2141: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2142: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2143: END IF;
2144:
2145: -- Check Error Message stack.

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

2259: l_item_group_rec.SOURCE_LANG := NULL;
2260: END IF;
2261: */
2262:
2263: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2265: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Before calling Item Group Table Handler');
2266: END IF;
2267:

Line 2264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2260: END IF;
2261: */
2262:
2263: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2265: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Before calling Item Group Table Handler');
2266: END IF;
2267:
2268: AHL_ITEM_GROUPS_PKG.UPDATE_ROW(

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

2292: X_LAST_UPDATE_DATE => sysdate,
2293: X_LAST_UPDATED_BY => fnd_global.USER_ID,
2294: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
2295:
2296: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2298: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'After Table Handler');
2299: END IF;
2300:

Line 2297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2293: X_LAST_UPDATED_BY => fnd_global.USER_ID,
2294: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID);
2295:
2296: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2298: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'After Table Handler');
2299: END IF;
2300:
2301:

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

2301:
2302: END IF; /* update only if operation_flag set */
2303: -- End Updates for Item_Groups.
2304:
2305: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2306: FND_LOG.string(FND_LOG.level_statement,l_full_name,'l_old_item_group_rec.source_item_group_id => '||
2307: l_old_item_group_rec.source_item_group_id);
2308: END IF;
2309:

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

2302: END IF; /* update only if operation_flag set */
2303: -- End Updates for Item_Groups.
2304:
2305: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2306: FND_LOG.string(FND_LOG.level_statement,l_full_name,'l_old_item_group_rec.source_item_group_id => '||
2307: l_old_item_group_rec.source_item_group_id);
2308: END IF;
2309:
2310: -- SATHAPLI::Bug# 5566764 fix

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

2330: END LOOP;
2331: END IF;
2332:
2333: IF (l_index > 1) THEN
2334: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2335: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating '||l_index||
2336: ' items in the IG for remove.');
2337: END IF;
2338:

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

2331: END IF;
2332:
2333: IF (l_index > 1) THEN
2334: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2335: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating '||l_index||
2336: ' items in the IG for remove.');
2337: END IF;
2338:
2339: AHL_UTIL_UC_PKG.Check_Invalidate_Instance

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

2355: END IF;
2356:
2357: END IF; -- end of l_old_item_group_rec.source_item_group_id IS NOT NULL
2358:
2359: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2361: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Item Association Loop');
2362: END IF;
2363:

Line 2360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2356:
2357: END IF; -- end of l_old_item_group_rec.source_item_group_id IS NOT NULL
2358:
2359: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2361: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Item Association Loop');
2362: END IF;
2363:
2364: -- Process Item Associations table.

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

2379: END IF;
2380: END LOOP;
2381: END IF;
2382:
2383: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2385: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2386: END IF;
2387:

Line 2384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2380: END LOOP;
2381: END IF;
2382:
2383: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2385: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'End of Loop');
2386: END IF;
2387:
2388: -- The validation of the revision update will be done only for revisions

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

2390:
2391: -- SATHAPLI::Bug# 4328454 fix
2392: -- Validate updation of interchange_type_code
2393: IF (l_update_flag = 'Y') THEN
2394: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2395: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Calling validate_IG_update.');
2396: END IF;
2397:
2398: validate_IG_update

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

2391: -- SATHAPLI::Bug# 4328454 fix
2392: -- Validate updation of interchange_type_code
2393: IF (l_update_flag = 'Y') THEN
2394: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2395: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Calling validate_IG_update.');
2396: END IF;
2397:
2398: validate_IG_update
2399: (

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

2428: ( p_count => x_msg_count,
2429: p_data => x_msg_data,
2430: p_encoded => fnd_api.g_false);
2431:
2432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2434: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group',
2435: 'End of Modify_Item_group...x_return_status => '||x_return_status);
2436: END IF;

Line 2433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2429: p_data => x_msg_data,
2430: p_encoded => fnd_api.g_false);
2431:
2432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2434: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group',
2435: 'End of Modify_Item_group...x_return_status => '||x_return_status);
2436: END IF;
2437:

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

2444: p_data => x_msg_data,
2445: p_encoded => fnd_api.g_false);
2446: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2447:
2448: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2450: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Error in Modify_Item_group');
2451: END IF;
2452:

Line 2449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2445: p_encoded => fnd_api.g_false);
2446: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2447:
2448: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2450: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Error in Modify_Item_group');
2451: END IF;
2452:
2453:

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

2457: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2458: p_data => x_msg_data,
2459: p_encoded => fnd_api.g_false);
2460: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2461: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2463: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unexpected error in Modify_Item_group');
2464: END IF;
2465:

Line 2462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2458: p_data => x_msg_data,
2459: p_encoded => fnd_api.g_false);
2460: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2461: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2463: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unexpected error in Modify_Item_group');
2464: END IF;
2465:
2466:

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

2476: p_data => x_msg_data,
2477: p_encoded => fnd_api.g_false);
2478: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2479:
2480: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2482: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unknown Error in Modify_Item_group');
2483: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2484: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', SQLERRM);

Line 2481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2477: p_encoded => fnd_api.g_false);
2478: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2479:
2480: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2482: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unknown Error in Modify_Item_group');
2483: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2484: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', SQLERRM);
2485: END IF;

Line 2483: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2479:
2480: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2482: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unknown Error in Modify_Item_group');
2483: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2484: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', SQLERRM);
2485: END IF;
2486:
2487:

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

2571:
2572: -- Initialize API return status to success
2573: x_return_status := FND_API.G_RET_STS_SUCCESS;
2574:
2575: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2576: THEN
2577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2578: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Begin of Remove_Item_group');
2579: END IF;

Line 2577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2573: x_return_status := FND_API.G_RET_STS_SUCCESS;
2574:
2575: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2576: THEN
2577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2578: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Begin of Remove_Item_group');
2579: END IF;
2580:
2581:

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

2660: );
2661:
2662: */
2663:
2664: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2665: THEN
2666: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2667: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Deleting Item Group');
2668: END IF;

Line 2666: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2662: */
2663:
2664: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2665: THEN
2666: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2667: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Deleting Item Group');
2668: END IF;
2669:
2670: DELETE AHL_ITEM_ASSOCIATIONS_TL

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

2682:
2683: ELSIF l_item_group_rec.status_code ='COMPLETE'
2684: THEN
2685:
2686: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2687: THEN
2688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2689: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Updating Item Group to Removed');
2690: END IF;

Line 2688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2684: THEN
2685:
2686: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2687: THEN
2688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2689: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Updating Item Group to Removed');
2690: END IF;
2691:
2692: Update Ahl_Item_groups_b

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

2708: ( p_count => x_msg_count,
2709: p_data => x_msg_data,
2710: p_encoded => fnd_api.g_false);
2711:
2712: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2713: THEN
2714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2715: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'End of Remove_Item_group');
2716: END IF;

Line 2714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2710: p_encoded => fnd_api.g_false);
2711:
2712: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2713: THEN
2714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2715: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'End of Remove_Item_group');
2716: END IF;
2717:
2718:

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

2724: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2725: p_data => x_msg_data,
2726: p_encoded => fnd_api.g_false);
2727:
2728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2729: THEN
2730: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2731: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Error in Remove_Item_group');
2732: END IF;

Line 2730: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2726: p_encoded => fnd_api.g_false);
2727:
2728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2729: THEN
2730: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2731: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Error in Remove_Item_group');
2732: END IF;
2733:
2734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2736: Rollback to Remove_Item_group_pvt;
2737: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2738: p_data => x_msg_data,
2739: p_encoded => fnd_api.g_false);
2740: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2741: THEN
2742: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2743: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unexpected error in Remove_Item_group');
2744: END IF;

Line 2742: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2738: p_data => x_msg_data,
2739: p_encoded => fnd_api.g_false);
2740: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2741: THEN
2742: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2743: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unexpected error in Remove_Item_group');
2744: END IF;
2745:
2746:

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

2754: END IF;
2755: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2756: p_data => x_msg_data,
2757: p_encoded => fnd_api.g_false);
2758: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2759: THEN
2760: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2761: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');
2762: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2760: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2756: p_data => x_msg_data,
2757: p_encoded => fnd_api.g_false);
2758: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2759: THEN
2760: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2761: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');
2762: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2763: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', SQLERRM);
2764: END IF;

Line 2762: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2758: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2759: THEN
2760: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2761: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');
2762: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2763: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', SQLERRM);
2764: END IF;
2765:
2766:

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

2885: -- Initialize API return status to success
2886:
2887: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2888:
2889: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2890: THEN
2891: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2892: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Begin Initiate_Itemgroup_Appr');
2893: END IF;

Line 2891: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2887: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2888:
2889: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2890: THEN
2891: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2892: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Begin Initiate_Itemgroup_Appr');
2893: END IF;
2894:
2895:

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

2991: RAISE FND_API.G_EXC_ERROR;
2992: END IF;
2993:
2994:
2995: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2996: THEN
2997: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2998: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'l_active flag is yes');
2999: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2997: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2993:
2994:
2995: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2996: THEN
2997: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2998: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'l_active flag is yes');
2999: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3000: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Updating Item group');
3001: END IF;

Line 2999: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2995: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2996: THEN
2997: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2998: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'l_active flag is yes');
2999: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3000: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Updating Item group');
3001: END IF;
3002:
3003: Update AHL_ITEM_GROUPS_B

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

3016: IF l_ACTIVE='Y'
3017: THEN
3018:
3019:
3020: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3021: THEN
3022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3023: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_generic_aprv_pvt.start_wf_process');
3024: END IF;

Line 3022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3018:
3019:
3020: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3021: THEN
3022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3023: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_generic_aprv_pvt.start_wf_process');
3024: END IF;
3025:
3026: AHL_GENERIC_APRV_PVT.START_WF_PROCESS(

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

3036: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
3037: P_ITEM_TYPE =>'AHLGAPP');
3038: ELSE
3039:
3040: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3041: THEN
3042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3043: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_mc_itemgroup_pvt.Approve_ItemGroups');
3044: END IF;

Line 3042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3038: ELSE
3039:
3040: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3041: THEN
3042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3043: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Calling ahl_mc_itemgroup_pvt.Approve_ItemGroups');
3044: END IF;
3045:
3046: AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups

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

3080: ( p_count => x_msg_count,
3081: p_data => x_msg_data,
3082: p_encoded => fnd_api.g_false);
3083:
3084: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3085: THEN
3086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3087: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'End of Initiate_Itemgroup_Appr');
3088: END IF;

Line 3086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3082: p_encoded => fnd_api.g_false);
3083:
3084: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3085: THEN
3086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3087: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'End of Initiate_Itemgroup_Appr');
3088: END IF;
3089:
3090:

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

3094: Rollback to Initiate_Itemgroup_Appr;
3095: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3096: p_data => x_msg_data,
3097: p_encoded => fnd_api.g_false);
3098: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3099: THEN
3100: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3101: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Error in Initiate_Itemgroup_Appr');
3102: END IF;

Line 3100: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3096: p_data => x_msg_data,
3097: p_encoded => fnd_api.g_false);
3098: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3099: THEN
3100: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3101: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Error in Initiate_Itemgroup_Appr');
3102: END IF;
3103:
3104:

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

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

Line 3114: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3110: p_data => x_msg_data,
3111: p_encoded => fnd_api.g_false);
3112: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3113: THEN
3114: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3115: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unexpected Error in Initiate_Itemgroup_Appr');
3116: END IF;
3117:
3118:

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

3127: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3128: p_data => x_msg_data,
3129: p_encoded => fnd_api.g_false);
3130:
3131: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3132: THEN
3133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3134: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unknown Error in Initiate_Itemgroup_Appr');
3135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 3133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3129: p_encoded => fnd_api.g_false);
3130:
3131: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3132: THEN
3133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3134: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unknown Error in Initiate_Itemgroup_Appr');
3135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3136: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', SQLERRM);
3137: END IF;

Line 3135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3131: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3132: THEN
3133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3134: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unknown Error in Initiate_Itemgroup_Appr');
3135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3136: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', SQLERRM);
3137: END IF;
3138:
3139: END Initiate_Itemgroup_Appr;

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

3282: -- Initialize API return status to success
3283:
3284: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3285:
3286: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3287: THEN
3288: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3289: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Begin of Create_ItemGroup_Revision');
3290: END IF;

Line 3288: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3284: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3285:
3286: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3287: THEN
3288: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3289: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Begin of Create_ItemGroup_Revision');
3290: END IF;
3291:
3292:

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

3346:
3347:
3348: -- Inserting a new Revision in the Header Table Using table Handler
3349:
3350: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3351: THEN
3352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3353: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Calling Table handler');
3354: END IF;

Line 3352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3348: -- Inserting a new Revision in the Header Table Using table Handler
3349:
3350: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3351: THEN
3352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3353: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Calling Table handler');
3354: END IF;
3355:
3356:

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

3399: last_update_login = l_last_update_login
3400: WHERE relationship_id = item_group_rec.relationship_id and
3401: trunc(nvl(active_end_date, sysdate + 1)) > trunc(sysdate);
3402:
3403: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3404: THEN
3405: FND_LOG.STRING
3406: (
3407: FND_LOG.LEVEL_PROCEDURE,

Line 3405: FND_LOG.STRING

3401: trunc(nvl(active_end_date, sysdate + 1)) > trunc(sysdate);
3402:
3403: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3404: THEN
3405: FND_LOG.STRING
3406: (
3407: FND_LOG.LEVEL_PROCEDURE,
3408: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',
3409: 'Updated MC position '||item_group_rec.relationship_id||' with temp_item_group_id '||x_itemgroup_id

Line 3407: FND_LOG.LEVEL_PROCEDURE,

3403: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3404: THEN
3405: FND_LOG.STRING
3406: (
3407: FND_LOG.LEVEL_PROCEDURE,
3408: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',
3409: 'Updated MC position '||item_group_rec.relationship_id||' with temp_item_group_id '||x_itemgroup_id
3410: );
3411: END IF;

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

3411: END IF;
3412: END LOOP;
3413: -- TAMAL -- IG Amendments --
3414:
3415: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3416: THEN
3417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3418: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Loop to create Item Association');
3419: END IF;

Line 3417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3413: -- TAMAL -- IG Amendments --
3414:
3415: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3416: THEN
3417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3418: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Loop to create Item Association');
3419: END IF;
3420:
3421: FOR I IN get_itemgroup_assos_det(p_source_ItemGroup_id)

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

3465: x_last_update_login => l_last_update_login
3466: );
3467: END LOOP;
3468:
3469: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3470: THEN
3471: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3472: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Loop');
3473: END IF;

Line 3471: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3467: END LOOP;
3468:
3469: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3470: THEN
3471: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3472: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Loop');
3473: END IF;
3474:
3475: -- Standard check of p_commit

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

3476: IF FND_API.TO_BOOLEAN(p_commit) THEN
3477: COMMIT WORK;
3478: END IF;
3479:
3480: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3481: THEN
3482: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3483: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Create_ItemGroup_Revision');
3484: END IF;

Line 3482: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3478: END IF;
3479:
3480: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3481: THEN
3482: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3483: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Create_ItemGroup_Revision');
3484: END IF;
3485:
3486:

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

3491: Rollback to Create_ItemGroup_Revision;
3492: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3493: p_data => x_msg_data,
3494: p_encoded => fnd_api.g_false);
3495: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3496: THEN
3497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3498: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Error in Create_ItemGroup_Revision');
3499: END IF;

Line 3497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3493: p_data => x_msg_data,
3494: p_encoded => fnd_api.g_false);
3495: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3496: THEN
3497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3498: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Error in Create_ItemGroup_Revision');
3499: END IF;
3500:
3501:

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

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

Line 3510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

3522: END IF;
3523: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3524: p_data => x_msg_data,
3525: p_encoded => fnd_api.g_false);
3526: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3527: THEN
3528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3529: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');
3530: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 3528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3524: p_data => x_msg_data,
3525: p_encoded => fnd_api.g_false);
3526: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3527: THEN
3528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3529: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');
3530: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3531: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',SQLERRM );
3532:

Line 3530: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3526: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3527: THEN
3528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3529: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');
3530: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3531: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision',SQLERRM );
3532:
3533: END IF;
3534:

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

3598: from ahl_item_groups_b_h
3599: where ITEM_GROUP_ID = p_ItemGroups_id;
3600:
3601:
3602: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3603: THEN
3604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3605: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting into History Tables');
3606: END IF;

Line 3604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3600:
3601:
3602: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3603: THEN
3604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3605: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting into History Tables');
3606: END IF;
3607:
3608:

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

3703: WHERE item_group_id = p_ItemGroups_id;
3704:
3705:
3706:
3707: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3708: THEN
3709: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3710: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting Item Association into history table Start of Loop');
3711: END IF;

Line 3709: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3705:
3706:
3707: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3708: THEN
3709: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3710: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting Item Association into history table Start of Loop');
3711: END IF;
3712:
3713:

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

3757: X_LAST_UPDATE_LOGIN => l_item_assos_det.LAST_UPDATE_LOGIN );
3758:
3759: END LOOP;
3760:
3761: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3762: THEN
3763: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3764: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Loop');
3765: END IF;

Line 3763: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3759: END LOOP;
3760:
3761: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3762: THEN
3763: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3764: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Loop');
3765: END IF;
3766:
3767:

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

3906: -- Initialize API return status to success
3907:
3908: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3909:
3910: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3911: THEN
3912: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3913: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Begin of Approve_ItemGroups');
3914: END IF;

Line 3912: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3908: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3909:
3910: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3911: THEN
3912: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3913: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Begin of Approve_ItemGroups');
3914: END IF;
3915:
3916:

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

3955:
3956:
3957: IF l_itemgroup_det.Source_Item_group_id IS NULL THEN
3958:
3959: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3960: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3961: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item group id is null');
3962: END IF;
3963:

Line 3960: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3956:
3957: IF l_itemgroup_det.Source_Item_group_id IS NULL THEN
3958:
3959: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3960: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3961: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item group id is null');
3962: END IF;
3963:
3964: update ahl_item_groups_b

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

3979:
3980: ELSE
3981:
3982:
3983: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3984: THEN
3985: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3986: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item Group id is not null');
3987: END IF;

Line 3985: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3981:
3982:
3983: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3984: THEN
3985: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3986: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item Group id is not null');
3987: END IF;
3988:
3989: l_fork_or_merge := Fork_Or_Merge(l_itemgroup_det.item_group_id);

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

4125:
4126:
4127: ELSIF l_status = 'APPROVAL_REJECTED' THEN
4128:
4129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4130: THEN
4131: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4132: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Approval Rejected');
4133: END IF;

Line 4131: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4127: ELSIF l_status = 'APPROVAL_REJECTED' THEN
4128:
4129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4130: THEN
4131: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4132: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Approval Rejected');
4133: END IF;
4134:
4135: update ahl_item_groups_b

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

4142:
4143:
4144: End if;
4145:
4146: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4147: THEN
4148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4149: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Approve_ItemGroups');
4150: END IF;

Line 4148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4144: End if;
4145:
4146: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4147: THEN
4148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4149: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'End of Approve_ItemGroups');
4150: END IF;
4151:
4152:

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

4158: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4159: p_data => x_msg_data,
4160: p_encoded => fnd_api.g_false);
4161:
4162: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4163: THEN
4164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4165: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Error in Approve_ItemGroups');
4166: END IF;

Line 4164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4160: p_encoded => fnd_api.g_false);
4161:
4162: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4163: THEN
4164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4165: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Error in Approve_ItemGroups');
4166: END IF;
4167:
4168:

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

4172: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4173: p_data => x_msg_data,
4174: p_encoded => fnd_api.g_false);
4175:
4176: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4177: THEN
4178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4179: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unexpected Error in Approve_ItemGroups');
4180: END IF;

Line 4178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4174: p_encoded => fnd_api.g_false);
4175:
4176: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4177: THEN
4178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4179: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unexpected Error in Approve_ItemGroups');
4180: END IF;
4181:
4182: WHEN OTHERS THEN

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

4190: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4191: p_data => x_msg_data,
4192: p_encoded => fnd_api.g_false);
4193:
4194: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4195: THEN
4196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4197: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unknown Error in Approve_ItemGroups');
4198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 4196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4192: p_encoded => fnd_api.g_false);
4193:
4194: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4195: THEN
4196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4197: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unknown Error in Approve_ItemGroups');
4198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4199: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', SQLERRM);
4200:

Line 4198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4194: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4195: THEN
4196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4197: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unknown Error in Approve_ItemGroups');
4198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4199: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', SQLERRM);
4200:
4201: END IF;
4202:

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

4268: -- Initialize API return status to success
4269: x_return_status := FND_API.G_RET_STS_SUCCESS;
4270:
4271: -- API body starts here
4272: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4273: THEN
4274: fnd_log.string
4275: (
4276: fnd_log.level_procedure,

Line 4274: fnd_log.string

4270:
4271: -- API body starts here
4272: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4273: THEN
4274: fnd_log.string
4275: (
4276: fnd_log.level_procedure,
4277: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4278: 'At the start of PLSQL procedure'

Line 4276: fnd_log.level_procedure,

4272: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4273: THEN
4274: fnd_log.string
4275: (
4276: fnd_log.level_procedure,
4277: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4278: 'At the start of PLSQL procedure'
4279: );
4280: END IF;

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

4339: RAISE FND_API.G_EXC_ERROR;
4340: END IF;
4341: END IF;
4342:
4343: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4344: THEN
4345: fnd_log.string
4346: (
4347: fnd_log.level_procedure,

Line 4345: fnd_log.string

4341: END IF;
4342:
4343: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4344: THEN
4345: fnd_log.string
4346: (
4347: fnd_log.level_procedure,
4348: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
4349: 'At the end of PLSQL procedure'

Line 4347: fnd_log.level_procedure,

4343: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4344: THEN
4345: fnd_log.string
4346: (
4347: fnd_log.level_procedure,
4348: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
4349: 'At the end of PLSQL procedure'
4350: );
4351: END IF;