APPS.CST_ACCRUAL_REC_PVT dependencies on FND_API

Line 192: -- FND_API.G_TRUE => 'Y'

188: -- IN : p_row_id IN VARCHAR2 Required
189: -- Row Identifier
190: -- : p_bit IN VARCHAR2 Required
191: -- Determines whether to set the column to 'Y' or NULL
192: -- FND_API.G_TRUE => 'Y'
193: -- FND_API.G_FALSE => NULL
194: -- : p_prog IN NUMBER Required
195: -- Codes which tables's write_off_select_flag column will be altered
196: -- 0 => cst_reconciliation_summary (AP and PO Form)

Line 193: -- FND_API.G_FALSE => NULL

189: -- Row Identifier
190: -- : p_bit IN VARCHAR2 Required
191: -- Determines whether to set the column to 'Y' or NULL
192: -- FND_API.G_TRUE => 'Y'
193: -- FND_API.G_FALSE => NULL
194: -- : p_prog IN NUMBER Required
195: -- Codes which tables's write_off_select_flag column will be altered
196: -- 0 => cst_reconciliation_summary (AP and PO Form)
197: -- 1 => cst_misc_reconciliation (Miscellaneous Form)

Line 201: -- FND_API.G_TRUE => Success

197: -- 1 => cst_misc_reconciliation (Miscellaneous Form)
198: -- 2 => cst_write_offs (View Write-Offs Form)
199: -- OUT : x_count OUT NOCOPY VARCHAR2 Required
200: -- Succes Indicator
201: -- FND_API.G_TRUE => Success
202: -- FND_API.G_FALSE => Failure
203: -- : x_err_num OUT NOCOPY NUMBER Required
204: -- Standard Error Parameter
205: -- : x_err_code OUT NOCOPY VARCHAR2 Required

Line 202: -- FND_API.G_FALSE => Failure

198: -- 2 => cst_write_offs (View Write-Offs Form)
199: -- OUT : x_count OUT NOCOPY VARCHAR2 Required
200: -- Succes Indicator
201: -- FND_API.G_TRUE => Success
202: -- FND_API.G_FALSE => Failure
203: -- : x_err_num OUT NOCOPY NUMBER Required
204: -- Standard Error Parameter
205: -- : x_err_code OUT NOCOPY VARCHAR2 Required
206: -- Standard Error Parameter

Line 252: if(fnd_api.to_boolean(p_bit)) then

248: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'Table Select: ' || to_char(p_prog));
249:
250: l_stmt_num := 10;
251:
252: if(fnd_api.to_boolean(p_bit)) then
253: --{
254: if(p_prog = 0) then
255: --{
256: update cst_reconciliation_summary

Line 274: elsif(not fnd_api.to_boolean(p_bit)) then

270: where rowid = p_row_id;
271: --}
272: end if; /* p_prog=0, p_prog=1, p_prog=2 */
273: --}
274: elsif(not fnd_api.to_boolean(p_bit)) then
275: --{
276: if(p_prog = 0) then
277: --{
278: update cst_reconciliation_summary

Line 296: end if; /* fnd_api.to_boolean(p_bit) */

292: where rowid = p_row_id;
293: --}
294: end if; /* p_prog=0, p_prog=1, p_prog=2 */
295: --}
296: end if; /* fnd_api.to_boolean(p_bit) */
297:
298: x_count := fnd_api.g_true;
299: return;
300:

Line 298: x_count := fnd_api.g_true;

294: end if; /* p_prog=0, p_prog=1, p_prog=2 */
295: --}
296: end if; /* fnd_api.to_boolean(p_bit) */
297:
298: x_count := fnd_api.g_true;
299: return;
300:
301: exception
302: when others then

Line 305: x_count := fnd_api.g_false;

301: exception
302: when others then
303: --{
304: rollback;
305: x_count := fnd_api.g_false;
306: x_err_num := SQLCODE;
307: x_err_code := NULL;
308: x_err_msg := 'CST_Accrual_Rec_PVT.flip_flag() ' || SQLERRM;
309: fnd_message.set_name('BOM','CST_UNEXPECTED');

Line 1554: -- FND_API.G_TRUE => Reversible

1550: -- : p_ou_id IN NUMBER Required
1551: -- Operating Unit Identifier
1552: -- OUT : x_count OUT NOCOPY NUBMER Required
1553: -- Reversible Indicator
1554: -- FND_API.G_TRUE => Reversible
1555: -- FND_API.G_FALSE => Not Reversible
1556: -- : x_err_num OUT NOCOPY NUMBER Required
1557: -- Standard Error Parameter
1558: -- : x_err_code OUT NOCOPY VARCHAR2 Required

Line 1555: -- FND_API.G_FALSE => Not Reversible

1551: -- Operating Unit Identifier
1552: -- OUT : x_count OUT NOCOPY NUBMER Required
1553: -- Reversible Indicator
1554: -- FND_API.G_TRUE => Reversible
1555: -- FND_API.G_FALSE => Not Reversible
1556: -- : x_err_num OUT NOCOPY NUMBER Required
1557: -- Standard Error Parameter
1558: -- : x_err_code OUT NOCOPY VARCHAR2 Required
1559: -- Standard Error Parameter

Line 1649: x_count := fnd_api.g_true;

1645: if(l_enabled = 0) then
1646: --{
1647: l_stmt_num := 30;
1648: /* If all the tests pass, write-off is reversible */
1649: x_count := fnd_api.g_true;
1650: return;
1651: --}
1652: end if; /* l_enabled = 0 */
1653: --}

Line 1661: x_count := fnd_api.g_false;

1657: --}
1658: end if; /* p_txn_c = 'WRITE OFF' */
1659:
1660: /* Indicates a test failed and therefore the write-off is not reversible */
1661: x_count := fnd_api.g_false;
1662: return;
1663:
1664: exception
1665: when others then

Line 1667: x_count := fnd_api.g_false;

1663:
1664: exception
1665: when others then
1666: rollback;
1667: x_count := fnd_api.g_false;
1668: x_err_num := SQLCODE;
1669: x_err_code := NULL;
1670: x_err_msg := 'CST_Accrual_Rec_PVT.is_reversible() ' || SQLERRM;
1671: fnd_message.set_name('BOM','CST_UNEXPECTED');