DBA Data[Home] [Help]

APPS.IEX_WRITEOFFOBJ_PUB dependencies on FND_LOG

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

192: AddfailMsg(p_object => 'BEFORE CALLING WORKFLOW ', p_operation => 'CREATE');
193:
194: l_key := l_event_name ||'-'||p_request_id;
195:
196: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
197: iex_debug_pub.logmessage ('Event Key ' ||l_key ||'writeoff_type' ||p_writeoff_type||
198: 'object_id'||p_object_id|| 'request_id'||p_request_id);
199: END IF;
200:

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

208: OPEN c_get_cont_invoices(p_object_id,p_request_id);
209: FETCH c_get_cont_invoices INTO l_object_id, l_amount, l_currency_code;
210: CLOSE c_get_cont_invoices;
211:
212: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
213: iex_debug_pub.logmessage ('in contracts' ||'writeoff_type' ||p_writeoff_type||
214: 'object_id'||p_object_id|| 'request_id'||p_request_id);
215: end if;
216: end if;

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

229: IF l_notification_agent IS NULL THEN l_notification_agent := 'SYSADMIN';
230: END IF;
231:
232:
233: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
234: iex_debug_pub.logmessage ('l_case_number ' ||l_case_number || 'l_case_owner' || l_case_owner
235: ||'<-----L_AMOUNT----->' ||l_amount);
236: END IF;
237:

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

244: wf_event.AddParameterToList('OBJECT_ID', l_object_ID, l_parameter_list);
245: wf_event.AddParameterToList('WRITEOFF_TYPE', p_writeoff_type, l_parameter_list);
246: wf_event.AddParameterToList('CURRENCY_CODE', l_currency_code, l_parameter_list);
247:
248: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
249: iex_debug_pub.logmessage ('before launching workflow');
250: END IF;
251:
252: wf_event.raise(p_event_name => l_event_name

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

254: ,p_parameters => l_parameter_list);
255: COMMIT ;
256: l_parameter_list.DELETE;
257:
258: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
259: iex_debug_pub.logmessage ('Successfully launched writeoff workflow');
260: END IF;
261:
262: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

321: AddfailMsg(p_object => 'BEFORE CALLING WORKFLOW ', p_operation => 'CREATE');
322:
323: l_key := l_event_name ||'-'||p_request_id;
324:
325: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
326: iex_debug_pub.logmessage ('Event Key ' ||l_key);
327: END IF;
328:
329: OPEN c_get_case_owner(p_object_id);

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

329: OPEN c_get_case_owner(p_object_id);
330: FETCH c_get_case_owner INTO l_case_owner, l_contract_number;
331: CLOSE c_get_case_owner;
332:
333: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
334: iex_debug_pub.logmessage ('l_contract_number ' ||l_contract_number
335: || 'l_case_owner' || l_case_owner);
336: END IF;
337:

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

352: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
353: wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
354: wf_event.AddParameterToList('CONTRACT_NUMBER', l_contract_number, l_parameter_list);
355:
356: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
357: iex_debug_pub.logmessage ('before launching workflow');
358: END IF;
359:
360: wf_event.raise(p_event_name => l_event_name

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

363:
364: COMMIT ;
365: l_parameter_list.DELETE;
366:
367: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
368: iex_debug_pub.logmessage ('Successfully launched asset mgr workflow');
369: END IF;
370:
371: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

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

446: ,x_return_status =>l_return_status
447: ,x_msg_count =>l_msg_count
448: ,x_msg_data =>l_msg_data);
449:
450: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
451: iex_debug_pub.logmessage ('writeoff creation object ID '||
452: l_writeoff_object_id || 'status ' ||l_return_status);
453: END IF;
454:

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

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

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

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

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

491: END IF;
492: raise FND_API.G_EXC_ERROR;
493: ELSE
494: FND_MSG_PUB.initialize;
495: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
496: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number
497: ||'l_writeoff_rec.writeoff_id' || l_writeoff_obj_rec.writeoff_id);
498: end if;
499: END IF;

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

663: ,x_msg_data =>l_msg_data
664: ,p_adjv_rec =>l_adjv_rec
665: ,x_adjv_rec =>x_adjv_rec);
666:
667: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
668: iex_debug_pub.logmessage ('okl_trx_ar_adjsts status ' ||l_return_status);
669: iex_debug_pub.logmessage ('okl_trx_ar_adjsts adj_id ' || x_adjv_rec.id);
670: END IF;
671:

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

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

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

709: CLOSE c_get_code_comb;
710:
711: IF l_CODE_COMBINATION_ID IS NULL THEN
712: -- IF PG_DEBUG < 11 THEN
713: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
714: iex_debug_pub.logmessage ('Error in retreiving Code combination ');
715: END IF;
716:
717: select contract_number into l_contract_number

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

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

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

736:
737: l_ajlv_rec.CODE_COMBINATION_ID := l_CODE_COMBINATION_ID;
738: l_code_combination_id := null;
739:
740: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
741: iex_debug_pub.logmessage ('Code combination' ||l_ajlv_rec.CODE_COMBINATION_ID );
742: END IF;
743:
744: --set error message,so this will be prefixed before the

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

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

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

771: result := wf_engine.eng_completed ||':'||wf_no;
772: return;
773: ELSE
774: -- IF PG_DEBUG <11 THEN
775: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
776: iex_debug_pub.logmessage ('okl_txl_adjsts_lns status '
777: ||l_return_status || ' Id ' ||
778: x_ajlv_rec.id);
779: END IF;

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

791:
792: AddfailMsg( p_object => 'Adjustments ', p_operation => 'CREATE' );
793:
794: -- IF PG_DEBUG <11 THEN
795: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
796: iex_debug_pub.logmessage ('Before calling Okl Api' ||'transaction id ' || i.transaction_id);
797: END IF;
798:
799: -- Begin bug 8258156

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

797: END IF;
798:
799: -- Begin bug 8258156
800: -- mo_global.set_policy_context('S',7746);
801: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
802: iex_debug_pub.logmessage ('Before calling Okl Api Org ID = ' || i.org_id);
803: END IF;
804:
805: mo_global.set_policy_context('S',i.org_id);

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

816: ,x_msg_count => l_msg_count
817: ,x_msg_data => l_msg_data);
818:
819: -- IF PG_DEBUG <11 THEN
820: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
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

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

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

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

835: result := wf_engine.eng_completed ||':'||wf_no;
836: return;
837: ELSE
838: FND_MSG_PUB.initialize;
839: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
840: IEx_debug_pub.logmessage ('After caling OKL Adj API and adj_id ' || x_adj_id);
841: end if;
842: END IF;
843:

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

849: l_writeoff_obj_rec.RECEVIABLES_ADJUSTMENT_ID :=x_adj_id;
850: l_writeoff_obj_rec.writeoff_status :='A';
851: else
852: -- IF PG_DEBUG < 11 THEN
853: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
854: iex_debug_pub.logmessage('Adjust ment ID is null ');
855: END IF;
856:
857: AddfailMsg(p_object => 'Adjustments ',

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

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

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

891: return;
892: ELSE
893: FND_MSG_PUB.initialize;
894: -- IF PG_DEBUG <11 THEN
895: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
896: iex_debug_pub.logmessage('Finished updating iex_writeoffobjects');
897: END IF;
898:
899: END IF;

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

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

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

934: result := wf_engine.eng_completed ||':'||wf_no;
935: return;
936: ELSE
937: FND_MSG_PUB.initialize;
938: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
939: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number
940: ||'l_writeoff_rec.writeoff_id' || l_writeoff_obj_rec.writeoff_id||
941: 'in approve writeoff procedure');
942: END IF;

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

946: /** if writeoff type is CONTRACT then send asset mgr a
947: termination notification
948: */
949: If l_object_type ='CONTRACT' THEN
950: if (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
951: iex_debug_pub.logmessage('l_object_id ' || l_object_id|| 'l_request_id '|| l_request_id );
952: end if;
953: -- iex_test_pub.logmessage('l_object_id ' || l_object_id||
954: -- 'l_request_id '|| l_request_id );

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

960:
961: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
962: Get_Messages1 (l_msg_count,l_message);
963: -- IF PG_DEBUG < 11 THEN
964: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
965: iex_debug_pub.logmessage('Error after calling asset mgr WF' ||l_message);
966: END IF;
967:
968: wf_engine.SetItemAttrText(itemtype => itemtype,

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

983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN
985: --resultout := wf_engine.eng_completed ||':'||wf_no;
986: -- IF PG_DEBUG < 11 THEN
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',

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

998:
999: when others then
1000: --resultout := wf_engine.eng_completed ||':'||wf_no;
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',

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

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

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

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

Line 1188: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1184:
1185: BEGIN
1186:
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: