1613: END IF;
1614:
1615: IGC_CC_HEADERS_PKG.Insert_Row(
1616: 1.0,
1617: FND_API.G_TRUE,
1618: FND_API.G_FALSE,
1619: FND_API.G_VALID_LEVEL_FULL,
1620: l_return_status,
1621: l_msg_count,
1614:
1615: IGC_CC_HEADERS_PKG.Insert_Row(
1616: 1.0,
1617: FND_API.G_TRUE,
1618: FND_API.G_FALSE,
1619: FND_API.G_VALID_LEVEL_FULL,
1620: l_return_status,
1621: l_msg_count,
1622: l_msg_data,
1615: IGC_CC_HEADERS_PKG.Insert_Row(
1616: 1.0,
1617: FND_API.G_TRUE,
1618: FND_API.G_FALSE,
1619: FND_API.G_VALID_LEVEL_FULL,
1620: l_return_status,
1621: l_msg_count,
1622: l_msg_data,
1623: l_row_id,
1747: IF (l_curr_year_pf_lines > 0) THEN
1748:
1749: IGC_CC_PO_INTERFACE_PKG.CONVERT_CC_TO_PO
1750: ( 1.0,
1751: FND_API.G_TRUE,
1752: FND_API.G_FALSE,
1753: FND_API.G_VALID_LEVEL_FULL,
1754: l_return_status,
1755: l_msg_count,
1748:
1749: IGC_CC_PO_INTERFACE_PKG.CONVERT_CC_TO_PO
1750: ( 1.0,
1751: FND_API.G_TRUE,
1752: FND_API.G_FALSE,
1753: FND_API.G_VALID_LEVEL_FULL,
1754: l_return_status,
1755: l_msg_count,
1756: l_msg_data,
1749: IGC_CC_PO_INTERFACE_PKG.CONVERT_CC_TO_PO
1750: ( 1.0,
1751: FND_API.G_TRUE,
1752: FND_API.G_FALSE,
1753: FND_API.G_VALID_LEVEL_FULL,
1754: l_return_status,
1755: l_msg_count,
1756: l_msg_data,
1757: l_header_id);
1775:
1776: IF l_interface_header_record.CC_Ctrl_Status = 'O' AND UPPER(l_error_status) = 'N' THEN
1777: IGC_CC_PO_INTERFACE_PKG.UPDATE_PO_APPROVED_FLAG
1778: ( 1.0,
1779: FND_API.G_TRUE,
1780: FND_API.G_FALSE,
1781: FND_API.G_VALID_LEVEL_FULL,
1782: l_return_status,
1783: l_msg_count,
1776: IF l_interface_header_record.CC_Ctrl_Status = 'O' AND UPPER(l_error_status) = 'N' THEN
1777: IGC_CC_PO_INTERFACE_PKG.UPDATE_PO_APPROVED_FLAG
1778: ( 1.0,
1779: FND_API.G_TRUE,
1780: FND_API.G_FALSE,
1781: FND_API.G_VALID_LEVEL_FULL,
1782: l_return_status,
1783: l_msg_count,
1784: l_msg_data,
1777: IGC_CC_PO_INTERFACE_PKG.UPDATE_PO_APPROVED_FLAG
1778: ( 1.0,
1779: FND_API.G_TRUE,
1780: FND_API.G_FALSE,
1781: FND_API.G_VALID_LEVEL_FULL,
1782: l_return_status,
1783: l_msg_count,
1784: l_msg_data,
1785: l_header_id);
1810: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_ENTERED_THRU_CCOI_PROG');
1811: l_history_message := FND_MESSAGE.GET;
1812: IGC_CC_ACTIONS_PKG.Insert_Row(
1813: 1.0,
1814: FND_API.G_TRUE,
1815: FND_API.G_FALSE,
1816: FND_API.G_VALID_LEVEL_FULL,
1817: l_return_status,
1818: l_msg_count,
1811: l_history_message := FND_MESSAGE.GET;
1812: IGC_CC_ACTIONS_PKG.Insert_Row(
1813: 1.0,
1814: FND_API.G_TRUE,
1815: FND_API.G_FALSE,
1816: FND_API.G_VALID_LEVEL_FULL,
1817: l_return_status,
1818: l_msg_count,
1819: l_msg_data,
1812: IGC_CC_ACTIONS_PKG.Insert_Row(
1813: 1.0,
1814: FND_API.G_TRUE,
1815: FND_API.G_FALSE,
1816: FND_API.G_VALID_LEVEL_FULL,
1817: l_return_status,
1818: l_msg_count,
1819: l_msg_data,
1820: l_row_id,
1853: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_ENCMBRED_THRU_CCOI_PROG');
1854: l_history_message := FND_MESSAGE.GET;
1855: IGC_CC_ACTIONS_PKG.Insert_Row(
1856: 1.0,
1857: FND_API.G_TRUE,
1858: FND_API.G_FALSE,
1859: FND_API.G_VALID_LEVEL_FULL,
1860: l_return_status,
1861: l_msg_count,
1854: l_history_message := FND_MESSAGE.GET;
1855: IGC_CC_ACTIONS_PKG.Insert_Row(
1856: 1.0,
1857: FND_API.G_TRUE,
1858: FND_API.G_FALSE,
1859: FND_API.G_VALID_LEVEL_FULL,
1860: l_return_status,
1861: l_msg_count,
1862: l_msg_data,
1855: IGC_CC_ACTIONS_PKG.Insert_Row(
1856: 1.0,
1857: FND_API.G_TRUE,
1858: FND_API.G_FALSE,
1859: FND_API.G_VALID_LEVEL_FULL,
1860: l_return_status,
1861: l_msg_count,
1862: l_msg_data,
1863: l_row_id,
2433: IF (l_msg_count > 0) THEN
2434:
2435: l_error_text := '';
2436: FOR l_cur IN 1..l_msg_count LOOP
2437: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2438: -- fnd_file.put_line (FND_FILE.LOG,
2439: -- l_error_text);
2440: -- bug 3199488 start block
2441: IF (l_state_level >= l_debug_level) THEN
2469: IF (l_msg_count > 0) THEN
2470:
2471: l_error_text := '';
2472: FOR l_cur IN 1..l_msg_count LOOP
2473: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2474: -- fnd_file.put_line (FND_FILE.LOG,
2475: -- l_error_text);
2476: -- bug 3199488 start block
2477: IF (l_state_level >= l_debug_level) THEN
3474: END IF;
3475:
3476: IGC_CC_ACCT_LINES_PKG.Insert_Row(
3477: 1.0,
3478: FND_API.G_TRUE,
3479: FND_API.G_FALSE,
3480: FND_API.G_VALID_LEVEL_FULL,
3481: l_return_status,
3482: l_msg_count,
3475:
3476: IGC_CC_ACCT_LINES_PKG.Insert_Row(
3477: 1.0,
3478: FND_API.G_TRUE,
3479: FND_API.G_FALSE,
3480: FND_API.G_VALID_LEVEL_FULL,
3481: l_return_status,
3482: l_msg_count,
3483: l_msg_data,
3476: IGC_CC_ACCT_LINES_PKG.Insert_Row(
3477: 1.0,
3478: FND_API.G_TRUE,
3479: FND_API.G_FALSE,
3480: FND_API.G_VALID_LEVEL_FULL,
3481: l_return_status,
3482: l_msg_count,
3483: l_msg_data,
3484: l_row_id,
4544: END IF;
4545:
4546: IGC_CC_DET_PF_PKG.Insert_Row(
4547: 1.0,
4548: FND_API.G_TRUE,
4549: FND_API.G_FALSE,
4550: FND_API.G_VALID_LEVEL_FULL,
4551: l_return_status,
4552: l_msg_count,
4545:
4546: IGC_CC_DET_PF_PKG.Insert_Row(
4547: 1.0,
4548: FND_API.G_TRUE,
4549: FND_API.G_FALSE,
4550: FND_API.G_VALID_LEVEL_FULL,
4551: l_return_status,
4552: l_msg_count,
4553: l_msg_data,
4546: IGC_CC_DET_PF_PKG.Insert_Row(
4547: 1.0,
4548: FND_API.G_TRUE,
4549: FND_API.G_FALSE,
4550: FND_API.G_VALID_LEVEL_FULL,
4551: l_return_status,
4552: l_msg_count,
4553: l_msg_data,
4554: l_row_id,
5072: p_filename_val => NULL,
5073: x_Return_Status => l_Return_Status
5074: );
5075:
5076: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
5077: raise FND_API.G_EXC_ERROR;
5078: END IF;
5079:
5080: RETURN;
5073: x_Return_Status => l_Return_Status
5074: );
5075:
5076: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
5077: raise FND_API.G_EXC_ERROR;
5078: END IF;
5079:
5080: RETURN;
5081:
5083: -- Exception handler section for the Output_Debug procedure.
5084: -- --------------------------------------------------------------------
5085: EXCEPTION
5086:
5087: WHEN FND_API.G_EXC_ERROR THEN
5088: RETURN;
5089:
5090: WHEN OTHERS THEN
5091: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN