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 1564: -- FND_API.G_TRUE => Reversible

1560: -- : p_ou_id IN NUMBER Required
1561: -- Operating Unit Identifier
1562: -- OUT : x_count OUT NOCOPY NUBMER Required
1563: -- Reversible Indicator
1564: -- FND_API.G_TRUE => Reversible
1565: -- FND_API.G_FALSE => Not Reversible
1566: -- : x_err_num OUT NOCOPY NUMBER Required
1567: -- Standard Error Parameter
1568: -- : x_err_code OUT NOCOPY VARCHAR2 Required

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

1561: -- Operating Unit Identifier
1562: -- OUT : x_count OUT NOCOPY NUBMER Required
1563: -- Reversible Indicator
1564: -- FND_API.G_TRUE => Reversible
1565: -- FND_API.G_FALSE => Not Reversible
1566: -- : x_err_num OUT NOCOPY NUMBER Required
1567: -- Standard Error Parameter
1568: -- : x_err_code OUT NOCOPY VARCHAR2 Required
1569: -- Standard Error Parameter

Line 1659: x_count := fnd_api.g_true;

1655: if(l_enabled = 0) then
1656: --{
1657: l_stmt_num := 30;
1658: /* If all the tests pass, write-off is reversible */
1659: x_count := fnd_api.g_true;
1660: return;
1661: --}
1662: end if; /* l_enabled = 0 */
1663: --}

Line 1671: x_count := fnd_api.g_false;

1667: --}
1668: end if; /* p_txn_c = 'WRITE OFF' */
1669:
1670: /* Indicates a test failed and therefore the write-off is not reversible */
1671: x_count := fnd_api.g_false;
1672: return;
1673:
1674: exception
1675: when others then

Line 1677: x_count := fnd_api.g_false;

1673:
1674: exception
1675: when others then
1676: rollback;
1677: x_count := fnd_api.g_false;
1678: x_err_num := SQLCODE;
1679: x_err_code := NULL;
1680: x_err_msg := 'CST_Accrual_Rec_PVT.is_reversible() ' || SQLERRM;
1681: fnd_message.set_name('BOM','CST_UNEXPECTED');