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 8935: p_msg_text => 'B4 calling WSM_Serial_support_PVT.Insert_MOVE_attr',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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