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

Line 986: --Create a credit by calling the Private Credits API with p_validation_level as fnd_api.g_valid_level_none.

982: l_credit_rec.p_lockbox_interface_id := NULL;
983: l_credit_rec.p_batch_name := NULL;
984: l_credit_rec.p_deposit_date := NULL;
985:
986: --Create a credit by calling the Private Credits API with p_validation_level as fnd_api.g_valid_level_none.
987: igs_fi_credit_pvt.create_credit( p_api_version => 2.1,
988: p_init_msg_list => fnd_api.g_false,
989: p_commit => fnd_api.g_false,
990: p_validation_level => fnd_api.g_valid_level_none,

Line 988: p_init_msg_list => fnd_api.g_false,

984: l_credit_rec.p_deposit_date := NULL;
985:
986: --Create a credit by calling the Private Credits API with p_validation_level as fnd_api.g_valid_level_none.
987: igs_fi_credit_pvt.create_credit( p_api_version => 2.1,
988: p_init_msg_list => fnd_api.g_false,
989: p_commit => fnd_api.g_false,
990: p_validation_level => fnd_api.g_valid_level_none,
991: x_return_status => l_ret_status,
992: x_msg_count => l_msg_count,

Line 989: p_commit => fnd_api.g_false,

985:
986: --Create a credit by calling the Private Credits API with p_validation_level as fnd_api.g_valid_level_none.
987: igs_fi_credit_pvt.create_credit( p_api_version => 2.1,
988: p_init_msg_list => fnd_api.g_false,
989: p_commit => fnd_api.g_false,
990: p_validation_level => fnd_api.g_valid_level_none,
991: x_return_status => l_ret_status,
992: x_msg_count => l_msg_count,
993: x_msg_data => l_msg_data,

Line 990: p_validation_level => fnd_api.g_valid_level_none,

986: --Create a credit by calling the Private Credits API with p_validation_level as fnd_api.g_valid_level_none.
987: igs_fi_credit_pvt.create_credit( p_api_version => 2.1,
988: p_init_msg_list => fnd_api.g_false,
989: p_commit => fnd_api.g_false,
990: p_validation_level => fnd_api.g_valid_level_none,
991: x_return_status => l_ret_status,
992: x_msg_count => l_msg_count,
993: x_msg_data => l_msg_data,
994: p_credit_rec => l_credit_rec,

Line 1174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1170:
1171: END validate_neg_amt;
1172:
1173: PROCEDURE create_charge(p_api_version IN NUMBER,
1174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1175: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1177: p_header_rec IN header_rec_type,
1178: p_line_tbl IN Line_Tbl_Type,

Line 1175: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

1171: END validate_neg_amt;
1172:
1173: PROCEDURE create_charge(p_api_version IN NUMBER,
1174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1175: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1177: p_header_rec IN header_rec_type,
1178: p_line_tbl IN Line_Tbl_Type,
1179: x_invoice_id OUT NOCOPY NUMBER,

Line 1176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

1172:
1173: PROCEDURE create_charge(p_api_version IN NUMBER,
1174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1175: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1177: p_header_rec IN header_rec_type,
1178: p_line_tbl IN Line_Tbl_Type,
1179: x_invoice_id OUT NOCOPY NUMBER,
1180: x_line_id_tbl OUT NOCOPY line_id_tbl_type,

Line 1552: IF NOT fnd_api.compatible_api_call( l_api_version,

1548: SAVEPOINT create_charge_pvt;
1549: l_v_igs_fi_auto_calc_waivers := NVL(FND_PROFILE.VALUE('IGS_FI_AUTO_CALC_WAIVERS'),'N');
1550:
1551: -- Check if the API call is compatible
1552: IF NOT fnd_api.compatible_api_call( l_api_version,
1553: p_api_version,
1554: l_api_name,
1555: g_pkg_name) THEN
1556:

Line 1558: RAISE fnd_api.g_exc_unexpected_error;

1554: l_api_name,
1555: g_pkg_name) THEN
1556:
1557: -- If the call is incompatible, then raise the unexpected error
1558: RAISE fnd_api.g_exc_unexpected_error;
1559: END IF;
1560:
1561: l_n_invoice_amount := igs_fi_gen_gl.get_formatted_amount(p_header_rec.p_invoice_amount);
1562:

Line 1568: IF fnd_api.to_boolean(p_init_msg_list) THEN

1564: x_line_id_tbl.DELETE;
1565:
1566: -- If the p_init_msg_list is T, i.e. the calling program wants to initialise
1567: -- the message list, then the message list is initialised using the API call
1568: IF fnd_api.to_boolean(p_init_msg_list) THEN
1569: fnd_msg_pub.initialize;
1570: END IF;
1571:
1572: -- Set the return status as success for the api

Line 1573: x_return_status := fnd_api.g_ret_sts_success;

1569: fnd_msg_pub.initialize;
1570: END IF;
1571:
1572: -- Set the return status as success for the api
1573: x_return_status := fnd_api.g_ret_sts_success;
1574:
1575: -- Get the value of "Manage Accounts" System Option value.
1576: -- If this value is NULL then this process should error out.
1577: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,

Line 1582: RAISE fnd_api.g_exc_error;

1578: p_v_message_name => l_v_message_name );
1579: IF l_v_manage_accounts IS NULL THEN
1580: fnd_message.set_name ( 'IGS', l_v_message_name );
1581: fnd_msg_pub.add;
1582: RAISE fnd_api.g_exc_error;
1583: END IF;
1584:
1585: -- Fetch the record from the Control table.
1586: OPEN cur_ctrl;

Line 1593: RAISE fnd_api.g_exc_error;

1589: --If Oracle General Ledger is not installed and Account Conversion Flag is null, raise error.
1590: IF l_ctrl_rec.rec_installed = 'N' AND l_ctrl_rec.acct_conv_flag IS NULL THEN
1591: fnd_message.set_name('IGS','IGS_FI_ACCT_CONV_NOTRUN');
1592: fnd_msg_pub.add;
1593: RAISE fnd_api.g_exc_error;
1594: END IF;
1595:
1596: g_v_manage_accounts := l_v_manage_accounts;
1597: l_v_message_name := NULL;

Line 1610: RAISE fnd_api.g_exc_error;

1606: --If Holds Balance conversion process is running..error out from Charges API.
1607: IF l_cnv_prc = 1 AND l_message_name IS NULL THEN
1608: fnd_message.set_name('IGS','IGS_FI_REASS_BAL_PRC_RUN');
1609: fnd_msg_pub.add;
1610: RAISE fnd_api.g_exc_error;
1611: END IF;
1612:
1613: IF l_message_name IS NOT NULL THEN
1614: fnd_message.set_name('IGS',l_message_name);

Line 1616: RAISE fnd_api.g_exc_error;

1612:
1613: IF l_message_name IS NOT NULL THEN
1614: fnd_message.set_name('IGS',l_message_name);
1615: fnd_msg_pub.add;
1616: RAISE fnd_api.g_exc_error;
1617: END IF;
1618:
1619: --Get the latest active balance rule for 'HOLDS' balance type.
1620: igs_fi_gen_007.finp_get_balance_rule(

Line 1632: RAISE fnd_api.g_exc_error;

1628: --If no active balance rule exists for 'HOLDS', error out Charges API.
1629: IF l_version_number = 0 THEN
1630: fnd_message.set_name('IGS','IGS_FI_CANNOT_CRT_TXN');
1631: fnd_msg_pub.add;
1632: RAISE fnd_api.g_exc_error;
1633: END IF;
1634: END IF;
1635:
1636: -- Check if there are records in the Lines table being input to API

Line 1642: RAISE fnd_api.g_exc_error;

1638: IF p_line_tbl.COUNT = 0 THEN
1639: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1640: fnd_message.set_name('IGS','IGS_FI_SAT_NO_ROWS_FOUND');
1641: fnd_msg_pub.add;
1642: RAISE fnd_api.g_exc_error;
1643: END IF;
1644: END IF;
1645:
1646: --Following validations are not necessary to be performed in case of negative charges

Line 1661: RAISE fnd_api.g_exc_error;

1657: l_valid := FALSE;
1658: fnd_message.set_name('IGS','IGS_FI_INVALID_PERSON');
1659: fnd_message.set_token('PERSON_ID',TO_CHAR(p_header_rec.p_person_id));
1660: fnd_msg_pub.add;
1661: RAISE fnd_api.g_exc_error;
1662: END IF;
1663: END IF;
1664:
1665:

Line 1687: RAISE fnd_api.g_exc_error;

1683: fnd_message.set_name('IGS','IGS_FI_INVALID_FTCI');
1684: fnd_message.set_token('FEE_TYPE',p_header_rec.p_fee_type);
1685: fnd_message.set_token('CI_DESC',l_v_fee_ci_desc);
1686: fnd_msg_pub.add;
1687: RAISE fnd_api.g_exc_error;
1688: END IF;
1689: END IF;
1690: -- call the function for validating the Fee Category Fee Liability
1691: IF p_header_rec.p_fee_cat IS NOT NULL THEN

Line 1705: RAISE fnd_api.g_exc_error;

1701: fnd_message.set_name('IGS','IGS_FI_INVALID_FCFL');
1702: fnd_message.set_token('FEE_CAT',p_header_rec.p_fee_cat);
1703: fnd_message.set_token('FEE_TYPE',p_header_rec.p_fee_type);
1704: fnd_msg_pub.add;
1705: RAISE fnd_api.g_exc_error;
1706: END IF;
1707: END IF;
1708: END IF;
1709: -- Call the function for validating the Program

Line 1721: RAISE fnd_api.g_exc_error;

1717: l_valid := FALSE;
1718: fnd_message.set_name('IGS','IGS_FI_INVALID_COURSE');
1719: fnd_message.set_token('COURSE_CD',p_header_rec.p_course_cd);
1720: fnd_msg_pub.add;
1721: RAISE fnd_api.g_exc_error;
1722: END IF;
1723: END IF;
1724: END IF;
1725:

Line 1741: RAISE fnd_api.g_exc_error;

1737: l_valid := FALSE;
1738: fnd_message.set_name('IGS','IGS_FI_INVALID_TXN_TYPE');
1739: fnd_message.set_token('TXN_TYPE',p_header_rec.p_transaction_type);
1740: fnd_msg_pub.add;
1741: RAISE fnd_api.g_exc_error;
1742: END IF;
1743: END IF;
1744:
1745: -- Validate if the currency code passed is a valid currency code

Line 1757: RAISE fnd_api.g_exc_error;

1753: l_valid := FALSE;
1754: fnd_message.set_name('IGS','IGS_FI_INVALID_CUR');
1755: fnd_message.set_token('CUR_CD',p_header_rec.p_currency_cd);
1756: fnd_msg_pub.add;
1757: RAISE fnd_api.g_exc_error;
1758: END IF;
1759: END IF;
1760: --3392095 check for waiver_name
1761: IF p_header_rec.p_waiver_name IS NOT NULL THEN

Line 1781: RAISE fnd_api.g_exc_error;

1777: fnd_message.set_name('IGS','IGS_FI_WAV_PGM_NO_REC_FOUND');
1778: fnd_message.set_token('FEE_ALT_CD',l_v_fee_alt_cd);
1779: fnd_message.set_token('FEE_TYPE',p_header_rec.p_fee_type);
1780: fnd_msg_pub.add;
1781: RAISE fnd_api.g_exc_error;
1782: END IF;
1783: END IF;
1784: CLOSE cur_waiver;
1785:

Line 1797: RAISE fnd_api.g_exc_error;

1793: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1794: fnd_message.set_name('IGS','IGS_FI_CAPI_CRD_INSTR_NULL');
1795: fnd_message.set_token('CR_INSTR',g_adj);
1796: fnd_msg_pub.add;
1797: RAISE fnd_api.g_exc_error;
1798: END IF;
1799: END IF;
1800:
1801:

Line 1827: RAISE fnd_api.g_exc_error;

1823:
1824: -- If the global variable has been set to false, then this means
1825: -- that one of the charge methods were invalid, hence error out.
1826: IF NOT l_valid THEN
1827: RAISE fnd_api.g_exc_error;
1828: END IF;
1829: -- Loop through the table for the Unit Section
1830: FOR l_var IN p_line_tbl.FIRST..p_line_tbl.LAST LOOP
1831:

Line 1860: RAISE fnd_api.g_exc_error;

1856:
1857: -- If the global variable has been set to false, then this means
1858: -- that one of the Unit Sections were invalid, hence error out.
1859: IF NOT l_valid THEN
1860: RAISE fnd_api.g_exc_error;
1861: END IF;
1862:
1863:
1864: -- Loop through the table

Line 1890: RAISE fnd_api.g_exc_error;

1886:
1887: -- If the global variable has been set to false, then this means
1888: -- that one of the Org_Unit_Cd were invalid, hence error out.
1889: IF NOT l_valid THEN
1890: RAISE fnd_api.g_exc_error;
1891: END IF;
1892:
1893:
1894: -- If the Source Transaction Id is not null

Line 1910: RAISE fnd_api.g_exc_error;

1906: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1907: l_valid := FALSE;
1908: fnd_message.set_name('IGS','IGS_FI_INVALID_SRC_TXN_ID');
1909: fnd_msg_pub.add;
1910: RAISE fnd_api.g_exc_error;
1911: END IF;
1912: END IF;
1913: END IF;
1914:

Line 1918: RAISE fnd_api.g_exc_error;

1914:
1915: -- If the global boolean flag has been set, then
1916: -- error out.
1917: IF NOT l_valid THEN
1918: RAISE fnd_api.g_exc_error;
1919: END IF;
1920: END IF;
1921:
1922:

Line 1948: RAISE fnd_api.g_exc_error;

1944: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1945: l_valid := FALSE;
1946: fnd_message.set_name('IGS','IGS_FI_SRC_TXN_ACC_INV');
1947: fnd_msg_pub.add;
1948: RAISE fnd_api.g_exc_error;
1949: END IF;
1950: ELSIF l_val_neg_amnt = 2 THEN
1951: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1952: l_valid := FALSE;

Line 1955: RAISE fnd_api.g_exc_error;

1951: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1952: l_valid := FALSE;
1953: fnd_message.set_name('IGS','IGS_FI_INVALID_INV_AMT');
1954: fnd_msg_pub.add;
1955: RAISE fnd_api.g_exc_error;
1956: END IF;
1957: END IF;
1958:
1959: l_rec_exist := FALSE;

Line 2001: RAISE fnd_api.g_exc_error;

1997: IF l_err_msg IS NOT NULL THEN
1998: fnd_message.set_name('IGS',l_err_msg);
1999: fnd_msg_pub.add;
2000: END IF;
2001: RAISE fnd_api.g_exc_error;
2002: END IF;
2003: END IF;
2004: END IF; -- End if for IF l_adj_amt > 0 THEN
2005: END IF; -- End if for IF NOT(chk_charge_adjusted())

Line 2063: RAISE fnd_api.g_exc_error;

2059: IF l_err_msg IS NOT NULL THEN
2060: fnd_message.set_name('IGS',l_err_msg);
2061: fnd_msg_pub.add;
2062: END IF;
2063: RAISE fnd_api.g_exc_error;
2064: END IF;
2065: END IF;
2066: ELSE
2067: EXIT;

Line 2124: RAISE fnd_api.g_exc_error;

2120: IF l_err_msg IS NOT NULL THEN
2121: fnd_message.set_name('IGS',l_err_msg);
2122: fnd_msg_pub.add;
2123: END IF;
2124: RAISE fnd_api.g_exc_error;
2125: END IF;
2126: END IF;
2127: END IF; -- End if for IF (NVL(l_adj_amt,0) > 0) THEN
2128: END IF; -- End if for NOT(chk_charge_adjusted)

Line 2182: RAISE fnd_api.g_exc_error;

2178: IF l_err_msg IS NOT NULL THEN
2179: fnd_message.set_name('IGS',l_err_msg);
2180: fnd_msg_pub.add;
2181: END IF;
2182: RAISE fnd_api.g_exc_error;
2183: END IF;
2184: END IF;
2185: END IF; -- End if for IF (NVL(l_adj_amt,0) > 0) THEN
2186: END IF; -- End if for NOT(chk_charge_adjusted)

Line 2290: RAISE fnd_api.g_exc_error;

2286: IF l_flag =1 THEN
2287: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2288: fnd_message.set_name('IGS',l_error_string);
2289: fnd_msg_pub.add;
2290: RAISE fnd_api.g_exc_error;
2291: END IF;
2292: l_error_account := 'Y';
2293: ELSIF l_flag =2 THEN
2294: -- if the transaction type is Document then the user should not be allowed to create

Line 2302: RAISE fnd_api.g_exc_error;

2298: IF p_header_rec.p_transaction_type = 'DOCUMENT' THEN
2299: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2300: fnd_message.set_name('IGS','IGS_FI_SRC_TXN_ACC_INV');
2301: fnd_msg_pub.add;
2302: RAISE fnd_api.g_exc_error;
2303: END IF;
2304: END IF;
2305: ELSE
2306: l_error_account := 'N';

Line 2399: RAISE fnd_api.g_exc_error;

2395: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2396: l_valid := FALSE;
2397: fnd_message.set_name('IGS',l_message_name);
2398: fnd_msg_pub.add;
2399: RAISE fnd_api.g_exc_error;
2400: END IF;
2401: END IF;
2402: END IF;
2403:

Line 2436: RAISE fnd_api.g_exc_error;

2432: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2433: l_valid := FALSE;
2434: fnd_message.set_name('IGS',l_message_name);
2435: fnd_msg_pub.add;
2436: RAISE fnd_api.g_exc_error;
2437: END IF;
2438: END IF;
2439: END IF;
2440: EXCEPTION

Line 2528: IF ((fnd_api.to_boolean(p_commit)) AND (l_valid)) THEN

2524:
2525: -- If the p_commit parameter is set to True and no errors have been raised by the
2526: -- balances process,
2527: -- then commit the work
2528: IF ((fnd_api.to_boolean(p_commit)) AND (l_valid)) THEN
2529: COMMIT WORK;
2530: END IF;
2531:
2532: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2536: WHEN fnd_api.g_exc_error THEN

2532: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2533: p_data => x_msg_data);
2534:
2535: EXCEPTION
2536: WHEN fnd_api.g_exc_error THEN
2537: ROLLBACK TO create_charge_pvt;
2538: x_return_status := fnd_api.g_ret_sts_error;
2539: fnd_msg_pub.count_and_get( p_count => x_msg_count,
2540: p_data => x_msg_data);

Line 2538: x_return_status := fnd_api.g_ret_sts_error;

2534:
2535: EXCEPTION
2536: WHEN fnd_api.g_exc_error THEN
2537: ROLLBACK TO create_charge_pvt;
2538: x_return_status := fnd_api.g_ret_sts_error;
2539: fnd_msg_pub.count_and_get( p_count => x_msg_count,
2540: p_data => x_msg_data);
2541:
2542: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2542: WHEN fnd_api.g_exc_unexpected_error THEN

2538: x_return_status := fnd_api.g_ret_sts_error;
2539: fnd_msg_pub.count_and_get( p_count => x_msg_count,
2540: p_data => x_msg_data);
2541:
2542: WHEN fnd_api.g_exc_unexpected_error THEN
2543: ROLLBACK TO create_charge_pvt;
2544: x_return_status := fnd_api.g_ret_sts_unexp_error;
2545: fnd_msg_pub.count_and_get( p_count => x_msg_count,
2546: p_data => x_msg_data);

Line 2544: x_return_status := fnd_api.g_ret_sts_unexp_error;

2540: p_data => x_msg_data);
2541:
2542: WHEN fnd_api.g_exc_unexpected_error THEN
2543: ROLLBACK TO create_charge_pvt;
2544: x_return_status := fnd_api.g_ret_sts_unexp_error;
2545: fnd_msg_pub.count_and_get( p_count => x_msg_count,
2546: p_data => x_msg_data);
2547:
2548: WHEN OTHERS THEN

Line 2550: x_return_status := fnd_api.g_ret_sts_unexp_error;

2546: p_data => x_msg_data);
2547:
2548: WHEN OTHERS THEN
2549: ROLLBACK TO create_charge_pvt;
2550: x_return_status := fnd_api.g_ret_sts_unexp_error;
2551:
2552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2553: fnd_msg_pub.add_exc_msg(g_pkg_name,
2554: l_api_name);