DBA Data[Home] [Help]

APPS.IEX_WRITEOFFOBJ_PUB dependencies on IEX_WRITEOFFOBJ_PUB

Line 1: PACKAGE BODY IEX_WRITEOFFOBJ_PUB as

1: PACKAGE BODY IEX_WRITEOFFOBJ_PUB as
2: /* $Header: iexpwrob.pls 120.10.12010000.3 2009/08/14 12:39:08 ehuh ship $ */
3: -- Start of Comments
4: -- Package name :IEX_WRITEOFFOBJ_PUB
5: -- Purpose : 1) Procedure to populate OKL_TRX_ADJST_B and OKL_TXL_ADJSTS_LNS_B

Line 4: -- Package name :IEX_WRITEOFFOBJ_PUB

1: PACKAGE BODY IEX_WRITEOFFOBJ_PUB as
2: /* $Header: iexpwrob.pls 120.10.12010000.3 2009/08/14 12:39:08 ehuh ship $ */
3: -- Start of Comments
4: -- Package name :IEX_WRITEOFFOBJ_PUB
5: -- Purpose : 1) Procedure to populate OKL_TRX_ADJST_B and OKL_TXL_ADJSTS_LNS_B
6: -- : 2) Procedure to call OKL_WRAPPER OKL_CREATE_ADJ_PVT
7: -- : to create an adjustment
8: -- : 3) Procedure to check approval before creating a writeoff.

Line 269: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_writeoff_wf');

265: ROLLBACK TO invoke_writeoff_wf;
266: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
267: x_msg_count := l_msg_count ;
268: x_msg_data := l_msg_data ;
269: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_writeoff_wf');
270: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
271: ,p_data => x_msg_data);
272: End invoke_writeoff_wf;
273:

Line 378: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_asset_mgr_wf');

374: ROLLBACK TO invoke_asset_mgr_wf;
375: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
376: x_msg_count := l_msg_count ;
377: x_msg_data := l_msg_data ;
378: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_asset_mgr_wf');
379: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count
380: ,p_data => x_msg_data);
381: End invoke_asset_mgr_wf;
382:

Line 456: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

452: l_writeoff_object_id || 'status ' ||l_return_status);
453: END IF;
454:
455: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
456: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
457: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
458: iex_debug_pub.logmessage('Error' ||l_message);
459: END IF;
460: raise FND_API.G_EXC_ERROR;

Line 488: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

484: ,xo_object_version_number =>l_object_version_number
485: );
486:
487: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
488: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
490: iex_debug_pub.logmessage('Error' ||l_message);
491: END IF;
492: raise FND_API.G_EXC_ERROR;

Line 536: RETURN IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type

532:
533: /** Intialize record defintion to avoid direct server side access of variables
534: */
535: FUNCTION INIT_WRITEOFFOBJ_REC
536: RETURN IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type
537: IS
538: l_return_rec IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type ;
539: BEGIN
540: RETURN l_return_rec;

Line 538: l_return_rec IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type ;

534: */
535: FUNCTION INIT_WRITEOFFOBJ_REC
536: RETURN IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type
537: IS
538: l_return_rec IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type ;
539: BEGIN
540: RETURN l_return_rec;
541: END INIT_WRITEOFFOBJ_REC;
542:

Line 673: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

669: iex_debug_pub.logmessage ('okl_trx_ar_adjsts adj_id ' || x_adjv_rec.id);
670: END IF;
671:
672: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
673: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
674: -- IF PG_DEBUG <11 THEN
675: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
676: iex_debug_pub.logmessage('Error' ||l_message);
677: END IF;

Line 724: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

720:
721: fnd_message.set_name('IEX', 'IEX_WRITEOFFOBJ_CODE_COMB');
722: fnd_message.set_token('CONTRACT_NUMBER', l_contract_number);
723: fnd_msg_pub.add;
724: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
725: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
726: iex_debug_pub.logmessage('Error' ||l_message);
727: END IF;
728: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 761: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

757: ,x_ajlv_rec =>x_ajlv_rec);
758:
759:
760: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
761: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
762: -- IF PG_DEBUG <11 THEN
763: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
764: iex_debug_pub.logmessage('Error' ||l_message);
765: END IF;

Line 825: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

821: iex_debug_pub.logmessage ('After calling Okl Api and status'||l_return_status);
822: END IF;
823:
824: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
825: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
826: -- IF PG_DEBUG <11 THEN
827: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
828: iex_debug_pub.logmessage('Error' ||l_message);
829: END IF;

Line 880: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

876: ,x_msg_count =>l_msg_count
877: ,x_msg_data =>l_msg_data);
878:
879: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
880: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
881: -- IF PG_DEBUG <11 THEN
882: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
883: iex_debug_pub.logmessage('Error' ||l_message);
884: END IF;

Line 924: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

920: ,x_msg_data => l_msg_data
921: ,xo_object_version_number =>l_object_version_number);
922:
923: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
924: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
925: -- IF PG_DEBUG <11 THEN
926: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
927: iex_debug_pub.logmessage('Error' ||l_message);
928: END IF;

Line 991: wf_core.context('IEX_WRITEOFFOBJ_PUB',

987: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
988: iex_debug_pub.logmessage('Error ' ||l_message);
989: END IF;
990:
991: wf_core.context('IEX_WRITEOFFOBJ_PUB',
992: 'approve_writeoffs',
993: itemtype,
994: itemkey,
995: to_char(actid),

Line 1005: wf_core.context('IEX_WRITEOFFOBJ_PUB',

1001: -- IF PG_DEBUG < 11 THEN
1002: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1003: iex_debug_pub.logmessage('Error WHEN OTHERE' ||sqlerrm);
1004: END IF;
1005: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1006: 'approve_writeoffs',
1007: itemtype,
1008: itemkey,
1009: to_char(actid),

Line 1103: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

1099: ,x_msg_count =>l_msg_count
1100: ,x_msg_data =>l_msg_data);
1101:
1102: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1103: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
1104: -- IF PG_DEBUG <11 THEN
1105: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1106: iex_debug_pub.logmessage('Error' ||l_message);
1107: END IF;

Line 1142: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

1138: ,x_msg_data => l_msg_data
1139: ,xo_object_version_number => l_object_version_number);
1140:
1141: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1142: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
1143: -- IF PG_DEBUG <11 THEN
1144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1145: iex_debug_pub.logmessage('Error' ||l_message||itemkey||itemtype);
1146: END IF;

Line 1165: wf_core.context('IEX_WRITEOFFOBJ_PUB',

1161:
1162: EXCEPTION
1163: WHEN FND_API.G_EXC_ERROR THEN
1164: --resultout := wf_engine.eng_completed ||':'||wf_no;
1165: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1166: 'reject_writeoffs',
1167: itemtype,
1168: itemkey,
1169: to_char(actid),

Line 1175: wf_core.context('IEX_WRITEOFFOBJ_PUB',

1171: raise;
1172:
1173: when others then
1174: --resultout := wf_engine.eng_completed ||':'||wf_no;
1175: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1176: 'reject_writeoffs',
1177: itemtype,
1178: itemkey,
1179: to_char(actid),

Line 1191: END IEX_WRITEOFFOBJ_PUB;

1187: G_FILE_NAME := 'iexpwrob.pls';
1188: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1189: wf_yes := 'Y';
1190: wf_no :='N';
1191: END IEX_WRITEOFFOBJ_PUB;
1192:
1193:
1194: