DBA Data[Home] [Help]

APPS.IEX_WRITEOFFOBJ_PUB dependencies on FND_LOG

Line 190: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

186: AddfailMsg(p_object => 'BEFORE CALLING WORKFLOW ', p_operation => 'CREATE');
187:
188: l_key := l_event_name ||'-'||p_request_id;
189:
190: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
191: iex_debug_pub.logmessage ('Event Key ' ||l_key ||'writeoff_type' ||p_writeoff_type||
192: 'object_id'||p_object_id|| 'request_id'||p_request_id);
193: END IF;
194:

Line 206: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

202: OPEN c_get_cont_invoices(p_object_id,p_request_id);
203: FETCH c_get_cont_invoices INTO l_object_id, l_amount, l_currency_code;
204: CLOSE c_get_cont_invoices;
205:
206: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
207: iex_debug_pub.logmessage ('in contracts' ||'writeoff_type' ||p_writeoff_type||
208: 'object_id'||p_object_id|| 'request_id'||p_request_id);
209: end if;
210: end if;

Line 219: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

215:
216: IF l_notification_agent IS NULL THEN l_notification_agent := 'SYSADMIN';
217: END IF;
218:
219: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
220: iex_debug_pub.logmessage ('l_case_number ' ||l_case_number || 'l_case_owner' || l_case_owner
221: ||'<-----L_AMOUNT----->' ||l_amount);
222: END IF;
223:

Line 234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

230: wf_event.AddParameterToList('OBJECT_ID', l_object_ID, l_parameter_list);
231: wf_event.AddParameterToList('WRITEOFF_TYPE', p_writeoff_type, l_parameter_list);
232: wf_event.AddParameterToList('CURRENCY_CODE', l_currency_code, l_parameter_list);
233:
234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
235: iex_debug_pub.logmessage ('before launching workflow');
236: END IF;
237:
238: wf_event.raise(p_event_name => l_event_name

Line 244: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

240: ,p_parameters => l_parameter_list);
241: COMMIT ;
242: l_parameter_list.DELETE;
243:
244: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
245: iex_debug_pub.logmessage ('Successfully launched writeoff workflow');
246: END IF;
247:
248: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 310: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

306: AddfailMsg(p_object => 'BEFORE CALLING WORKFLOW ', p_operation => 'CREATE');
307:
308: l_key := l_event_name ||'-'||p_request_id;
309:
310: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
311: iex_debug_pub.logmessage ('Event Key ' ||l_key);
312: END IF;
313:
314: OPEN c_get_case_owner(p_object_id);

Line 318: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

314: OPEN c_get_case_owner(p_object_id);
315: FETCH c_get_case_owner INTO l_case_owner, l_contract_number;
316: CLOSE c_get_case_owner;
317:
318: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
319: iex_debug_pub.logmessage ('l_contract_number ' ||l_contract_number
320: || 'l_case_owner' || l_case_owner);
321: END IF;
322:

Line 335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

331: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
332: wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
333: wf_event.AddParameterToList('CONTRACT_NUMBER', l_contract_number, l_parameter_list);
334:
335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
336: iex_debug_pub.logmessage ('before launching workflow');
337: END IF;
338:
339: wf_event.raise(p_event_name => l_event_name

Line 346: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

342:
343: COMMIT ;
344: l_parameter_list.DELETE;
345:
346: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
347: iex_debug_pub.logmessage ('Successfully launched asset mgr workflow');
348: END IF;
349:
350: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 429: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

425: ,x_return_status =>l_return_status
426: ,x_msg_count =>l_msg_count
427: ,x_msg_data =>l_msg_data);
428:
429: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
430: iex_debug_pub.logmessage ('writeoff creation object ID '||
431: l_writeoff_object_id || 'status ' ||l_return_status);
432: END IF;
433:

Line 436: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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;
440:

Line 468: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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;
472: ELSE

Line 474: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

470: END IF;
471: raise FND_API.G_EXC_ERROR;
472: ELSE
473: FND_MSG_PUB.initialize;
474: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
475: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number
476: ||'l_writeoff_rec.writeoff_id' || l_writeoff_obj_rec.writeoff_id);
477: end if;
478: END IF;

Line 647: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

643: ,x_msg_data =>l_msg_data
644: ,p_adjv_rec =>l_adjv_rec
645: ,x_adjv_rec =>x_adjv_rec);
646:
647: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
648: iex_debug_pub.logmessage ('okl_trx_ar_adjsts status ' ||l_return_status);
649: iex_debug_pub.logmessage ('okl_trx_ar_adjsts adj_id ' || x_adjv_rec.id);
650: END IF;
651:

Line 655: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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;
658: wf_engine.SetItemAttrText(itemtype => itemtype,
659: itemkey => itemkey,

Line 693: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

689: CLOSE c_get_code_comb;
690:
691: IF l_CODE_COMBINATION_ID IS NULL THEN
692: -- IF PG_DEBUG < 11 THEN
693: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
694: iex_debug_pub.logmessage ('Error in retreiving Code combination ');
695: END IF;
696:
697: select contract_number into l_contract_number

Line 705: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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,
709: itemkey => itemkey,

Line 720: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

716:
717: l_ajlv_rec.CODE_COMBINATION_ID := l_CODE_COMBINATION_ID;
718: l_code_combination_id := null;
719:
720: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
721: iex_debug_pub.logmessage ('Code combination' ||l_ajlv_rec.CODE_COMBINATION_ID );
722: END IF;
723:
724: --set error message,so this will be prefixed before the

Line 743: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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;
746: wf_engine.SetItemAttrText(itemtype => itemtype,
747: itemkey => itemkey,

Line 755: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

751: result := wf_engine.eng_completed ||':'||wf_no;
752: return;
753: ELSE
754: -- IF PG_DEBUG <11 THEN
755: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
756: iex_debug_pub.logmessage ('okl_txl_adjsts_lns status '
757: ||l_return_status || ' Id ' ||
758: x_ajlv_rec.id);
759: END IF;

Line 775: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

771:
772: AddfailMsg( p_object => 'Adjustments ', p_operation => 'CREATE' );
773:
774: -- IF PG_DEBUG <11 THEN
775: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
776: iex_debug_pub.logmessage ('Before calling Okl Api' ||'transaction id ' || i.transaction_id);
777: END IF;
778:
779: -- Begin bug 8258156

Line 781: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

777: END IF;
778:
779: -- Begin bug 8258156
780: -- mo_global.set_policy_context('S',7746);
781: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
782: iex_debug_pub.logmessage ('Before calling Okl Api Org ID = ' || i.org_id);
783: END IF;
784:
785: mo_global.set_policy_context('S',i.org_id);

Line 800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

796: ,x_msg_count => l_msg_count
797: ,x_msg_data => l_msg_data);
798:
799: -- IF PG_DEBUG <11 THEN
800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
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

Line 807: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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;
810: wf_engine.SetItemAttrText(itemtype => itemtype,
811: itemkey => itemkey,

Line 819: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

815: result := wf_engine.eng_completed ||':'||wf_no;
816: return;
817: ELSE
818: FND_MSG_PUB.initialize;
819: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
820: IEx_debug_pub.logmessage ('After caling OKL Adj API and adj_id ' || x_adj_id);
821: end if;
822: END IF;
823:

Line 833: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

829: l_writeoff_obj_rec.RECEVIABLES_ADJUSTMENT_ID :=x_adj_id;
830: l_writeoff_obj_rec.writeoff_status :='A';
831: else
832: -- IF PG_DEBUG < 11 THEN
833: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
834: iex_debug_pub.logmessage('Adjust ment ID is null ');
835: END IF;
836:
837: AddfailMsg(p_object => 'Adjustments ',

Line 862: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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;
865: wf_engine.SetItemAttrText(itemtype => itemtype,
866: itemkey => itemkey,

Line 875: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

871: return;
872: ELSE
873: FND_MSG_PUB.initialize;
874: -- IF PG_DEBUG <11 THEN
875: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
876: iex_debug_pub.logmessage('Finished updating iex_writeoffobjects');
877: END IF;
878:
879: END IF;

Line 906: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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;
909: wf_engine.SetItemAttrText(itemtype => itemtype,
910: itemkey => itemkey,

Line 918: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

914: result := wf_engine.eng_completed ||':'||wf_no;
915: return;
916: ELSE
917: FND_MSG_PUB.initialize;
918: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
919: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number
920: ||'l_writeoff_rec.writeoff_id' || l_writeoff_obj_rec.writeoff_id||
921: 'in approve writeoff procedure');
922: END IF;

Line 930: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

926: /** if writeoff type is CONTRACT then send asset mgr a
927: termination notification
928: */
929: If l_object_type ='CONTRACT' THEN
930: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
931: iex_debug_pub.logmessage('l_object_id ' || l_object_id|| 'l_request_id '|| l_request_id );
932: end if;
933: -- iex_test_pub.logmessage('l_object_id ' || l_object_id||
934: -- 'l_request_id '|| l_request_id );

Line 944: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

940:
941: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
942: Get_Messages1 (l_msg_count,l_message);
943: -- IF PG_DEBUG < 11 THEN
944: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
945: iex_debug_pub.logmessage('Error after calling asset mgr WF' ||l_message);
946: END IF;
947:
948: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 967: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965: --resultout := wf_engine.eng_completed ||':'||wf_no;
966: -- IF PG_DEBUG < 11 THEN
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',

Line 982: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

978:
979: when others then
980: --resultout := wf_engine.eng_completed ||':'||wf_no;
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',

Line 1085: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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;
1088: wf_engine.SetItemAttrText(itemtype => itemtype,
1089: itemkey => itemkey,

Line 1124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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;
1127:
1128: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1168: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1164:
1165: BEGIN
1166:
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: