DBA Data[Home] [Help]

APPS.IEX_WF_NEW_DEL_STATUS_PUB dependencies on IEX_DEBUG_PUB

Line 53: iex_debug_pub.logmessage('IEX- Start Invoking Creating New Delinquency Workflow');

49: BEGIN
50: -- Standard Start of API savepoint
51: SAVEPOINT invoke_new_del_status_wf;
52:
53: iex_debug_pub.logmessage('IEX- Start Invoking Creating New Delinquency Workflow');
54:
55: --PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
56: l_event_name := 'oracle.apps.iex.delstatus.create';
57: l_api_name := 'invoke_new_del_status_wf';

Line 60: iex_debug_pub.logmessage('IEX-1 Start Invoking and object_type'||p_object_type);

56: l_event_name := 'oracle.apps.iex.delstatus.create';
57: l_api_name := 'invoke_new_del_status_wf';
58: l_action_type := 'created';
59:
60: iex_debug_pub.logmessage('IEX-1 Start Invoking and object_type'||p_object_type);
61: iex_debug_pub.logmessage('l_api_version_number..'||l_api_version_number||'p_api_version..'||p_api_version);
62: -- Standard call to check for call compatibility.
63:
64: if p_object_type = 'Bankruptcy' then

Line 61: iex_debug_pub.logmessage('l_api_version_number..'||l_api_version_number||'p_api_version..'||p_api_version);

57: l_api_name := 'invoke_new_del_status_wf';
58: l_action_type := 'created';
59:
60: iex_debug_pub.logmessage('IEX-1 Start Invoking and object_type'||p_object_type);
61: iex_debug_pub.logmessage('l_api_version_number..'||l_api_version_number||'p_api_version..'||p_api_version);
62: -- Standard call to check for call compatibility.
63:
64: if p_object_type = 'Bankruptcy' then
65: IF NOT FND_API.Compatible_API_Call ( l_api_version_number2,

Line 83: iex_debug_pub.logmessage('IEX-2 Start Invoking Creating New Delinquency Workflow');

79: END IF;
80: end if;
81:
82:
83: iex_debug_pub.logmessage('IEX-2 Start Invoking Creating New Delinquency Workflow');
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF FND_API.to_Boolean( p_init_msg_list )
86: THEN
87: FND_MSG_PUB.initialize;

Line 95: iex_debug_pub.logmessage('IEX- Before getting item key information....');

91:
92: -- Initialize API return status to SUCCESS
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: iex_debug_pub.logmessage('IEX- Before getting item key information....');
96:
97: SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;
98:
99: itemkey := 'NEWST'||TO_CHAR(p_delinquency_id)||itemkey;

Line 101: iex_debug_pub.logmessage('IEX- Before getting manager information....');

97: SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;
98:
99: itemkey := 'NEWST'||TO_CHAR(p_delinquency_id)||itemkey;
100:
101: iex_debug_pub.logmessage('IEX- Before getting manager information....');
102:
103: begin
104: open c_get_manager(p_user_id);
105: Fetch c_get_manager Into l_manager_id, l_manager_name;

Line 117: iex_debug_pub.logmessage('IEX- Manager Name ....'||l_manager_name);

113: l_manager_id := null;
114: l_manager_name := null;
115: end;
116:
117: iex_debug_pub.logmessage('IEX- Manager Name ....'||l_manager_name);
118: iex_debug_pub.logmessage('IEX- Manager ID ....'||l_manager_id);
119: iex_debug_pub.logmessage('IEX- Object ID ....'||p_object_id);
120:
121: if p_object_type = 'CRepossession' then

Line 118: iex_debug_pub.logmessage('IEX- Manager ID ....'||l_manager_id);

114: l_manager_name := null;
115: end;
116:
117: iex_debug_pub.logmessage('IEX- Manager Name ....'||l_manager_name);
118: iex_debug_pub.logmessage('IEX- Manager ID ....'||l_manager_id);
119: iex_debug_pub.logmessage('IEX- Object ID ....'||p_object_id);
120:
121: if p_object_type = 'CRepossession' then
122: wf_event.AddParameterToList('CONTRACT_ID', p_delinquency_id,l_parameter_list);

Line 119: iex_debug_pub.logmessage('IEX- Object ID ....'||p_object_id);

115: end;
116:
117: iex_debug_pub.logmessage('IEX- Manager Name ....'||l_manager_name);
118: iex_debug_pub.logmessage('IEX- Manager ID ....'||l_manager_id);
119: iex_debug_pub.logmessage('IEX- Object ID ....'||p_object_id);
120:
121: if p_object_type = 'CRepossession' then
122: wf_event.AddParameterToList('CONTRACT_ID', p_delinquency_id,l_parameter_list);
123: l_object_type := 'Repossession';

Line 143: iex_debug_pub.logmessage('IEX- Starting Raising Workflow ....');

139: wf_event.AddParameterToList('TYPE_ID',p_object_id,l_parameter_list);
140: wf_event.AddParameterToList('SUB_DEL_TYPE',l_object_type,l_parameter_list);
141: wf_event.AddParameterToList('ACTION_TYPE',l_action_type,l_parameter_list);
142:
143: iex_debug_pub.logmessage('IEX- Starting Raising Workflow ....');
144:
145: wf_event.raise( p_event_name => l_event_name
146: ,p_event_key => itemkey
147: ,p_parameters => l_parameter_list);

Line 149: iex_debug_pub.logmessage('IEX- Ending Raising Workflow and before Commit ....');

145: wf_event.raise( p_event_name => l_event_name
146: ,p_event_key => itemkey
147: ,p_parameters => l_parameter_list);
148:
149: iex_debug_pub.logmessage('IEX- Ending Raising Workflow and before Commit ....');
150:
151: COMMIT ;
152: l_parameter_list.DELETE;
153: