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.2 2009/02/18 14:52:59 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.2 2009/02/18 14:52:59 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 255: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_writeoff_wf');

251: ROLLBACK TO invoke_writeoff_wf;
252: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
253: x_msg_count := l_msg_count ;
254: x_msg_data := l_msg_data ;
255: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_writeoff_wf');
256: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
257: ,p_data => x_msg_data);
258: End invoke_writeoff_wf;
259:

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

353: ROLLBACK TO invoke_asset_mgr_wf;
354: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
355: x_msg_count := l_msg_count ;
356: x_msg_data := l_msg_data ;
357: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_WRITEOFFOBJ_PUB','invoke_asset_mgr_wf');
358: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count
359: ,p_data => x_msg_data);
360: End invoke_asset_mgr_wf;
361:

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

431: l_writeoff_object_id || 'status ' ||l_return_status);
432: END IF;
433:
434: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
435: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
436: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
437: iex_debug_pub.logmessage('Error' ||l_message);
438: END IF;
439: raise FND_API.G_EXC_ERROR;

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

463: ,xo_object_version_number =>l_object_version_number
464: );
465:
466: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
467: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
468: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
469: iex_debug_pub.logmessage('Error' ||l_message);
470: END IF;
471: raise FND_API.G_EXC_ERROR;

Line 515: RETURN IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type

511:
512: /** Intialize record defintion to avoid direct server side access of variables
513: */
514: FUNCTION INIT_WRITEOFFOBJ_REC
515: RETURN IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type
516: IS
517: l_return_rec IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type ;
518: BEGIN
519: RETURN l_return_rec;

Line 517: l_return_rec IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type ;

513: */
514: FUNCTION INIT_WRITEOFFOBJ_REC
515: RETURN IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type
516: IS
517: l_return_rec IEX_WRITEOFFOBJ_PUB.writeoff_obj_rec_type ;
518: BEGIN
519: RETURN l_return_rec;
520: END INIT_WRITEOFFOBJ_REC;
521:

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

649: iex_debug_pub.logmessage ('okl_trx_ar_adjsts adj_id ' || x_adjv_rec.id);
650: END IF;
651:
652: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
653: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
654: -- IF PG_DEBUG <11 THEN
655: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
656: iex_debug_pub.logmessage('Error' ||l_message);
657: END IF;

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

700:
701: fnd_message.set_name('IEX', 'IEX_WRITEOFFOBJ_CODE_COMB');
702: fnd_message.set_token('CONTRACT_NUMBER', l_contract_number);
703: fnd_msg_pub.add;
704: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
705: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
706: iex_debug_pub.logmessage('Error' ||l_message);
707: END IF;
708: wf_engine.SetItemAttrText(itemtype => itemtype,

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

737: ,x_ajlv_rec =>x_ajlv_rec);
738:
739:
740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
741: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
742: -- IF PG_DEBUG <11 THEN
743: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
744: iex_debug_pub.logmessage('Error' ||l_message);
745: END IF;

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

801: iex_debug_pub.logmessage ('After calling Okl Api and status'||l_return_status);
802: END IF;
803:
804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
805: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
806: -- IF PG_DEBUG <11 THEN
807: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
808: iex_debug_pub.logmessage('Error' ||l_message);
809: END IF;

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

856: ,x_msg_count =>l_msg_count
857: ,x_msg_data =>l_msg_data);
858:
859: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
860: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
861: -- IF PG_DEBUG <11 THEN
862: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
863: iex_debug_pub.logmessage('Error' ||l_message);
864: END IF;

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

900: ,x_msg_data => l_msg_data
901: ,xo_object_version_number =>l_object_version_number);
902:
903: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
904: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
905: -- IF PG_DEBUG <11 THEN
906: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
907: iex_debug_pub.logmessage('Error' ||l_message);
908: END IF;

Line 971: wf_core.context('IEX_WRITEOFFOBJ_PUB',

967: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
968: iex_debug_pub.logmessage('Error ' ||l_message);
969: END IF;
970:
971: wf_core.context('IEX_WRITEOFFOBJ_PUB',
972: 'approve_writeoffs',
973: itemtype,
974: itemkey,
975: to_char(actid),

Line 985: wf_core.context('IEX_WRITEOFFOBJ_PUB',

981: -- IF PG_DEBUG < 11 THEN
982: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
983: iex_debug_pub.logmessage('Error WHEN OTHERE' ||sqlerrm);
984: END IF;
985: wf_core.context('IEX_WRITEOFFOBJ_PUB',
986: 'approve_writeoffs',
987: itemtype,
988: itemkey,
989: to_char(actid),

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

1079: ,x_msg_count =>l_msg_count
1080: ,x_msg_data =>l_msg_data);
1081:
1082: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1083: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
1084: -- IF PG_DEBUG <11 THEN
1085: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1086: iex_debug_pub.logmessage('Error' ||l_message);
1087: END IF;

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

1118: ,x_msg_data => l_msg_data
1119: ,xo_object_version_number => l_object_version_number);
1120:
1121: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1122: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);
1123: -- IF PG_DEBUG <11 THEN
1124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1125: iex_debug_pub.logmessage('Error' ||l_message||itemkey||itemtype);
1126: END IF;

Line 1145: wf_core.context('IEX_WRITEOFFOBJ_PUB',

1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: --resultout := wf_engine.eng_completed ||':'||wf_no;
1145: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1146: 'reject_writeoffs',
1147: itemtype,
1148: itemkey,
1149: to_char(actid),

Line 1155: wf_core.context('IEX_WRITEOFFOBJ_PUB',

1151: raise;
1152:
1153: when others then
1154: --resultout := wf_engine.eng_completed ||':'||wf_no;
1155: wf_core.context('IEX_WRITEOFFOBJ_PUB',
1156: 'reject_writeoffs',
1157: itemtype,
1158: itemkey,
1159: to_char(actid),

Line 1171: END IEX_WRITEOFFOBJ_PUB;

1167: G_FILE_NAME := 'iexpwrob.pls';
1168: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1169: wf_yes := 'Y';
1170: wf_no :='N';
1171: END IEX_WRITEOFFOBJ_PUB;
1172:
1173:
1174: