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.IGC_CC_MPFS_PROCESS_PKG dependencies on FND_API

Line 238: x_return_status := FND_API.G_RET_STS_SUCCESS;

234:
235: l_full_path := g_path || 'Process_Interface_Row';
236:
237: -- Bug 2409502, Calculate the non recoverable tax on the p_enc_amt
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239: l_enc_amt := p_enc_amt;
240:
241: /*EB Tax uptake - Bug No : 6472296*/
242: /*igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax

Line 244: p_init_msg_list => FND_API.G_TRUE,

240:
241: /*EB Tax uptake - Bug No : 6472296*/
242: /*igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
243: (p_api_version => 1.0,
244: p_init_msg_list => FND_API.G_TRUE,
245: p_commit => FND_API.G_FALSE,
246: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
247: x_return_status => l_return_status,
248: x_msg_count => l_msg_count,

Line 245: p_commit => FND_API.G_FALSE,

241: /*EB Tax uptake - Bug No : 6472296*/
242: /*igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
243: (p_api_version => 1.0,
244: p_init_msg_list => FND_API.G_TRUE,
245: p_commit => FND_API.G_FALSE,
246: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
247: x_return_status => l_return_status,
248: x_msg_count => l_msg_count,
249: x_msg_data => l_msg_data,

Line 246: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

242: /*igc_cc_budgetary_ctrl_pkg.calculate_nonrec_tax
243: (p_api_version => 1.0,
244: p_init_msg_list => FND_API.G_TRUE,
245: p_commit => FND_API.G_FALSE,
246: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
247: x_return_status => l_return_status,
248: x_msg_count => l_msg_count,
249: x_msg_data => l_msg_data,
250: p_tax_id => p_cc_acct_lines_rec.tax_id,

Line 264: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

260: P_Line_Id =>p_cc_acct_lines_rec.cc_acct_line_id,
261: P_Tax_Amount =>l_enc_tax_amt,
262: P_Return_Status =>l_return_status,
263: P_Error_Code =>P_Error_Code);
264: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
265: THEN
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268: END IF;

Line 266: RAISE FND_API.G_EXC_ERROR;

262: P_Return_Status =>l_return_status,
263: P_Error_Code =>P_Error_Code);
264: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
265: THEN
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268: END IF;
269: /*EB Tax uptake - Bug No : 6472296 END*/
270: l_enc_amt := l_enc_amt + Nvl(l_enc_tax_amt,0);

Line 356: WHEN FND_API.G_EXC_ERROR

352:
353: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
354: p_data => x_msg_data );
355: EXCEPTION
356: WHEN FND_API.G_EXC_ERROR
357: THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359:
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 358: x_return_status := FND_API.G_RET_STS_ERROR;

354: p_data => x_msg_data );
355: EXCEPTION
356: WHEN FND_API.G_EXC_ERROR
357: THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359:
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
361: p_data => x_msg_data );
362: IF (g_excep_level >= g_debug_level ) THEN

Line 363: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

359:
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
361: p_data => x_msg_data );
362: IF (g_excep_level >= g_debug_level ) THEN
363: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
364: END IF;
365:
366: RETURN;
367:

Line 573: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

569: l_return_status,
570: l_msg_count,
571: l_msg_data
572: );
573: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
574: THEN
575: RAISE FND_API.G_EXC_ERROR;
576: END IF;
577:

Line 575: RAISE FND_API.G_EXC_ERROR;

571: l_msg_data
572: );
573: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
574: THEN
575: RAISE FND_API.G_EXC_ERROR;
576: END IF;
577:
578: END IF;
579: END IF;

Line 700: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

696: l_return_status,
697: l_msg_count,
698: l_msg_data);
699:
700: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
701: THEN
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704: END IF;

Line 702: RAISE FND_API.G_EXC_ERROR;

698: l_msg_data);
699:
700: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
701: THEN
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704: END IF;
705:
706: END LOOP;

Line 732: l_debug := FND_API.G_TRUE;

728:
729: -- IF (l_debug = 'Y')
730: IF (g_debug_mode = 'Y')
731: THEN
732: l_debug := FND_API.G_TRUE;
733: ELSE
734: l_debug := FND_API.G_FALSE;
735: END IF;
736:

Line 734: l_debug := FND_API.G_FALSE;

730: IF (g_debug_mode = 'Y')
731: THEN
732: l_debug := FND_API.G_TRUE;
733: ELSE
734: l_debug := FND_API.G_FALSE;
735: END IF;
736:
737: BEGIN
738:

Line 751: p_conc_proc => FND_API.G_FALSE);

747: p_ret_status => l_bc_return_status,
748: p_batch_result_code => l_batch_result_code,
749: p_doc_type => 'CC',
750: p_debug => l_debug,
751: p_conc_proc => FND_API.G_FALSE);
752: EXCEPTION
753: WHEN OTHERS
754: THEN
755: IF ( g_unexp_level >= g_debug_level ) THEN

Line 791: WHEN FND_API.G_EXC_ERROR

787: RETURN('P');
788: END IF;
789:
790: EXCEPTION
791: WHEN FND_API.G_EXC_ERROR
792: THEN
793: IF (g_excep_level >= g_debug_level ) THEN
794: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
795: END IF;

Line 794: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

790: EXCEPTION
791: WHEN FND_API.G_EXC_ERROR
792: THEN
793: IF (g_excep_level >= g_debug_level ) THEN
794: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
795: END IF;
796: RETURN('F');
797:
798: WHEN OTHERS

Line 850: RETURN (FND_API.G_FALSE);

846: fa.application_short_name = 'SQLGL' AND
847: (gp.start_date <= p_date_to_check AND gp.end_date >= p_date_to_check);
848:
849: IF (l_period_status = NULL) OR ((NVL(l_period_status,'X') <> 'O') AND (NVL(l_period_status,'X')<> 'F')) THEN
850: RETURN (FND_API.G_FALSE);
851: ELSE
852: RETURN (FND_API.G_TRUE);
853: END IF;
854:

Line 852: RETURN (FND_API.G_TRUE);

848:
849: IF (l_period_status = NULL) OR ((NVL(l_period_status,'X') <> 'O') AND (NVL(l_period_status,'X')<> 'F')) THEN
850: RETURN (FND_API.G_FALSE);
851: ELSE
852: RETURN (FND_API.G_TRUE);
853: END IF;
854:
855:
856: EXCEPTION

Line 866: RETURN (FND_API.G_FALSE);

862: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
863: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
864: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
865: END IF;
866: RETURN (FND_API.G_FALSE);
867: END IS_GL_PERIOD_OPEN;
868:
869: -- Bug 1634159 Fixed
870: /*=================================================================================

Line 902: RETURN (FND_API.G_FALSE);

898: gb.set_of_books_id = p_sob_id2 AND
899: (gp.start_date <= p_date_to_check AND gp.end_date >= p_date_to_check);
900:
901: IF (l_cc_period_status = NULL) OR ((NVL(l_cc_period_status,'X') <> 'O') AND (NVL(l_cc_period_status,'X')<> 'F')) THEN
902: RETURN (FND_API.G_FALSE);
903: ELSE
904: RETURN (FND_API.G_TRUE);
905: END IF;
906:

Line 904: RETURN (FND_API.G_TRUE);

900:
901: IF (l_cc_period_status = NULL) OR ((NVL(l_cc_period_status,'X') <> 'O') AND (NVL(l_cc_period_status,'X')<> 'F')) THEN
902: RETURN (FND_API.G_FALSE);
903: ELSE
904: RETURN (FND_API.G_TRUE);
905: END IF;
906:
907:
908: EXCEPTION

Line 917: RETURN (FND_API.G_FALSE);

913: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
914: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
915: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
916: END IF;
917: RETURN (FND_API.G_FALSE);
918: END; /* End of IS_CC_PERIOD_OPEN Function */
919:
920:
921: /* This Procedure validates the parameter and return the result exception if any.

Line 952: l_gl_period_open := FND_API.G_FALSE;

948:
949: l_full_path VARCHAR2(255);
950:
951: BEGIN
952: l_gl_period_open := FND_API.G_FALSE;
953: l_cc_period_open := FND_API.G_FALSE;
954: l_validated := FND_API.G_FALSE;
955:
956: l_full_path := g_path || 'VALIDATE_PARAMS';

Line 953: l_cc_period_open := FND_API.G_FALSE;

949: l_full_path VARCHAR2(255);
950:
951: BEGIN
952: l_gl_period_open := FND_API.G_FALSE;
953: l_cc_period_open := FND_API.G_FALSE;
954: l_validated := FND_API.G_FALSE;
955:
956: l_full_path := g_path || 'VALIDATE_PARAMS';
957:

Line 954: l_validated := FND_API.G_FALSE;

950:
951: BEGIN
952: l_gl_period_open := FND_API.G_FALSE;
953: l_cc_period_open := FND_API.G_FALSE;
954: l_validated := FND_API.G_FALSE;
955:
956: l_full_path := g_path || 'VALIDATE_PARAMS';
957:
958: -- Get the fiscal years for the dates

Line 978: l_cc_period_open := FND_API.G_FALSE;

974: -- Bug fix 2124595 end 2
975: IF (p_transfer_date >= p_start_date) THEN
976: IF (p_target_date >= p_transfer_date) THEN
977: IF (p_end_date < p_target_date ) THEN
978: l_cc_period_open := FND_API.G_FALSE;
979: -- Bug 1634159 Fixed
980: l_cc_period_open := IGC_CC_MPFS_PROCESS_PKG.IS_CC_PERIOD_OPEN(p_transfer_date,p_sob_id,p_org_id);
981: IF FND_API.TO_BOOLEAN(l_cc_period_open) THEN
982:

Line 981: IF FND_API.TO_BOOLEAN(l_cc_period_open) THEN

977: IF (p_end_date < p_target_date ) THEN
978: l_cc_period_open := FND_API.G_FALSE;
979: -- Bug 1634159 Fixed
980: l_cc_period_open := IGC_CC_MPFS_PROCESS_PKG.IS_CC_PERIOD_OPEN(p_transfer_date,p_sob_id,p_org_id);
981: IF FND_API.TO_BOOLEAN(l_cc_period_open) THEN
982:
983: IF (p_sbc_on) THEN
984: l_gl_period_open := IGC_CC_MPFS_PROCESS_PKG.IS_GL_PERIOD_OPEN(p_transfer_date,p_sob_id);
985: IF FND_API.TO_BOOLEAN(l_gl_period_open )THEN

Line 985: IF FND_API.TO_BOOLEAN(l_gl_period_open )THEN

981: IF FND_API.TO_BOOLEAN(l_cc_period_open) THEN
982:
983: IF (p_sbc_on) THEN
984: l_gl_period_open := IGC_CC_MPFS_PROCESS_PKG.IS_GL_PERIOD_OPEN(p_transfer_date,p_sob_id);
985: IF FND_API.TO_BOOLEAN(l_gl_period_open )THEN
986: l_validated := FND_API.G_TRUE;
987: ELSE
988: p_exception := NULL;
989: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_NOT_OPEN_GL_PRD');

Line 986: l_validated := FND_API.G_TRUE;

982:
983: IF (p_sbc_on) THEN
984: l_gl_period_open := IGC_CC_MPFS_PROCESS_PKG.IS_GL_PERIOD_OPEN(p_transfer_date,p_sob_id);
985: IF FND_API.TO_BOOLEAN(l_gl_period_open )THEN
986: l_validated := FND_API.G_TRUE;
987: ELSE
988: p_exception := NULL;
989: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_NOT_OPEN_GL_PRD');
990: FND_MESSAGE.SET_TOKEN('TRANSFER_DT',TO_CHAR(p_transfer_date),TRUE);

Line 998: l_validated := FND_API.G_TRUE;

994: p_exception := FND_MESSAGE.GET;
995: END IF;
996:
997: ELSE
998: l_validated := FND_API.G_TRUE;
999: END IF;
1000: ELSE
1001: p_exception := NULL;
1002: FND_MESSAGE.SET_NAME('IGC','IGC_CC_TX_DT_NOT_OPEN_CC_PRD');

Line 1069: IF FND_API.TO_BOOLEAN(l_validated) THEN

1065: END IF;
1066: p_exception := FND_MESSAGE.GET;
1067: END IF;
1068:
1069: IF FND_API.TO_BOOLEAN(l_validated) THEN
1070: p_result := FND_API.G_TRUE;
1071: ELSE
1072: p_result := FND_API.G_FALSE;
1073:

Line 1070: p_result := FND_API.G_TRUE;

1066: p_exception := FND_MESSAGE.GET;
1067: END IF;
1068:
1069: IF FND_API.TO_BOOLEAN(l_validated) THEN
1070: p_result := FND_API.G_TRUE;
1071: ELSE
1072: p_result := FND_API.G_FALSE;
1073:
1074: END IF;

Line 1072: p_result := FND_API.G_FALSE;

1068:
1069: IF FND_API.TO_BOOLEAN(l_validated) THEN
1070: p_result := FND_API.G_TRUE;
1071: ELSE
1072: p_result := FND_API.G_FALSE;
1073:
1074: END IF;
1075:
1076: END VALIDATE_PARAMS; /* End of Validate Params Procedure */

Line 1360: l_init_msg_list := FND_API.G_FALSE;

1356: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
1357: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
1358: l_full_path VARCHAR2(255);
1359: BEGIN
1360: l_init_msg_list := FND_API.G_FALSE;
1361: l_commit := FND_API.G_FALSE;
1362: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1363: l_Last_Updated_By := FND_GLOBAL.USER_ID;
1364: l_Last_Update_Login := FND_GLOBAL.LOGIN_ID;

Line 1361: l_commit := FND_API.G_FALSE;

1357: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
1358: l_full_path VARCHAR2(255);
1359: BEGIN
1360: l_init_msg_list := FND_API.G_FALSE;
1361: l_commit := FND_API.G_FALSE;
1362: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1363: l_Last_Updated_By := FND_GLOBAL.USER_ID;
1364: l_Last_Update_Login := FND_GLOBAL.LOGIN_ID;
1365: l_Created_By := FND_GLOBAL.USER_ID;

Line 1362: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

1358: l_full_path VARCHAR2(255);
1359: BEGIN
1360: l_init_msg_list := FND_API.G_FALSE;
1361: l_commit := FND_API.G_FALSE;
1362: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1363: l_Last_Updated_By := FND_GLOBAL.USER_ID;
1364: l_Last_Update_Login := FND_GLOBAL.LOGIN_ID;
1365: l_Created_By := FND_GLOBAL.USER_ID;
1366:

Line 1412: l_return_status := FND_API.G_RET_STS_SUCCESS;

1408: FETCH c_pf_target INTO l_cc_pf_target;
1409: EXIT WHEN c_pf_target%NOTFOUND;
1410:
1411: /* Update PF Line History */
1412: l_return_status := FND_API.G_RET_STS_SUCCESS;
1413: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row(
1414: l_api_version,
1415: l_init_msg_list,
1416: l_commit,

Line 1463: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1459: IF (g_debug_mode = 'Y') THEN
1460: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Payment Forecast History Insert '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1461: END IF;
1462:
1463: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1464: THEN
1465: IF (g_debug_mode = 'Y') THEN
1466: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Insert Payment Forecast History Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1467: END IF;

Line 1534: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1530: IF (g_debug_mode = 'Y') THEN
1531: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Payment Forecast Update '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1532: END IF;
1533:
1534: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1535: THEN
1536: IF (g_debug_mode = 'Y') THEN
1537: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Update Payment Forecast Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1538: END IF;

Line 1557: l_return_status := FND_API.G_RET_STS_SUCCESS;

1553: FETCH c_pf_lines INTO l_cc_pmt_fcst_rec;
1554: EXIT WHEN c_pf_lines%NOTFOUND;
1555:
1556: /* Update PF Line History */
1557: l_return_status := FND_API.G_RET_STS_SUCCESS;
1558: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row(
1559: l_api_version,
1560: l_init_msg_list,
1561: l_commit,

Line 1608: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1604: IF (g_debug_mode = 'Y') THEN
1605: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Insert Payment Forecast history '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1606: END IF;
1607:
1608: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1609: THEN
1610: IF (g_debug_mode = 'Y') THEN
1611: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Insert Payment Forecast history Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1612: END IF;

Line 1693: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1689: G_FLAG );
1690: IF (g_debug_mode = 'Y') THEN
1691: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Update Payment Forecast '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1692: END IF;
1693: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1694: THEN
1695: IF (g_debug_mode = 'Y') THEN
1696: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Update Payment Forecast Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1697: END IF;

Line 1785: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1781: IF (g_debug_mode = 'Y') THEN
1782: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Header Update'|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1783: END IF;
1784:
1785: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1786: THEN
1787: IF (g_debug_mode = 'Y') THEN
1788: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Header Update Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1789: END IF;

Line 1826: l_return_status := FND_API.G_RET_STS_SUCCESS;

1822: AND cchd.cc_num = pha1.segment1
1823: AND pha1.type_lookup_code = 'STANDARD'
1824: AND pha1.org_id = p_org_id;
1825:
1826: l_return_status := FND_API.G_RET_STS_SUCCESS;
1827: IF (g_debug_mode = 'Y') THEN
1828: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Before Update PO '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1829: END IF;
1830: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,

Line 1831: FND_API.G_FALSE,

1827: IF (g_debug_mode = 'Y') THEN
1828: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Before Update PO '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1829: END IF;
1830: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,
1831: FND_API.G_FALSE,
1832: FND_API.G_TRUE,
1833: FND_API.G_VALID_LEVEL_NONE,
1834: l_return_status,
1835: l_msg_count,

Line 1832: FND_API.G_TRUE,

1828: Output_Debug (l_full_path, ' IGCCMPSB -- ************ Before Update PO '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1829: END IF;
1830: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,
1831: FND_API.G_FALSE,
1832: FND_API.G_TRUE,
1833: FND_API.G_VALID_LEVEL_NONE,
1834: l_return_status,
1835: l_msg_count,
1836: l_msg_data,

Line 1833: FND_API.G_VALID_LEVEL_NONE,

1829: END IF;
1830: IGC_CC_PO_INTERFACE_PKG.Convert_CC_TO_PO(1.0,
1831: FND_API.G_FALSE,
1832: FND_API.G_TRUE,
1833: FND_API.G_VALID_LEVEL_NONE,
1834: l_return_status,
1835: l_msg_count,
1836: l_msg_data,
1837: l_cc_headers_rec.cc_header_id);

Line 1841: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1837: l_cc_headers_rec.cc_header_id);
1838: IF (g_debug_mode = 'Y') THEN
1839: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Update PO '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1840: END IF;
1841: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1842: THEN
1843: IF (g_debug_mode = 'Y') THEN
1844: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Update PO Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1845: END IF;

Line 1894: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1890: l_Created_By);
1891: IF (g_debug_mode = 'Y') THEN
1892: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Insert Action History '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1893: END IF;
1894: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1895: THEN
1896: IF (g_debug_mode = 'Y') THEN
1897: Output_Debug (l_full_path, ' IGCCMPSB -- ************ After Insert Action History Failure '|| to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************');
1898: END IF;

Line 2300: l_valid_params := fnd_api.g_false;

2296: l_full_path := g_path || 'MPFS_MAIN';
2297: l_request_id1 := fnd_global.conc_request_id;
2298: l_process_type := 'M';
2299: l_rec_found := 1;
2300: l_valid_params := fnd_api.g_false;
2301: l_cc_inprocess := fnd_api.g_false;
2302: l_gl_period_open := fnd_api.g_false;
2303: l_cc_period_open := fnd_api.g_false;
2304: l_validate_cc := fnd_api.g_true;

Line 2301: l_cc_inprocess := fnd_api.g_false;

2297: l_request_id1 := fnd_global.conc_request_id;
2298: l_process_type := 'M';
2299: l_rec_found := 1;
2300: l_valid_params := fnd_api.g_false;
2301: l_cc_inprocess := fnd_api.g_false;
2302: l_gl_period_open := fnd_api.g_false;
2303: l_cc_period_open := fnd_api.g_false;
2304: l_validate_cc := fnd_api.g_true;
2305: l_source_pf_cc_prd := fnd_api.g_true;

Line 2302: l_gl_period_open := fnd_api.g_false;

2298: l_process_type := 'M';
2299: l_rec_found := 1;
2300: l_valid_params := fnd_api.g_false;
2301: l_cc_inprocess := fnd_api.g_false;
2302: l_gl_period_open := fnd_api.g_false;
2303: l_cc_period_open := fnd_api.g_false;
2304: l_validate_cc := fnd_api.g_true;
2305: l_source_pf_cc_prd := fnd_api.g_true;
2306: l_source_pf_gl_prd := fnd_api.g_true;

Line 2303: l_cc_period_open := fnd_api.g_false;

2299: l_rec_found := 1;
2300: l_valid_params := fnd_api.g_false;
2301: l_cc_inprocess := fnd_api.g_false;
2302: l_gl_period_open := fnd_api.g_false;
2303: l_cc_period_open := fnd_api.g_false;
2304: l_validate_cc := fnd_api.g_true;
2305: l_source_pf_cc_prd := fnd_api.g_true;
2306: l_source_pf_gl_prd := fnd_api.g_true;
2307: l_target_pf_found := fnd_api.g_false;

Line 2304: l_validate_cc := fnd_api.g_true;

2300: l_valid_params := fnd_api.g_false;
2301: l_cc_inprocess := fnd_api.g_false;
2302: l_gl_period_open := fnd_api.g_false;
2303: l_cc_period_open := fnd_api.g_false;
2304: l_validate_cc := fnd_api.g_true;
2305: l_source_pf_cc_prd := fnd_api.g_true;
2306: l_source_pf_gl_prd := fnd_api.g_true;
2307: l_target_pf_found := fnd_api.g_false;
2308: l_tgt_gl_open := fnd_api.g_false;

Line 2305: l_source_pf_cc_prd := fnd_api.g_true;

2301: l_cc_inprocess := fnd_api.g_false;
2302: l_gl_period_open := fnd_api.g_false;
2303: l_cc_period_open := fnd_api.g_false;
2304: l_validate_cc := fnd_api.g_true;
2305: l_source_pf_cc_prd := fnd_api.g_true;
2306: l_source_pf_gl_prd := fnd_api.g_true;
2307: l_target_pf_found := fnd_api.g_false;
2308: l_tgt_gl_open := fnd_api.g_false;
2309: l_tgt_cc_open := fnd_api.g_false;

Line 2306: l_source_pf_gl_prd := fnd_api.g_true;

2302: l_gl_period_open := fnd_api.g_false;
2303: l_cc_period_open := fnd_api.g_false;
2304: l_validate_cc := fnd_api.g_true;
2305: l_source_pf_cc_prd := fnd_api.g_true;
2306: l_source_pf_gl_prd := fnd_api.g_true;
2307: l_target_pf_found := fnd_api.g_false;
2308: l_tgt_gl_open := fnd_api.g_false;
2309: l_tgt_cc_open := fnd_api.g_false;
2310: l_result_of_reservation := 'F';

Line 2307: l_target_pf_found := fnd_api.g_false;

2303: l_cc_period_open := fnd_api.g_false;
2304: l_validate_cc := fnd_api.g_true;
2305: l_source_pf_cc_prd := fnd_api.g_true;
2306: l_source_pf_gl_prd := fnd_api.g_true;
2307: l_target_pf_found := fnd_api.g_false;
2308: l_tgt_gl_open := fnd_api.g_false;
2309: l_tgt_cc_open := fnd_api.g_false;
2310: l_result_of_reservation := 'F';
2311: l_result_mpfs_update := 'F';

Line 2308: l_tgt_gl_open := fnd_api.g_false;

2304: l_validate_cc := fnd_api.g_true;
2305: l_source_pf_cc_prd := fnd_api.g_true;
2306: l_source_pf_gl_prd := fnd_api.g_true;
2307: l_target_pf_found := fnd_api.g_false;
2308: l_tgt_gl_open := fnd_api.g_false;
2309: l_tgt_cc_open := fnd_api.g_false;
2310: l_result_of_reservation := 'F';
2311: l_result_mpfs_update := 'F';
2312: l_fail := fnd_api.g_false;

Line 2309: l_tgt_cc_open := fnd_api.g_false;

2305: l_source_pf_cc_prd := fnd_api.g_true;
2306: l_source_pf_gl_prd := fnd_api.g_true;
2307: l_target_pf_found := fnd_api.g_false;
2308: l_tgt_gl_open := fnd_api.g_false;
2309: l_tgt_cc_open := fnd_api.g_false;
2310: l_result_of_reservation := 'F';
2311: l_result_mpfs_update := 'F';
2312: l_fail := fnd_api.g_false;
2313:

Line 2312: l_fail := fnd_api.g_false;

2308: l_tgt_gl_open := fnd_api.g_false;
2309: l_tgt_cc_open := fnd_api.g_false;
2310: l_result_of_reservation := 'F';
2311: l_result_mpfs_update := 'F';
2312: l_fail := fnd_api.g_false;
2313:
2314: -- 01/03/02, check to see if CC is installed
2315: IF NOT igi_gen.is_req_installed ('CC')
2316: THEN

Line 2343: l_debug := fnd_api.g_true;

2339: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
2340: -- IF (l_debug = 'Y') THEN
2341: IF (g_debug_mode = 'Y')
2342: THEN
2343: l_debug := fnd_api.g_true;
2344: ELSE
2345: l_debug := fnd_api.g_false;
2346: END IF;
2347:

Line 2345: l_debug := fnd_api.g_false;

2341: IF (g_debug_mode = 'Y')
2342: THEN
2343: l_debug := fnd_api.g_true;
2344: ELSE
2345: l_debug := fnd_api.g_false;
2346: END IF;
2347:
2348: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
2349: IF (g_debug_mode = 'Y')

Line 2348: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

2344: ELSE
2345: l_debug := fnd_api.g_false;
2346: END IF;
2347:
2348: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
2349: IF (g_debug_mode = 'Y')
2350: THEN
2351: output_debug
2352: (l_full_path,

Line 2511: --l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

2507: l_error_text := '';
2508:
2509: FOR l_cur IN 1 .. l_msg_count
2510: LOOP
2511: --l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2512: l_error_text :=
2513: l_cur || ' ' || fnd_msg_pub.get (l_cur, fnd_api.g_false);
2514: fnd_file.put_line (fnd_file.LOG, l_error_text);
2515:

Line 2513: l_cur || ' ' || fnd_msg_pub.get (l_cur, fnd_api.g_false);

2509: FOR l_cur IN 1 .. l_msg_count
2510: LOOP
2511: --l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2512: l_error_text :=
2513: l_cur || ' ' || fnd_msg_pub.get (l_cur, fnd_api.g_false);
2514: fnd_file.put_line (fnd_file.LOG, l_error_text);
2515:
2516: IF (g_excep_level >= g_debug_level)
2517: THEN

Line 2606: IF fnd_api.to_boolean (l_valid_params)

2602: || ' *************************'
2603: );
2604: END IF;
2605:
2606: IF fnd_api.to_boolean (l_valid_params)
2607: THEN
2608: /* Select the contracts based on the parameters */
2609: /* Selection and Filteration Phase Starts */
2610: l_exception := NULL;

Line 2650: l_fail := fnd_api.g_true;

2646: l_exception, l_org_id, l_sob_id,
2647: l_request_id1
2648: );
2649:
2650: l_fail := fnd_api.g_true;
2651: END IF;
2652:
2653: EXIT WHEN c1%NOTFOUND;
2654:

Line 2769: l_fail := fnd_api.g_true;

2765: l_exception, l_org_id, l_sob_id,
2766: l_request_id1
2767: );
2768:
2769: l_fail := fnd_api.g_true;
2770: END IF;
2771:
2772: EXIT WHEN c2%NOTFOUND;
2773:

Line 2852: l_fail := fnd_api.g_true;

2848: AND process_type = l_process_type;
2849:
2850: IF l_rec_found = 0 AND l_exception IS NULL
2851: THEN
2852: l_fail := fnd_api.g_true;
2853: fnd_message.set_name ('IGC', 'IGC_CC_NO_RECORD_FOUND');
2854:
2855: IF (g_excep_level >= g_debug_level)
2856: THEN

Line 2873: IF p_process_phase = 'P' AND NOT fnd_api.to_boolean (l_fail)

2869: l_org_id, l_sob_id, l_request_id1
2870: );
2871: END IF;
2872:
2873: IF p_process_phase = 'P' AND NOT fnd_api.to_boolean (l_fail)
2874: THEN
2875: OPEN c4 (l_org_id,
2876: l_sob_id,
2877: l_request_id1,

Line 2898: l_cc_inprocess := fnd_api.g_true;

2894:
2895: -- Bug 1632539 Fixed
2896: IF l_previous_apprvl_status = 'IP'
2897: THEN
2898: l_cc_inprocess := fnd_api.g_true;
2899:
2900: BEGIN
2901: SELECT 'X'
2902: INTO l_dummy

Line 2944: l_cc_inprocess := fnd_api.g_false;

2940: l_org_id, l_sob_id, l_request_id1
2941: );
2942: END;
2943: ELSE
2944: l_cc_inprocess := fnd_api.g_false;
2945: END IF;
2946:
2947: IF (v4.cc_det_pf_date > l_transfer_date)
2948: THEN

Line 2953: IF fnd_api.to_boolean (l_cc_period_open)

2949: -- Bug 1634159 Fixed
2950: l_cc_period_open :=
2951: is_cc_period_open (v4.cc_det_pf_date, l_sob_id, l_org_id);
2952:
2953: IF fnd_api.to_boolean (l_cc_period_open)
2954: THEN
2955: l_source_pf_cc_prd := fnd_api.g_true;
2956:
2957: IF (g_debug_mode = 'Y')

Line 2955: l_source_pf_cc_prd := fnd_api.g_true;

2951: is_cc_period_open (v4.cc_det_pf_date, l_sob_id, l_org_id);
2952:
2953: IF fnd_api.to_boolean (l_cc_period_open)
2954: THEN
2955: l_source_pf_cc_prd := fnd_api.g_true;
2956:
2957: IF (g_debug_mode = 'Y')
2958: THEN
2959: output_debug

Line 2967: l_source_pf_cc_prd := fnd_api.g_false;

2963: || ' *************************'
2964: );
2965: END IF;
2966: ELSE
2967: l_source_pf_cc_prd := fnd_api.g_false;
2968:
2969: IF (g_debug_mode = 'Y')
2970: THEN
2971: output_debug

Line 3013: IF fnd_api.to_boolean (l_gl_period_open)

3009: THEN
3010: l_gl_period_open :=
3011: is_gl_period_open (v4.cc_det_pf_date, l_sob_id);
3012:
3013: IF fnd_api.to_boolean (l_gl_period_open)
3014: THEN
3015: l_source_pf_gl_prd := fnd_api.g_true;
3016:
3017: IF (g_debug_mode = 'Y')

Line 3015: l_source_pf_gl_prd := fnd_api.g_true;

3011: is_gl_period_open (v4.cc_det_pf_date, l_sob_id);
3012:
3013: IF fnd_api.to_boolean (l_gl_period_open)
3014: THEN
3015: l_source_pf_gl_prd := fnd_api.g_true;
3016:
3017: IF (g_debug_mode = 'Y')
3018: THEN
3019: output_debug

Line 3027: l_source_pf_gl_prd := fnd_api.g_false;

3023: || ' *************************'
3024: );
3025: END IF;
3026: ELSE
3027: l_source_pf_gl_prd := fnd_api.g_false;
3028:
3029: IF (g_debug_mode = 'Y')
3030: THEN
3031: output_debug

Line 3077: l_target_pf_found := fnd_api.g_false;

3073: INTO v7;
3074:
3075: IF c7%ROWCOUNT = 0
3076: THEN
3077: l_target_pf_found := fnd_api.g_false;
3078:
3079: BEGIN
3080: SELECT 'X'
3081: INTO l_dummy

Line 3121: l_target_pf_found := fnd_api.g_true;

3117: );
3118: END;
3119: ELSE
3120: -- Bug 1634159 Fixed
3121: l_target_pf_found := fnd_api.g_true;
3122: l_tgt_cc_open :=
3123: is_cc_period_open (v7.cc_det_pf_date, l_sob_id, l_org_id);
3124:
3125: IF fnd_api.to_boolean (l_tgt_cc_open)

Line 3125: IF fnd_api.to_boolean (l_tgt_cc_open)

3121: l_target_pf_found := fnd_api.g_true;
3122: l_tgt_cc_open :=
3123: is_cc_period_open (v7.cc_det_pf_date, l_sob_id, l_org_id);
3124:
3125: IF fnd_api.to_boolean (l_tgt_cc_open)
3126: THEN
3127: l_tgt_cc_open := fnd_api.g_true;
3128: ELSE
3129: l_tgt_cc_open := fnd_api.g_false;

Line 3127: l_tgt_cc_open := fnd_api.g_true;

3123: is_cc_period_open (v7.cc_det_pf_date, l_sob_id, l_org_id);
3124:
3125: IF fnd_api.to_boolean (l_tgt_cc_open)
3126: THEN
3127: l_tgt_cc_open := fnd_api.g_true;
3128: ELSE
3129: l_tgt_cc_open := fnd_api.g_false;
3130:
3131: BEGIN

Line 3129: l_tgt_cc_open := fnd_api.g_false;

3125: IF fnd_api.to_boolean (l_tgt_cc_open)
3126: THEN
3127: l_tgt_cc_open := fnd_api.g_true;
3128: ELSE
3129: l_tgt_cc_open := fnd_api.g_false;
3130:
3131: BEGIN
3132: SELECT 'X'
3133: INTO l_dummy

Line 3182: IF fnd_api.to_boolean (l_tgt_gl_open)

3178: -- Bug 1634218 Fixed
3179: l_tgt_gl_open :=
3180: is_gl_period_open (v7.cc_det_pf_date, l_sob_id);
3181:
3182: IF fnd_api.to_boolean (l_tgt_gl_open)
3183: THEN
3184: l_tgt_gl_open := fnd_api.g_true;
3185: ELSE
3186: l_tgt_gl_open := fnd_api.g_false;

Line 3184: l_tgt_gl_open := fnd_api.g_true;

3180: is_gl_period_open (v7.cc_det_pf_date, l_sob_id);
3181:
3182: IF fnd_api.to_boolean (l_tgt_gl_open)
3183: THEN
3184: l_tgt_gl_open := fnd_api.g_true;
3185: ELSE
3186: l_tgt_gl_open := fnd_api.g_false;
3187:
3188: BEGIN

Line 3186: l_tgt_gl_open := fnd_api.g_false;

3182: IF fnd_api.to_boolean (l_tgt_gl_open)
3183: THEN
3184: l_tgt_gl_open := fnd_api.g_true;
3185: ELSE
3186: l_tgt_gl_open := fnd_api.g_false;
3187:
3188: BEGIN
3189: SELECT 'X'
3190: INTO l_dummy

Line 3252: l_target_pf_found := FND_API.G_FALSE;

3248: AND process_phase = p_process_phase
3249: AND set_of_books_id = l_sob_id
3250: AND request_id = l_request_id1;
3251:
3252: l_target_pf_found := FND_API.G_FALSE;
3253:
3254: EXCEPTION
3255: WHEN NO_DATA_FOUND THEN
3256: OPEN C6(V4.cc_header_id,l_target_date,l_org_id,l_sob_id);

Line 3259: l_target_pf_found := FND_API.G_FALSE;

3255: WHEN NO_DATA_FOUND THEN
3256: OPEN C6(V4.cc_header_id,l_target_date,l_org_id,l_sob_id);
3257: FETCH C6 INTO V6;
3258: IF C6%ROWCOUNT=0 THEN
3259: l_target_pf_found := FND_API.G_FALSE;
3260: l_EXCEPTION := NULL;
3261: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_TGT_PF_NOT_FOUND');
3262: FND_MESSAGE.SET_TOKEN('CC_NUM',V4.cc_num,TRUE);
3263: l_EXCEPTION := FND_MESSAGE.GET;

Line 3286: l_target_pf_found := FND_API.G_TRUE;

3282: l_request_id1);
3283:
3284:
3285: ELSE
3286: l_target_pf_found := FND_API.G_TRUE;
3287: END IF;
3288:
3289: CLOSE C6;
3290: END;

Line 3293: /* Changed FND_API.TO_BOOLEAN(l_cc_inprocess) to NOT NOT FND_API.TO_BOOLEAN(l_cc_inprocess) in the following

3289: CLOSE C6;
3290: END;
3291: */
3292:
3293: /* Changed FND_API.TO_BOOLEAN(l_cc_inprocess) to NOT NOT FND_API.TO_BOOLEAN(l_cc_inprocess) in the following
3294: Statement to fix bug 1689697 */
3295: IF fnd_api.to_boolean (l_source_pf_cc_prd)
3296: AND fnd_api.to_boolean (l_source_pf_gl_prd)
3297: AND fnd_api.to_boolean (l_target_pf_found)

Line 3295: IF fnd_api.to_boolean (l_source_pf_cc_prd)

3291: */
3292:
3293: /* Changed FND_API.TO_BOOLEAN(l_cc_inprocess) to NOT NOT FND_API.TO_BOOLEAN(l_cc_inprocess) in the following
3294: Statement to fix bug 1689697 */
3295: IF fnd_api.to_boolean (l_source_pf_cc_prd)
3296: AND fnd_api.to_boolean (l_source_pf_gl_prd)
3297: AND fnd_api.to_boolean (l_target_pf_found)
3298: AND NOT fnd_api.to_boolean (l_cc_inprocess)
3299: AND fnd_api.to_boolean (l_tgt_gl_open)

Line 3296: AND fnd_api.to_boolean (l_source_pf_gl_prd)

3292:
3293: /* Changed FND_API.TO_BOOLEAN(l_cc_inprocess) to NOT NOT FND_API.TO_BOOLEAN(l_cc_inprocess) in the following
3294: Statement to fix bug 1689697 */
3295: IF fnd_api.to_boolean (l_source_pf_cc_prd)
3296: AND fnd_api.to_boolean (l_source_pf_gl_prd)
3297: AND fnd_api.to_boolean (l_target_pf_found)
3298: AND NOT fnd_api.to_boolean (l_cc_inprocess)
3299: AND fnd_api.to_boolean (l_tgt_gl_open)
3300: THEN

Line 3297: AND fnd_api.to_boolean (l_target_pf_found)

3293: /* Changed FND_API.TO_BOOLEAN(l_cc_inprocess) to NOT NOT FND_API.TO_BOOLEAN(l_cc_inprocess) in the following
3294: Statement to fix bug 1689697 */
3295: IF fnd_api.to_boolean (l_source_pf_cc_prd)
3296: AND fnd_api.to_boolean (l_source_pf_gl_prd)
3297: AND fnd_api.to_boolean (l_target_pf_found)
3298: AND NOT fnd_api.to_boolean (l_cc_inprocess)
3299: AND fnd_api.to_boolean (l_tgt_gl_open)
3300: THEN
3301: UPDATE igc_cc_process_data ccpd

Line 3298: AND NOT fnd_api.to_boolean (l_cc_inprocess)

3294: Statement to fix bug 1689697 */
3295: IF fnd_api.to_boolean (l_source_pf_cc_prd)
3296: AND fnd_api.to_boolean (l_source_pf_gl_prd)
3297: AND fnd_api.to_boolean (l_target_pf_found)
3298: AND NOT fnd_api.to_boolean (l_cc_inprocess)
3299: AND fnd_api.to_boolean (l_tgt_gl_open)
3300: THEN
3301: UPDATE igc_cc_process_data ccpd
3302: SET ccpd.validation_status = 'P'

Line 3299: AND fnd_api.to_boolean (l_tgt_gl_open)

3295: IF fnd_api.to_boolean (l_source_pf_cc_prd)
3296: AND fnd_api.to_boolean (l_source_pf_gl_prd)
3297: AND fnd_api.to_boolean (l_target_pf_found)
3298: AND NOT fnd_api.to_boolean (l_cc_inprocess)
3299: AND fnd_api.to_boolean (l_tgt_gl_open)
3300: THEN
3301: UPDATE igc_cc_process_data ccpd
3302: SET ccpd.validation_status = 'P'
3303: WHERE ccpd.cc_header_id = v4.cc_header_id

Line 3309: l_fail := fnd_api.g_true;

3305: AND ccpd.set_of_books_id = l_sob_id
3306: AND ccpd.request_id = l_request_id1
3307: AND ccpd.process_type = l_process_type;
3308: ELSE
3309: l_fail := fnd_api.g_true;
3310:
3311: UPDATE igc_cc_process_data ccpd
3312: SET ccpd.validation_status = 'F'
3313: WHERE ccpd.cc_header_id = v4.cc_header_id

Line 3337: IF p_process_phase = 'F' AND NOT fnd_api.to_boolean (l_fail)

3333: );
3334: END IF;
3335:
3336: /* Locking CC and PO phase starts */
3337: IF p_process_phase = 'F' AND NOT fnd_api.to_boolean (l_fail)
3338: THEN
3339: OPEN c4_1 (l_org_id,
3340: l_sob_id,
3341: l_request_id1,

Line 3503: l_cc_inprocess := fnd_api.g_true;

3499:
3500: -- Bug 1632539 Fixed
3501: IF l_previous_apprvl_status = 'IP'
3502: THEN
3503: l_cc_inprocess := fnd_api.g_true;
3504:
3505: BEGIN
3506: SELECT 'X'
3507: INTO l_dummy

Line 3551: l_cc_inprocess := fnd_api.g_false;

3547: l_org_id, l_sob_id, l_request_id1
3548: );
3549: END;
3550: ELSE
3551: l_cc_inprocess := fnd_api.g_false;
3552: END IF;
3553:
3554:
3555: IF NOT fnd_api.to_boolean (l_cc_inprocess) THEN

Line 3555: IF NOT fnd_api.to_boolean (l_cc_inprocess) THEN

3551: l_cc_inprocess := fnd_api.g_false;
3552: END IF;
3553:
3554:
3555: IF NOT fnd_api.to_boolean (l_cc_inprocess) THEN
3556: OPEN c4_2 (v4_1.cc_header_id,
3557: l_start_date,
3558: l_end_date,
3559: l_transfer_date);

Line 3580: IF fnd_api.to_boolean (l_cc_period_open)

3576: -- Bug 1634159 Fixed
3577: l_cc_period_open :=
3578: is_cc_period_open (v4_2.cc_det_pf_date, l_sob_id, l_org_id);
3579:
3580: IF fnd_api.to_boolean (l_cc_period_open)
3581: THEN
3582: l_source_pf_cc_prd := fnd_api.g_true;
3583:
3584: IF (g_debug_mode = 'Y')

Line 3582: l_source_pf_cc_prd := fnd_api.g_true;

3578: is_cc_period_open (v4_2.cc_det_pf_date, l_sob_id, l_org_id);
3579:
3580: IF fnd_api.to_boolean (l_cc_period_open)
3581: THEN
3582: l_source_pf_cc_prd := fnd_api.g_true;
3583:
3584: IF (g_debug_mode = 'Y')
3585: THEN
3586: output_debug

Line 3594: l_source_pf_cc_prd := fnd_api.g_false;

3590: || ' *************************'
3591: );
3592: END IF;
3593: ELSE
3594: l_source_pf_cc_prd := fnd_api.g_false;
3595:
3596: IF (g_debug_mode = 'Y')
3597: THEN
3598: output_debug

Line 3644: IF fnd_api.to_boolean (l_gl_period_open)

3640:
3641: l_gl_period_open :=
3642: is_gl_period_open (v4_2.cc_det_pf_date, l_sob_id);
3643:
3644: IF fnd_api.to_boolean (l_gl_period_open)
3645: THEN
3646: l_source_pf_gl_prd := fnd_api.g_true;
3647:
3648: IF (g_debug_mode = 'Y')

Line 3646: l_source_pf_gl_prd := fnd_api.g_true;

3642: is_gl_period_open (v4_2.cc_det_pf_date, l_sob_id);
3643:
3644: IF fnd_api.to_boolean (l_gl_period_open)
3645: THEN
3646: l_source_pf_gl_prd := fnd_api.g_true;
3647:
3648: IF (g_debug_mode = 'Y')
3649: THEN
3650: output_debug

Line 3658: l_source_pf_gl_prd := fnd_api.g_false;

3654: || ' *************************'
3655: );
3656: END IF;
3657: ELSE
3658: l_source_pf_gl_prd := fnd_api.g_false;
3659:
3660: IF (g_debug_mode = 'Y')
3661: THEN
3662: output_debug

Line 3728: l_target_pf_found := fnd_api.g_false;

3724: || ' *************************'
3725: );
3726: END IF;
3727:
3728: l_target_pf_found := fnd_api.g_false;
3729:
3730: BEGIN
3731: SELECT 'X'
3732: INTO l_dummy

Line 3783: l_target_pf_found := fnd_api.g_true;

3779: );
3780: END IF;
3781:
3782: -- Bug 1634159 Fixed
3783: l_target_pf_found := fnd_api.g_true;
3784:
3785: IF (g_debug_mode = 'Y')
3786: THEN
3787: output_debug

Line 3798: IF fnd_api.to_boolean (l_tgt_cc_open)

3794:
3795: l_tgt_cc_open :=
3796: is_cc_period_open (v7.cc_det_pf_date, l_sob_id, l_org_id);
3797:
3798: IF fnd_api.to_boolean (l_tgt_cc_open)
3799: THEN
3800: IF (g_debug_mode = 'Y')
3801: THEN
3802: output_debug

Line 3810: l_tgt_cc_open := fnd_api.g_true;

3806: || ' *************************'
3807: );
3808: END IF;
3809:
3810: l_tgt_cc_open := fnd_api.g_true;
3811: ELSE
3812: IF (g_debug_mode = 'Y')
3813: THEN
3814: output_debug

Line 3822: l_tgt_cc_open := fnd_api.g_false;

3818: || ' *************************'
3819: );
3820: END IF;
3821:
3822: l_tgt_cc_open := fnd_api.g_false;
3823:
3824: BEGIN
3825: SELECT 'X'
3826: INTO l_dummy

Line 3887: IF fnd_api.to_boolean (l_tgt_gl_open)

3883:
3884: l_tgt_gl_open :=
3885: is_gl_period_open (v7.cc_det_pf_date, l_sob_id);
3886:
3887: IF fnd_api.to_boolean (l_tgt_gl_open)
3888: THEN
3889: l_tgt_gl_open := fnd_api.g_true;
3890:
3891: IF (g_debug_mode = 'Y')

Line 3889: l_tgt_gl_open := fnd_api.g_true;

3885: is_gl_period_open (v7.cc_det_pf_date, l_sob_id);
3886:
3887: IF fnd_api.to_boolean (l_tgt_gl_open)
3888: THEN
3889: l_tgt_gl_open := fnd_api.g_true;
3890:
3891: IF (g_debug_mode = 'Y')
3892: THEN
3893: output_debug

Line 3911: l_tgt_gl_open := fnd_api.g_false;

3907: || ' *************************'
3908: );
3909: END IF;
3910:
3911: l_tgt_gl_open := fnd_api.g_false;
3912:
3913: BEGIN
3914: SELECT 'X'
3915: INTO l_dummy

Line 3979: l_target_pf_found := FND_API.G_FALSE;

3975: AND process_phase = p_process_phase
3976: AND set_of_books_id = l_sob_id
3977: AND request_id = l_request_id1;
3978:
3979: l_target_pf_found := FND_API.G_FALSE;
3980:
3981: EXCEPTION
3982: WHEN NO_DATA_FOUND THEN
3983: OPEN C6(V4.cc_header_id,l_target_date,l_org_id,l_sob_id);

Line 3986: l_target_pf_found := FND_API.G_FALSE;

3982: WHEN NO_DATA_FOUND THEN
3983: OPEN C6(V4.cc_header_id,l_target_date,l_org_id,l_sob_id);
3984: FETCH C6 INTO V6;
3985: IF C6%ROWCOUNT=0 THEN
3986: l_target_pf_found := FND_API.G_FALSE;
3987: l_EXCEPTION := NULL;
3988: FND_MESSAGE.SET_NAME('IGC','IGC_CC_MPFS_TGT_PF_NOT_FOUND');
3989: FND_MESSAGE.SET_TOKEN('CC_NUM',V4.cc_num,TRUE);
3990: l_EXCEPTION := FND_MESSAGE.GET;

Line 4013: l_target_pf_found := FND_API.G_TRUE;

4009: l_request_id1);
4010:
4011:
4012: ELSE
4013: l_target_pf_found := FND_API.G_TRUE;
4014: END IF;
4015:
4016: CLOSE C6;
4017: END;

Line 4020: /* Changed FND_API.TO_BOOLEAN(l_cc_inprocess) to NOT NOT FND_API.TO_BOOLEAN(l_cc_inprocess) in the following

4016: CLOSE C6;
4017: END;
4018: */
4019:
4020: /* Changed FND_API.TO_BOOLEAN(l_cc_inprocess) to NOT NOT FND_API.TO_BOOLEAN(l_cc_inprocess) in the following
4021: Statement to fix bug 1689697 */
4022: IF fnd_api.to_boolean (l_source_pf_cc_prd)
4023: AND fnd_api.to_boolean (l_source_pf_gl_prd)
4024: AND fnd_api.to_boolean (l_target_pf_found)

Line 4022: IF fnd_api.to_boolean (l_source_pf_cc_prd)

4018: */
4019:
4020: /* Changed FND_API.TO_BOOLEAN(l_cc_inprocess) to NOT NOT FND_API.TO_BOOLEAN(l_cc_inprocess) in the following
4021: Statement to fix bug 1689697 */
4022: IF fnd_api.to_boolean (l_source_pf_cc_prd)
4023: AND fnd_api.to_boolean (l_source_pf_gl_prd)
4024: AND fnd_api.to_boolean (l_target_pf_found)
4025: AND NOT fnd_api.to_boolean (l_cc_inprocess)
4026: AND fnd_api.to_boolean (l_tgt_gl_open)

Line 4023: AND fnd_api.to_boolean (l_source_pf_gl_prd)

4019:
4020: /* Changed FND_API.TO_BOOLEAN(l_cc_inprocess) to NOT NOT FND_API.TO_BOOLEAN(l_cc_inprocess) in the following
4021: Statement to fix bug 1689697 */
4022: IF fnd_api.to_boolean (l_source_pf_cc_prd)
4023: AND fnd_api.to_boolean (l_source_pf_gl_prd)
4024: AND fnd_api.to_boolean (l_target_pf_found)
4025: AND NOT fnd_api.to_boolean (l_cc_inprocess)
4026: AND fnd_api.to_boolean (l_tgt_gl_open)
4027: THEN

Line 4024: AND fnd_api.to_boolean (l_target_pf_found)

4020: /* Changed FND_API.TO_BOOLEAN(l_cc_inprocess) to NOT NOT FND_API.TO_BOOLEAN(l_cc_inprocess) in the following
4021: Statement to fix bug 1689697 */
4022: IF fnd_api.to_boolean (l_source_pf_cc_prd)
4023: AND fnd_api.to_boolean (l_source_pf_gl_prd)
4024: AND fnd_api.to_boolean (l_target_pf_found)
4025: AND NOT fnd_api.to_boolean (l_cc_inprocess)
4026: AND fnd_api.to_boolean (l_tgt_gl_open)
4027: THEN
4028: IF (g_debug_mode = 'Y')

Line 4025: AND NOT fnd_api.to_boolean (l_cc_inprocess)

4021: Statement to fix bug 1689697 */
4022: IF fnd_api.to_boolean (l_source_pf_cc_prd)
4023: AND fnd_api.to_boolean (l_source_pf_gl_prd)
4024: AND fnd_api.to_boolean (l_target_pf_found)
4025: AND NOT fnd_api.to_boolean (l_cc_inprocess)
4026: AND fnd_api.to_boolean (l_tgt_gl_open)
4027: THEN
4028: IF (g_debug_mode = 'Y')
4029: THEN

Line 4026: AND fnd_api.to_boolean (l_tgt_gl_open)

4022: IF fnd_api.to_boolean (l_source_pf_cc_prd)
4023: AND fnd_api.to_boolean (l_source_pf_gl_prd)
4024: AND fnd_api.to_boolean (l_target_pf_found)
4025: AND NOT fnd_api.to_boolean (l_cc_inprocess)
4026: AND fnd_api.to_boolean (l_tgt_gl_open)
4027: THEN
4028: IF (g_debug_mode = 'Y')
4029: THEN
4030: output_debug

Line 4102: l_fail := fnd_api.g_true;

4098: NULL;
4099: END;
4100: END IF;
4101: ELSE
4102: l_fail := fnd_api.g_true;
4103:
4104: UPDATE igc_cc_process_data ccpd
4105: SET ccpd.validation_status = 'L'
4106: WHERE ccpd.cc_header_id = v4_1.cc_header_id

Line 4116: l_fail := fnd_api.g_true;

4112: END LOOP;
4113: CLOSE c4_2;
4114: END IF;
4115: ELSE
4116: l_fail := fnd_api.g_true;
4117: -- This ends the lock on PO and CC
4118: END IF;
4119: END LOOP;
4120:

Line 4452: l_cur || ' ' || fnd_msg_pub.get (l_cur, fnd_api.g_false);

4448:
4449: FOR l_cur IN 1 .. l_msg_count
4450: LOOP
4451: l_error_text :=
4452: l_cur || ' ' || fnd_msg_pub.get (l_cur, fnd_api.g_false);
4453:
4454: IF (g_excep_level >= g_debug_level)
4455: THEN
4456: fnd_log.STRING (g_excep_level, l_full_path, l_error_text);

Line 4488: || fnd_msg_pub.get (l_cur, fnd_api.g_false);

4484: l_error_text :=
4485: ' Mesg No : '
4486: || l_cur
4487: || ' '
4488: || fnd_msg_pub.get (l_cur, fnd_api.g_false);
4489:
4490: /*fnd_file.put_line (FND_FILE.LOG,
4491: l_error_text);*/
4492: IF (g_excep_level >= g_debug_level)

Line 4545: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

4541: p_filename_val => NULL,
4542: x_Return_Status => l_Return_Status
4543: );
4544:
4545: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
4546: raise FND_API.G_EXC_ERROR;
4547: END IF;*/
4548:
4549: IF (g_state_level >= g_debug_level ) THEN

Line 4546: raise FND_API.G_EXC_ERROR;

4542: x_Return_Status => l_Return_Status
4543: );
4544:
4545: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
4546: raise FND_API.G_EXC_ERROR;
4547: END IF;*/
4548:
4549: IF (g_state_level >= g_debug_level ) THEN
4550: FND_LOG.STRING (g_state_level,p_path,p_debug_msg);

Line 4560: /* WHEN FND_API.G_EXC_ERROR THEN

4556: -- Exception handler section for the Output_Debug procedure.
4557: -- --------------------------------------------------------------------
4558: EXCEPTION
4559:
4560: /* WHEN FND_API.G_EXC_ERROR THEN
4561: RETURN;*/
4562:
4563: WHEN OTHERS THEN
4564: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN