eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOMPCMBM dependencies on FND_FILE

Line 62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Checking event(commonBill)='||p_event_name||', event_key='||p_event_key||', erecord_id='||l_erecord_id||', msg_cnt='||l_msg_count);

58: , p_event_name => p_event_name
59: , p_event_key => p_event_key
60: , x_erecord_id => l_erecord_id);
61:
62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Checking event(commonBill)='||p_event_name||', event_key='||p_event_key||', erecord_id='||l_erecord_id||', msg_cnt='||l_msg_count);
63:
64: IF (NVL( l_erecord_id, -1) >0)
65: THEN
66: IF (p_event_status = 'SUCCESS')

Line 77: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acknowledging eRecord_id='||l_erecord_id||' with status='||l_trans_status);

73: -- Get message that will be send to SEND_ACKN :
74: FND_MESSAGE.SET_NAME('ENG', 'BOM_ERES_ACKN_BILL');
75: l_ackn_by := FND_MESSAGE.GET;
76:
77: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acknowledging eRecord_id='||l_erecord_id||' with status='||l_trans_status);
78: QA_EDR_STANDARD.SEND_ACKN
79: ( p_api_version => 1.0
80: , p_init_msg_list => FND_API.G_TRUE
81: , x_return_status => l_return_status

Line 92: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);

88: , p_ackn_by => l_ackn_by
89: , p_ackn_note => p_event_name||', '||p_event_key
90: , p_autonomous_commit => FND_API.G_TRUE);
91:
92: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
93:
94: IF (l_return_status <> FND_API.G_TRUE)
95: THEN
96: RAISE SEND_ACKN_ERROR;

Line 99: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');

95: THEN
96: RAISE SEND_ACKN_ERROR;
97: END IF;
98:
99: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
100: ELSE
101: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Acknowledgement.');
102: END IF;
103:

Line 101: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Acknowledgement.');

97: END IF;
98:
99: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
100: ELSE
101: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Acknowledgement.');
102: END IF;
103:
104: EXCEPTION
105: WHEN SEND_ACKN_ERROR THEN

Line 111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);

107: p_msg_index => 1,
108: p_data => l_msg_data,
109: p_encoded => FND_API.G_FALSE,
110: p_msg_index_out => l_dummy_cnt);
111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);
112:
113: WHEN OTHERS THEN
114: l_msg_data := 'ACKN Others Error='||SQLERRM;
115: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

Line 115: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);
112:
113: WHEN OTHERS THEN
114: l_msg_data := 'ACKN Others Error='||SQLERRM;
115: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
116:
117:
118: END Event_Acknowledgement;
119: -- ERES change ends

Line 146: FND_FILE.PUT_LINE( FND_FILE.LOG, '* Update_BSB_Request_Id_Column procedure Start *') ;

142: ) IS
143: P_COMMONBOM_IS_RUNNING CONSTANT NUMBER := -666;
144:
145: BEGIN
146: FND_FILE.PUT_LINE( FND_FILE.LOG, '************* Update_BSB_Request_Id_Column procedure Start *************') ;
147: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Sequence number: ' || to_char(p_sequence_num));
148: FND_FILE.PUT_LINE( FND_FILE.LOG, 'organization_id: ' || to_char(p_organization_id));
149: FND_FILE.PUT_LINE( FND_FILE.LOG, 'assembly_item_id: ' || to_char(p_assembly_item_id));
150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'alternate_bom_designator: ' || p_alternate);

Line 147: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Sequence number: ' || to_char(p_sequence_num));

143: P_COMMONBOM_IS_RUNNING CONSTANT NUMBER := -666;
144:
145: BEGIN
146: FND_FILE.PUT_LINE( FND_FILE.LOG, '************* Update_BSB_Request_Id_Column procedure Start *************') ;
147: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Sequence number: ' || to_char(p_sequence_num));
148: FND_FILE.PUT_LINE( FND_FILE.LOG, 'organization_id: ' || to_char(p_organization_id));
149: FND_FILE.PUT_LINE( FND_FILE.LOG, 'assembly_item_id: ' || to_char(p_assembly_item_id));
150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'alternate_bom_designator: ' || p_alternate);
151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'request_id: ' || to_char(p_request_id));

Line 148: FND_FILE.PUT_LINE( FND_FILE.LOG, 'organization_id: ' || to_char(p_organization_id));

144:
145: BEGIN
146: FND_FILE.PUT_LINE( FND_FILE.LOG, '************* Update_BSB_Request_Id_Column procedure Start *************') ;
147: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Sequence number: ' || to_char(p_sequence_num));
148: FND_FILE.PUT_LINE( FND_FILE.LOG, 'organization_id: ' || to_char(p_organization_id));
149: FND_FILE.PUT_LINE( FND_FILE.LOG, 'assembly_item_id: ' || to_char(p_assembly_item_id));
150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'alternate_bom_designator: ' || p_alternate);
151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'request_id: ' || to_char(p_request_id));
152: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_commit: ' || p_commit);

Line 149: FND_FILE.PUT_LINE( FND_FILE.LOG, 'assembly_item_id: ' || to_char(p_assembly_item_id));

145: BEGIN
146: FND_FILE.PUT_LINE( FND_FILE.LOG, '************* Update_BSB_Request_Id_Column procedure Start *************') ;
147: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Sequence number: ' || to_char(p_sequence_num));
148: FND_FILE.PUT_LINE( FND_FILE.LOG, 'organization_id: ' || to_char(p_organization_id));
149: FND_FILE.PUT_LINE( FND_FILE.LOG, 'assembly_item_id: ' || to_char(p_assembly_item_id));
150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'alternate_bom_designator: ' || p_alternate);
151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'request_id: ' || to_char(p_request_id));
152: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_commit: ' || p_commit);
153: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);

Line 150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'alternate_bom_designator: ' || p_alternate);

146: FND_FILE.PUT_LINE( FND_FILE.LOG, '************* Update_BSB_Request_Id_Column procedure Start *************') ;
147: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Sequence number: ' || to_char(p_sequence_num));
148: FND_FILE.PUT_LINE( FND_FILE.LOG, 'organization_id: ' || to_char(p_organization_id));
149: FND_FILE.PUT_LINE( FND_FILE.LOG, 'assembly_item_id: ' || to_char(p_assembly_item_id));
150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'alternate_bom_designator: ' || p_alternate);
151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'request_id: ' || to_char(p_request_id));
152: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_commit: ' || p_commit);
153: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
154: IF FND_API.To_Boolean(p_commit) THEN

Line 151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'request_id: ' || to_char(p_request_id));

147: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Sequence number: ' || to_char(p_sequence_num));
148: FND_FILE.PUT_LINE( FND_FILE.LOG, 'organization_id: ' || to_char(p_organization_id));
149: FND_FILE.PUT_LINE( FND_FILE.LOG, 'assembly_item_id: ' || to_char(p_assembly_item_id));
150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'alternate_bom_designator: ' || p_alternate);
151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'request_id: ' || to_char(p_request_id));
152: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_commit: ' || p_commit);
153: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
154: IF FND_API.To_Boolean(p_commit) THEN
155: UPDATE BOM_BILL_OF_MATERIALS bbm

Line 152: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_commit: ' || p_commit);

148: FND_FILE.PUT_LINE( FND_FILE.LOG, 'organization_id: ' || to_char(p_organization_id));
149: FND_FILE.PUT_LINE( FND_FILE.LOG, 'assembly_item_id: ' || to_char(p_assembly_item_id));
150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'alternate_bom_designator: ' || p_alternate);
151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'request_id: ' || to_char(p_request_id));
152: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_commit: ' || p_commit);
153: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
154: IF FND_API.To_Boolean(p_commit) THEN
155: UPDATE BOM_BILL_OF_MATERIALS bbm
156: SET bbm.request_id = p_request_id

Line 153: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);

149: FND_FILE.PUT_LINE( FND_FILE.LOG, 'assembly_item_id: ' || to_char(p_assembly_item_id));
150: FND_FILE.PUT_LINE( FND_FILE.LOG, 'alternate_bom_designator: ' || p_alternate);
151: FND_FILE.PUT_LINE( FND_FILE.LOG, 'request_id: ' || to_char(p_request_id));
152: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_commit: ' || p_commit);
153: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
154: IF FND_API.To_Boolean(p_commit) THEN
155: UPDATE BOM_BILL_OF_MATERIALS bbm
156: SET bbm.request_id = p_request_id
157: WHERE bbm.organization_id = p_organization_id

Line 163: FND_FILE.PUT_LINE( FND_FILE.LOG, '* Update_BSB_Request_Id_Column procedure End *') ;

159: AND nvl(bbm.alternate_bom_designator,'NONE') = nvl(p_alternate,'NONE')
160: AND bbm.request_id = P_COMMONBOM_IS_RUNNING;
161: COMMIT ;
162: END IF;
163: FND_FILE.PUT_LINE( FND_FILE.LOG, '************* Update_BSB_Request_Id_Column procedure End *************') ;
164: EXCEPTION
165: WHEN OTHERS THEN
166: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Exception occured in Update_BSB_Request_Id_Column proc') ;
167: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Others '||SQLCODE || ':'||SQLERRM) ;

Line 166: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Exception occured in Update_BSB_Request_Id_Column proc') ;

162: END IF;
163: FND_FILE.PUT_LINE( FND_FILE.LOG, '************* Update_BSB_Request_Id_Column procedure End *************') ;
164: EXCEPTION
165: WHEN OTHERS THEN
166: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Exception occured in Update_BSB_Request_Id_Column proc') ;
167: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Others '||SQLCODE || ':'||SQLERRM) ;
168: FND_FILE.PUT_LINE( FND_FILE.LOG, '************* Update_BSB_Request_Id_Column procedure End *************') ;
169:
170: END Update_BSB_Request_Id_Column;

Line 167: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Others '||SQLCODE || ':'||SQLERRM) ;

163: FND_FILE.PUT_LINE( FND_FILE.LOG, '************* Update_BSB_Request_Id_Column procedure End *************') ;
164: EXCEPTION
165: WHEN OTHERS THEN
166: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Exception occured in Update_BSB_Request_Id_Column proc') ;
167: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Others '||SQLCODE || ':'||SQLERRM) ;
168: FND_FILE.PUT_LINE( FND_FILE.LOG, '************* Update_BSB_Request_Id_Column procedure End *************') ;
169:
170: END Update_BSB_Request_Id_Column;
171:

Line 168: FND_FILE.PUT_LINE( FND_FILE.LOG, '* Update_BSB_Request_Id_Column procedure End *') ;

164: EXCEPTION
165: WHEN OTHERS THEN
166: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Exception occured in Update_BSB_Request_Id_Column proc') ;
167: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Others '||SQLCODE || ':'||SQLERRM) ;
168: FND_FILE.PUT_LINE( FND_FILE.LOG, '************* Update_BSB_Request_Id_Column procedure End *************') ;
169:
170: END Update_BSB_Request_Id_Column;
171:
172:

Line 252: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

248: l_erecord_id NUMBER;
249: -- ERES change ends
250: BEGIN
251: /* Print the list of parameters */
252: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
253: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
254: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
255: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
256: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));

Line 253: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));

249: -- ERES change ends
250: BEGIN
251: /* Print the list of parameters */
252: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
253: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
254: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
255: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
256: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
257: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);

Line 254: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);

250: BEGIN
251: /* Print the list of parameters */
252: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
253: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
254: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
255: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
256: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
257: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
258: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));

Line 255: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));

251: /* Print the list of parameters */
252: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
253: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
254: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
255: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
256: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
257: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
258: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
259: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));

Line 256: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));

252: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
253: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
254: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
255: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
256: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
257: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
258: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
259: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));
260: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

Line 257: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);

253: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
254: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
255: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
256: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
257: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
258: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
259: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));
260: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
261:

Line 258: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));

254: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
255: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
256: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
257: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
258: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
259: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));
260: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
261:
262:

Line 259: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));

255: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
256: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
257: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
258: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
259: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));
260: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
261:
262:
263: /* Start changes of bug 11895331 */

Line 260: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

256: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
257: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
258: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
259: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));
260: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
261:
262:
263: /* Start changes of bug 11895331 */
264:

Line 265: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Start - Getting lock on the bom row') ;

261:
262:
263: /* Start changes of bug 11895331 */
264:
265: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Start - Getting lock on the bom row') ;
266: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
267:
268: -- Storing the original request_id column value in a temporary variable
269: SELECT request_id INTO p_orig_request_id

Line 266: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);

262:
263: /* Start changes of bug 11895331 */
264:
265: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Start - Getting lock on the bom row') ;
266: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
267:
268: -- Storing the original request_id column value in a temporary variable
269: SELECT request_id INTO p_orig_request_id
270: FROM BOM_BILL_OF_MATERIALS bbm1

Line 297: FND_FILE.PUT_LINE( FND_FILE.LOG, 'End - Successfully got the lock on the bom row and processing Common BOM') ;

293: raise eco_implmentation_is_running;
294: end if;
295:
296: COMMIT ; /* Explicit commit is required to make changes visible to all sessions */
297: FND_FILE.PUT_LINE( FND_FILE.LOG, 'End - Successfully got the lock on the bom row and processing Common BOM') ;
298: /* End changes of bug 11895331 */
299:
300: /* Make sure the right set of parameter are passed */
301: IF (scope = 2) AND (org_hierarchy IS NULL) THEN

Line 398: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing Organization : '||t_org_code_list(I));

394: WHERE organization_id = current_org_id ;
395:
396: /*** Loop through the organization in the list of organizations ***/
397: FOR I in starting_org_counter..t_org_code_list.LAST LOOP
398: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing Organization : '||t_org_code_list(I));
399:
400: SELECT organization_code
401: INTO l_org_code_to
402: FROM ORG_ORGANIZATION_DEFINITIONS

Line 580: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted');

576:
577: --bug:5235742 Delete groups API will return 1 when one or more entities
578: --can not be deleted.
579: If ( ( RETCOD <> '0' ) AND ( RETCOD <> '1' ) ) Then
580: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted');
581: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
582: failure_counter := failure_counter + 1 ;
583: ROLLBACK ;
584: to_proceed := 1;

Line 581: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;

577: --bug:5235742 Delete groups API will return 1 when one or more entities
578: --can not be deleted.
579: If ( ( RETCOD <> '0' ) AND ( RETCOD <> '1' ) ) Then
580: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted');
581: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
582: failure_counter := failure_counter + 1 ;
583: ROLLBACK ;
584: to_proceed := 1;
585: Else

Line 594: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' has been deleted succesfully');

590: where DELETE_ENTITY_SEQUENCE_ID = delete_entity_id;
591:
592: If (delete_error_rec = 0) then
593: to_proceed := 2;
594: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' has been deleted succesfully');
595: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
596: Else
597: to_proceed := 1;
598: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted because of delete constraints');

Line 595: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;

591:
592: If (delete_error_rec = 0) then
593: to_proceed := 2;
594: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' has been deleted succesfully');
595: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
596: Else
597: to_proceed := 1;
598: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted because of delete constraints');
599: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;

Line 598: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted because of delete constraints');

594: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' has been deleted succesfully');
595: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
596: Else
597: to_proceed := 1;
598: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted because of delete constraints');
599: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
600: failure_counter := failure_counter + 1 ;
601: End if;
602: End if;

Line 599: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;

595: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
596: Else
597: to_proceed := 1;
598: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted because of delete constraints');
599: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
600: failure_counter := failure_counter + 1 ;
601: End if;
602: End if;
603: END IF;

Line 646: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling BOM_BO_PUB.PROCESS_BOM');

642: security_group_id=>FND_PROFILE.Value('SECURITY_GROUP_ID')) ;
643:
644: /** Initialize the message list **/
645: ERROR_HANDLER.INITIALIZE ;
646: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling BOM_BO_PUB.PROCESS_BOM');
647:
648: /** Call the BOM Business Object **/
649: BOM_BO_PUB.PROCESS_BOM
650: (

Line 680: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully commoned for organization : '||t_org_code_list(I)) ;

676: , p_event_status => 'SUCCESS');
677: -- ERES change ends
678:
679: success_counter := success_counter + 1 ;
680: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully commoned for organization : '||t_org_code_list(I)) ;
681: COMMIT ;
682: ELSE
683: -- ERES change begins
684: Event_Acknowledgement

Line 691: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commoning errored for organization : '||t_org_code_list(I)) ;

687: , p_event_status => 'FAILURE');
688: -- ERES change ends
689:
690: failure_counter := failure_counter + 1 ;
691: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commoning errored for organization : '||t_org_code_list(I)) ;
692: ROLLBACK ;
693: ERROR_HANDLER.GET_MESSAGE_LIST(x_message_list=>l_error_tbl) ;
694: FOR K in l_error_tbl.FIRST..l_error_tbl.LAST LOOP
695: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

Line 695: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

691: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commoning errored for organization : '||t_org_code_list(I)) ;
692: ROLLBACK ;
693: ERROR_HANDLER.GET_MESSAGE_LIST(x_message_list=>l_error_tbl) ;
694: FOR K in l_error_tbl.FIRST..l_error_tbl.LAST LOOP
695: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
696: FND_FILE.PUT_LINE(FND_FILE.LOG,'entity_id : '||l_error_tbl(K).entity_id) ;
697: FND_FILE.PUT_LINE(FND_FILE.LOG,'message_text : '||l_error_tbl(K).message_text) ;
698: END LOOP ;
699: END IF ;

Line 696: FND_FILE.PUT_LINE(FND_FILE.LOG,'entity_id : '||l_error_tbl(K).entity_id) ;

692: ROLLBACK ;
693: ERROR_HANDLER.GET_MESSAGE_LIST(x_message_list=>l_error_tbl) ;
694: FOR K in l_error_tbl.FIRST..l_error_tbl.LAST LOOP
695: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
696: FND_FILE.PUT_LINE(FND_FILE.LOG,'entity_id : '||l_error_tbl(K).entity_id) ;
697: FND_FILE.PUT_LINE(FND_FILE.LOG,'message_text : '||l_error_tbl(K).message_text) ;
698: END LOOP ;
699: END IF ;
700: END IF;

Line 697: FND_FILE.PUT_LINE(FND_FILE.LOG,'message_text : '||l_error_tbl(K).message_text) ;

693: ERROR_HANDLER.GET_MESSAGE_LIST(x_message_list=>l_error_tbl) ;
694: FOR K in l_error_tbl.FIRST..l_error_tbl.LAST LOOP
695: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
696: FND_FILE.PUT_LINE(FND_FILE.LOG,'entity_id : '||l_error_tbl(K).entity_id) ;
697: FND_FILE.PUT_LINE(FND_FILE.LOG,'message_text : '||l_error_tbl(K).message_text) ;
698: END LOOP ;
699: END IF ;
700: END IF;
701: ELSE

Line 705: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

701: ELSE
702: FND_MESSAGE.SET_NAME('BOM','BOM_BILL_EXISTS');
703: FND_MESSAGE.SET_TOKEN('ORG_CODE',t_org_code_list(I));
704: msg := FND_MESSAGE.GET ;
705: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
706: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill already exists for organization '||t_org_code_list(I)) ;
707: END IF ;
708: ELSE
709: FND_MESSAGE.SET_NAME('BOM','BOM_INVALID_ASSEMBLY');

Line 706: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill already exists for organization '||t_org_code_list(I)) ;

702: FND_MESSAGE.SET_NAME('BOM','BOM_BILL_EXISTS');
703: FND_MESSAGE.SET_TOKEN('ORG_CODE',t_org_code_list(I));
704: msg := FND_MESSAGE.GET ;
705: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
706: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill already exists for organization '||t_org_code_list(I)) ;
707: END IF ;
708: ELSE
709: FND_MESSAGE.SET_NAME('BOM','BOM_INVALID_ASSEMBLY');
710: FND_MESSAGE.SET_TOKEN('ASSEMBLY_NAME',l_assy_item_name);

Line 713: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

709: FND_MESSAGE.SET_NAME('BOM','BOM_INVALID_ASSEMBLY');
710: FND_MESSAGE.SET_TOKEN('ASSEMBLY_NAME',l_assy_item_name);
711: FND_MESSAGE.SET_TOKEN('ORG_CODE',t_org_code_list(I));
712: msg := FND_MESSAGE.GET ;
713: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
714: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Assembly item'||l_assy_item_name||'does not exists in organization'||t_org_code_list(I)) ;
715: END IF ;
716: END LOOP ;
717:

Line 714: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Assembly item'||l_assy_item_name||'does not exists in organization'||t_org_code_list(I)) ;

710: FND_MESSAGE.SET_TOKEN('ASSEMBLY_NAME',l_assy_item_name);
711: FND_MESSAGE.SET_TOKEN('ORG_CODE',t_org_code_list(I));
712: msg := FND_MESSAGE.GET ;
713: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
714: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Assembly item'||l_assy_item_name||'does not exists in organization'||t_org_code_list(I)) ;
715: END IF ;
716: END LOOP ;
717:
718: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_SUMMARY');

Line 722: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

718: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_SUMMARY');
719: FND_MESSAGE.SET_TOKEN('ENTITY1','SUCCEDED');
720: FND_MESSAGE.SET_TOKEN('ENTITY2',success_counter);
721: msg := FND_MESSAGE.GET ;
722: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
723:
724: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_SUMMARY');
725: FND_MESSAGE.SET_TOKEN('ENTITY1','FAILED');
726: FND_MESSAGE.SET_TOKEN('ENTITY2',failure_counter);

Line 728: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

724: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_SUMMARY');
725: FND_MESSAGE.SET_TOKEN('ENTITY1','FAILED');
726: FND_MESSAGE.SET_TOKEN('ENTITY2',failure_counter);
727: msg := FND_MESSAGE.GET ;
728: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
729:
730: /*
731: FND_FILE.PUT_LINE(FND_FILE.LOG,'*************SUMMARY***************') ;
732: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations successfully commoned : '||success_counter) ;

Line 731: FND_FILE.PUT_LINE(FND_FILE.LOG,'*SUMMARY***') ;

727: msg := FND_MESSAGE.GET ;
728: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
729:
730: /*
731: FND_FILE.PUT_LINE(FND_FILE.LOG,'*************SUMMARY***************') ;
732: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations successfully commoned : '||success_counter) ;
733: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations for which commoning failed : '||failure_counter) ;
734:
735: */

Line 732: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations successfully commoned : '||success_counter) ;

728: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
729:
730: /*
731: FND_FILE.PUT_LINE(FND_FILE.LOG,'*************SUMMARY***************') ;
732: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations successfully commoned : '||success_counter) ;
733: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations for which commoning failed : '||failure_counter) ;
734:
735: */
736:

Line 733: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations for which commoning failed : '||failure_counter) ;

729:
730: /*
731: FND_FILE.PUT_LINE(FND_FILE.LOG,'*************SUMMARY***************') ;
732: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations successfully commoned : '||success_counter) ;
733: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations for which commoning failed : '||failure_counter) ;
734:
735: */
736:
737: IF (failure_counter > 0) THEN

Line 758: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

754: EXCEPTION
755: WHEN Hierarchy_not_specified THEN
756: FND_MESSAGE.SET_NAME('BOM','BOM_HIERARCHY_MISSING');
757: msg := FND_MESSAGE.GET ;
758: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
759: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Hierarchy Name must be specified') ;
760: RETCODE := 2;
761: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
762: -- Added for bug 11895331. If Common BOM process raises any exception, updating the request_id column to original value.

Line 759: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Hierarchy Name must be specified') ;

755: WHEN Hierarchy_not_specified THEN
756: FND_MESSAGE.SET_NAME('BOM','BOM_HIERARCHY_MISSING');
757: msg := FND_MESSAGE.GET ;
758: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
759: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Hierarchy Name must be specified') ;
760: RETCODE := 2;
761: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
762: -- Added for bug 11895331. If Common BOM process raises any exception, updating the request_id column to original value.
763: Update_BSB_Request_Id_Column( p_request_id => p_orig_request_id,

Line 773: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

769:
770: WHEN invalid_common_itemorg_to THEN
771: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_ITEM_ORG_INVALID');
772: msg := FND_MESSAGE.GET ;
773: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
774: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Either common item to or common org to is not specified') ;
775: RETCODE := 2;
776: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
777: -- Added for bug 11895331. If Common BOM process raises any exception, updating the request_id column to original value.

Line 774: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Either common item to or common org to is not specified') ;

770: WHEN invalid_common_itemorg_to THEN
771: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_ITEM_ORG_INVALID');
772: msg := FND_MESSAGE.GET ;
773: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
774: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Either common item to or common org to is not specified') ;
775: RETCODE := 2;
776: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
777: -- Added for bug 11895331. If Common BOM process raises any exception, updating the request_id column to original value.
778: Update_BSB_Request_Id_Column( p_request_id => p_orig_request_id,

Line 788: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

784:
785: WHEN same_common_itemorg_to THEN
786: FND_MESSAGE.SET_NAME('BOM','BOM_TO_ORG_ITEM_SAME');
787: msg := FND_MESSAGE.GET ;
788: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
789: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'For Single Organization Scope, both TO org and item cannot be same as From org and item') ;
790: RETCODE := 2;
791: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
792: -- Added for bug 11895331. If Common BOM process raises any exception, updating the request_id column to original value.

Line 789: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'For Single Organization Scope, both TO org and item cannot be same as From org and item') ;

785: WHEN same_common_itemorg_to THEN
786: FND_MESSAGE.SET_NAME('BOM','BOM_TO_ORG_ITEM_SAME');
787: msg := FND_MESSAGE.GET ;
788: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
789: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'For Single Organization Scope, both TO org and item cannot be same as From org and item') ;
790: RETCODE := 2;
791: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
792: -- Added for bug 11895331. If Common BOM process raises any exception, updating the request_id column to original value.
793: Update_BSB_Request_Id_Column( p_request_id => p_orig_request_id,

Line 805: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

801: /* Added for bug 11895331, if eco_implmentation_is_running is raised then errored out the process with appropriate message. */
802: WHEN eco_implmentation_is_running THEN
803: FND_MESSAGE.SET_NAME('BOM','BOM_ECO_IMPL_INPROGRESS');
804: msg := FND_MESSAGE.GET ;
805: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
806: RETCODE := 2;
807: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
808:
809: WHEN OTHERS THEN

Line 810: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others '||SQLCODE || ':'||SQLERRM) ;

806: RETCODE := 2;
807: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
808:
809: WHEN OTHERS THEN
810: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others '||SQLCODE || ':'||SQLERRM) ;
811: RETCODE := 2;
812: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
813: -- Added for bug 11895331. If Common BOM process raises any exception, updating the request_id column to original value.
814: Update_BSB_Request_Id_Column( p_request_id => p_orig_request_id,

Line 1081: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

1077: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1078: , p_Token_Tbl => l_token_table
1079: );
1080: fnd_message.set_name('BOM', 'BOM_EDIT_COMM_INVALID_EFF');
1081: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1082: /*Error_Handler.Log_Error
1083: (p_error_status => FND_API.G_RET_STS_ERROR
1084: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1085: , p_error_scope => Error_Handler.G_SCOPE_RECORD