DBA Data[Home] [Help]

APPS.IEX_WRITEOFFOBJ_PUB dependencies on IEX_DEBUG_PUB

Line 52: iex_debug_pub.logmessage ( 'in get message routine');

48: and lng.LANGUAGE_CODE = msg.language_code
49: and lng.language_id = x_lang_id;
50:
51: BEGIN
52: iex_debug_pub.logmessage ( 'in get message routine');
53: FOR l_count in 1..p_message_count LOOP
54:
55: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
56: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);

Line 84: iex_debug_pub.logmessage ( 'l_msg_lis'||l_msg_list);

80: l_msg_list := l_msg_list || l_temp_msg || fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
81: END IF;
82:
83: l_msg_list := l_msg_list || '';
84: iex_debug_pub.logmessage ( 'l_msg_lis'||l_msg_list);
85: END LOOP;
86:
87: x_message := l_msg_list;
88: iex_debug_pub.logmessage ( ' x_message ' ||x_message);

Line 88: iex_debug_pub.logmessage ( ' x_message ' ||x_message);

84: iex_debug_pub.logmessage ( 'l_msg_lis'||l_msg_list);
85: END LOOP;
86:
87: x_message := l_msg_list;
88: iex_debug_pub.logmessage ( ' x_message ' ||x_message);
89: EXCEPTION
90: WHEN OTHERS THEN
91: x_message:=l_msg_list;
92: END Get_Messages;

Line 108: iex_debug_pub.logmessage ( 'in get message routine');

104: l_msg_data VARCHAR2(32627);
105: l_new_line VARCHAR2(10) := FND_GLOBAL.NEWLINE;
106:
107: BEGIN
108: iex_debug_pub.logmessage ( 'in get message routine');
109: FOR i IN 1..p_message_count
110: LOOP
111: fnd_msg_pub.get(p_data => l_msg_data,
112: p_msg_index_out => l_msg_count,

Line 122: iex_debug_pub.logmessage ( ' x_message ' ||x_message);

118: l_msg_list := l_msg_list || l_new_line || l_msg_data;
119: END IF;
120: END LOOP;
121: x_message:=l_msg_list;
122: iex_debug_pub.logmessage ( ' x_message ' ||x_message);
123: EXCEPTION
124: WHEN OTHERS THEN
125: x_message:=l_msg_list;
126: END Get_Messages1;

Line 191: iex_debug_pub.logmessage ('Event Key ' ||l_key ||'writeoff_type' ||p_writeoff_type||

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:
195: l_amount :=0;

Line 207: iex_debug_pub.logmessage ('in contracts' ||'writeoff_type' ||p_writeoff_type||

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

Line 220: iex_debug_pub.logmessage ('l_case_number ' ||l_case_number || 'l_case_owner' || l_case_owner

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:
224: wf_event.AddParameterToList('AMOUNT', to_char(l_amount), l_parameter_list);

Line 235: iex_debug_pub.logmessage ('before launching workflow');

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
239: ,p_event_key => l_key

Line 245: iex_debug_pub.logmessage ('Successfully launched writeoff workflow');

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);
249: EXCEPTION

Line 311: iex_debug_pub.logmessage ('Event Key ' ||l_key);

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);
315: FETCH c_get_case_owner INTO l_case_owner, l_contract_number;

Line 319: iex_debug_pub.logmessage ('l_contract_number ' ||l_contract_number

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:
323: OPEN c_get_agent ;

Line 336: iex_debug_pub.logmessage ('before launching workflow');

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
340: ,p_event_key => l_key

Line 347: iex_debug_pub.logmessage ('Successfully launched asset mgr workflow');

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);
351: EXCEPTION

Line 430: iex_debug_pub.logmessage ('writeoff creation object ID '||

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:
434: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 437: iex_debug_pub.logmessage('Error' ||l_message);

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:
441: ELSE

Line 469: iex_debug_pub.logmessage('Error' ||l_message);

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
473: FND_MSG_PUB.initialize;

Line 475: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number

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

Line 648: iex_debug_pub.logmessage ('okl_trx_ar_adjsts status ' ||l_return_status);

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:
652: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 649: iex_debug_pub.logmessage ('okl_trx_ar_adjsts adj_id ' || x_adjv_rec.id);

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:
652: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
653: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

Line 656: iex_debug_pub.logmessage('Error' ||l_message);

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,
660: aname => 'ERROR_MESSAGE',

Line 694: iex_debug_pub.logmessage ('Error in retreiving Code combination ');

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
698: from okc_k_headers_b

Line 706: iex_debug_pub.logmessage('Error' ||l_message);

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,
710: aname => 'ERROR_MESSAGE',

Line 721: iex_debug_pub.logmessage ('Code combination' ||l_ajlv_rec.CODE_COMBINATION_ID );

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
725: --actual message, so it makes more sense than displaying an

Line 744: iex_debug_pub.logmessage('Error' ||l_message);

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,
748: aname => 'ERROR_MESSAGE',

Line 756: iex_debug_pub.logmessage ('okl_txl_adjsts_lns status '

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;
760: FND_MSG_PUB.initialize;

Line 776: iex_debug_pub.logmessage ('Before calling Okl Api' ||'transaction id ' || i.transaction_id);

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
780: -- mo_global.set_policy_context('S',7746);

Line 782: iex_debug_pub.logmessage ('Before calling Okl Api Org ID = ' || i.org_id);

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);
786: -- End bug 8258156

Line 801: iex_debug_pub.logmessage ('After calling Okl Api and status'||l_return_status);

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
805: IEX_WRITEOFFOBJ_PUB.Get_Messages1 (l_msg_count,l_message);

Line 808: iex_debug_pub.logmessage('Error' ||l_message);

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,
812: aname => 'ERROR_MESSAGE',

Line 820: IEx_debug_pub.logmessage ('After caling OKL Adj API and adj_id ' || x_adj_id);

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:
824: --else adjustment created and update iex_writeoff_objects

Line 834: iex_debug_pub.logmessage('Adjust ment ID is null ');

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 ',
838: p_operation => 'CREATE' );

Line 863: iex_debug_pub.logmessage('Error' ||l_message);

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,
867: aname => 'ERROR_MESSAGE',

Line 876: iex_debug_pub.logmessage('Finished updating iex_writeoffobjects');

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

Line 907: iex_debug_pub.logmessage('Error' ||l_message);

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,
911: aname => 'ERROR_MESSAGE',

Line 919: iex_debug_pub.logmessage ('obj of iex_writeoff' ||l_object_version_number

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

Line 931: iex_debug_pub.logmessage('l_object_id ' || l_object_id|| 'l_request_id '|| l_request_id );

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 );
935: invoke_asset_mgr_wf(p_object_id => l_object_id

Line 945: iex_debug_pub.logmessage('Error after calling asset mgr WF' ||l_message);

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

Line 968: iex_debug_pub.logmessage('Error ' ||l_message);

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',
972: 'approve_writeoffs',

Line 983: iex_debug_pub.logmessage('Error WHEN OTHERE' ||sqlerrm);

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',
987: itemtype,

Line 1046: iex_debug_pub.logmessage ( 'JSANJU---inside reject writeoff');

1042: if funcmode <> 'RUN' then
1043: result := wf_engine.eng_null;
1044: return;
1045: end if;
1046: iex_debug_pub.logmessage ( 'JSANJU---inside reject writeoff');
1047: l_WRITEOFF_ID:= wf_engine.GetItemAttrText(itemtype => itemtype,
1048: itemkey => itemkey,
1049: aname => 'WRITEOFF_ID');
1050:

Line 1086: iex_debug_pub.logmessage('Error' ||l_message);

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,
1090: aname => 'ERROR_MESSAGE',

Line 1125: iex_debug_pub.logmessage('Error' ||l_message||itemkey||itemtype);

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