DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on WSM_SERIAL_SUPPORT_PVT

Line 7773: WSM_Serial_support_Pvt.Move_serial_intf_proc ( p_header_id => l_header_id ,

7769: l_scrap_quantity := l_converted_scrap_qty;
7770: l_scrap_txn_id1 := l_scrap_txn_id;
7771: end if;
7772:
7773: WSM_Serial_support_Pvt.Move_serial_intf_proc ( p_header_id => l_header_id ,
7774: -- p_wsm_serial_nums_tbl => p_jobop_scrap_serials_tbls(l_header_id),
7775: p_wsm_serial_nums_tbl => l_serial_tbl,
7776: p_move_txn_type => l_transaction_type ,
7777: p_wip_entity_id => l_wip_entity_id ,

Line 7813: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Move_serial_intf_proc returned Success');

7809: );
7810:
7811: if l_return_status = FND_API.G_RET_STS_SUCCESS then
7812: IF (l_debug='Y') THEN
7813: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Move_serial_intf_proc returned Success');
7814: END IF;
7815: ELSE
7816:
7817: IF (l_error_count = 1) THEN

Line 7827: l_error_msg := 'WSM_Serial_support_PVT.LBJ_serial_intf_proc returned failure';

7823: );
7824: fnd_file.put_line(fnd_file.log, l_error_msg);
7825: END LOOP;
7826: ELSE
7827: l_error_msg := 'WSM_Serial_support_PVT.LBJ_serial_intf_proc returned failure';
7828: END IF;
7829:
7830: IF (l_debug='Y') THEN
7831: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Move_serial_intf_proc returned failure');

Line 7831: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Move_serial_intf_proc returned failure');

7827: l_error_msg := 'WSM_Serial_support_PVT.LBJ_serial_intf_proc returned failure';
7828: END IF;
7829:
7830: IF (l_debug='Y') THEN
7831: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Move_serial_intf_proc returned failure');
7832: END IF;
7833:
7834: ROLLBACK TO validation;
7835: error_handler(p_header_id => l_header_id ,

Line 8937: p_msg_text => 'B4 calling WSM_Serial_support_PVT.Insert_MOVE_attr',

8933: BEGIN
8934: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8935: l_msg_tokens.delete;
8936: WSM_log_PVT.logMessage ( p_module_name => l_module ,
8937: p_msg_text => 'B4 calling WSM_Serial_support_PVT.Insert_MOVE_attr',
8938: p_stmt_num => l_stmt_num ,
8939: p_msg_tokens => l_msg_tokens ,
8940: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8941: p_run_log_level => l_log_level

Line 8946: WSM_Serial_support_PVT.Insert_MOVE_attr ( p_group_id => null ,

8942: );
8943: END IF;
8944:
8945: l_stmt_num := 253.13;
8946: WSM_Serial_support_PVT.Insert_MOVE_attr ( p_group_id => null ,
8947: p_move_txn_id => l_transaction_id ,
8948: p_scrap_txn_id => l_scrap_txn_id ,
8949: x_return_status => l_return_status ,
8950: x_error_count => l_error_msg ,

Line 8956: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned Success');

8952: );
8953:
8954: if l_return_status = FND_API.G_RET_STS_SUCCESS then
8955: IF (l_debug='Y') THEN
8956: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned Success');
8957: END IF;
8958:
8959: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8960: l_msg_tokens.delete;

Line 8962: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned successfully',

8958:
8959: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
8960: l_msg_tokens.delete;
8961: WSM_log_PVT.logMessage (p_module_name => l_module ,
8962: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned successfully',
8963: p_stmt_num => l_stmt_num ,
8964: p_msg_tokens => l_msg_tokens ,
8965: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
8966: p_run_log_level => l_log_level

Line 8973: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned error',

8969: ELSE
8970: IF (G_LOG_LEVEL_ERROR >= l_log_level) THEN
8971: l_msg_tokens.delete;
8972: WSM_log_PVT.logMessage ( p_module_name => l_module ,
8973: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned error',
8974: p_stmt_num => l_stmt_num ,
8975: p_msg_tokens => l_msg_tokens ,
8976: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
8977: p_run_log_level => l_log_level

Line 8990: l_error_msg := 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure';

8986: );
8987: fnd_file.put_line(fnd_file.log, l_error_msg);
8988: END LOOP;
8989: ELSE
8990: l_error_msg := 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure';
8991: END IF;
8992:
8993: IF (l_debug='Y') THEN
8994: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure');

Line 8994: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure');

8990: l_error_msg := 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure';
8991: END IF;
8992:
8993: IF (l_debug='Y') THEN
8994: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure');
8995: END IF;
8996: -- This call is supposed to not return any error...
8997: raise e_proc_exception;
8998: END IF;

Line 10004: WSM_Serial_support_PVT.Update_attr_move( p_group_id => NULL ,

10000: l_move_txn_id := l_transaction_id;
10001: l_scrap_id := l_scrap_txn_id ;
10002:
10003:
10004: WSM_Serial_support_PVT.Update_attr_move( p_group_id => NULL ,
10005: p_internal_group_id => NULL ,
10006: p_move_txn_id => l_move_txn_id ,
10007: p_scrap_txn_id => l_scrap_id ,
10008: p_organization_id => null ,

Line 10016: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned Success');

10012: );
10013:
10014: if l_return_status = FND_API.G_RET_STS_SUCCESS then
10015: IF (l_debug='Y') THEN
10016: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned Success');
10017: END IF;
10018: ELSE
10019: IF (l_error_count = 1) THEN
10020: fnd_file.put_line(fnd_file.log, l_error_msg);

Line 10029: l_error_msg := 'WSM_Serial_support_PVT.Update_attr_move returned failure';

10025: );
10026: fnd_file.put_line(fnd_file.log, l_error_msg);
10027: END LOOP;
10028: ELSE
10029: l_error_msg := 'WSM_Serial_support_PVT.Update_attr_move returned failure';
10030: END IF;
10031:
10032: IF (l_debug='Y') THEN
10033: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned failure');

Line 10033: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned failure');

10029: l_error_msg := 'WSM_Serial_support_PVT.Update_attr_move returned failure';
10030: END IF;
10031:
10032: IF (l_debug='Y') THEN
10033: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned failure');
10034: END IF;
10035: -- This call is supposed to not return any error...
10036: raise e_proc_exception;
10037:

Line 10076: p_msg_text => 'B4 calling WSM_Serial_support_PVT.Insert_MOVE_attr',

10072: BEGIN
10073: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10074: l_msg_tokens.delete;
10075: WSM_log_PVT.logMessage ( p_module_name => l_module ,
10076: p_msg_text => 'B4 calling WSM_Serial_support_PVT.Insert_MOVE_attr',
10077: p_stmt_num => l_stmt_num ,
10078: p_msg_tokens => l_msg_tokens ,
10079: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10080: p_run_log_level => l_log_level

Line 10085: WSM_Serial_support_PVT.Insert_MOVE_attr ( p_group_id => l_wmti_group_id ,

10081: );
10082: END IF;
10083:
10084: l_stmt_num := 253.13;
10085: WSM_Serial_support_PVT.Insert_MOVE_attr ( p_group_id => l_wmti_group_id ,
10086: x_return_status => l_return_status ,
10087: x_error_count => l_error_msg ,
10088: x_error_msg => l_error_count
10089: );

Line 10093: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned Success');

10089: );
10090:
10091: if l_return_status = FND_API.G_RET_STS_SUCCESS then
10092: IF (l_debug='Y') THEN
10093: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned Success');
10094: END IF;
10095:
10096: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10097: l_msg_tokens.delete;

Line 10099: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned successfully',

10095:
10096: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10097: l_msg_tokens.delete;
10098: WSM_log_PVT.logMessage (p_module_name => l_module ,
10099: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned successfully',
10100: p_stmt_num => l_stmt_num ,
10101: p_msg_tokens => l_msg_tokens ,
10102: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
10103: p_run_log_level => l_log_level

Line 10110: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned error',

10106: ELSE
10107: IF (G_LOG_LEVEL_ERROR >= l_log_level) THEN
10108: l_msg_tokens.delete;
10109: WSM_log_PVT.logMessage ( p_module_name => l_module ,
10110: p_msg_text => 'WSM_Serial_support_PVT.Insert_MOVE_attr returned error',
10111: p_stmt_num => l_stmt_num ,
10112: p_msg_tokens => l_msg_tokens ,
10113: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
10114: p_run_log_level => l_log_level

Line 10127: l_error_msg := 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure';

10123: );
10124: fnd_file.put_line(fnd_file.log, l_error_msg);
10125: END LOOP;
10126: ELSE
10127: l_error_msg := 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure';
10128: END IF;
10129:
10130: IF (l_debug='Y') THEN
10131: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure');

Line 10131: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure');

10127: l_error_msg := 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure';
10128: END IF;
10129:
10130: IF (l_debug='Y') THEN
10131: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned failure');
10132: END IF;
10133: -- This call is supposed to not return any error...
10134: raise e_proc_exception;
10135: END IF;

Line 10959: WSM_Serial_support_PVT.Update_attr_move( p_group_id => l_group_id ,

10955: l_internal_group_id := l_wmti_group_id;
10956: --END IF;
10957: -- ST : Serial MES Fix : End
10958:
10959: WSM_Serial_support_PVT.Update_attr_move( p_group_id => l_group_id ,
10960: p_internal_group_id => l_internal_group_id ,
10961: p_move_txn_id => l_move_txn_id ,
10962: p_scrap_txn_id => l_scrap_id ,
10963: -- Pass the org as NULL since can process across orgs...

Line 10972: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned Success');

10968: );
10969:
10970: if l_return_status = FND_API.G_RET_STS_SUCCESS then
10971: IF (l_debug='Y') THEN
10972: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned Success');
10973: END IF;
10974: ELSE
10975: IF (l_error_count = 1) THEN
10976: fnd_file.put_line(fnd_file.log, l_error_msg);

Line 10985: l_error_msg := 'WSM_Serial_support_PVT.Update_attr_move returned failure';

10981: );
10982: fnd_file.put_line(fnd_file.log, l_error_msg);
10983: END LOOP;
10984: ELSE
10985: l_error_msg := 'WSM_Serial_support_PVT.Update_attr_move returned failure';
10986: END IF;
10987:
10988: IF (l_debug='Y') THEN
10989: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned failure');

Line 10989: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned failure');

10985: l_error_msg := 'WSM_Serial_support_PVT.Update_attr_move returned failure';
10986: END IF;
10987:
10988: IF (l_debug='Y') THEN
10989: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned failure');
10990: END IF;
10991: -- This call is supposed to not return any error...
10992: raise e_proc_exception;
10993: