33: * @rep:displayname Import Cycle Count Entries
34: */
35: PROCEDURE Import_CountRequest(
36: p_api_version IN NUMBER ,
37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
40: X_return_status OUT NOCOPY VARCHAR2 ,
41: x_errorcode OUT NOCOPY NUMBER,
34: */
35: PROCEDURE Import_CountRequest(
36: p_api_version IN NUMBER ,
37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
40: X_return_status OUT NOCOPY VARCHAR2 ,
41: x_errorcode OUT NOCOPY NUMBER,
42: x_msg_count OUT NOCOPY NUMBER ,
35: PROCEDURE Import_CountRequest(
36: p_api_version IN NUMBER ,
37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
40: X_return_status OUT NOCOPY VARCHAR2 ,
41: x_errorcode OUT NOCOPY NUMBER,
42: x_msg_count OUT NOCOPY NUMBER ,
43: x_msg_data OUT NOCOPY VARCHAR2 ,
53: -- Parameters:
54: -- IN : p_api_version IN NUMBER (required)
55: -- API Version of this procedure
56: -- p_init_msg_level IN VARCHAR2 (optional)
57: -- DEFAULT = FND_API.G_FALSE,
58: -- p_commit IN VARCHAR2 (optional)
59: -- DEFAULT = FND_API.G_FALSE,
60: -- p_validation_level IN NUMBER (optional)
61: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
55: -- API Version of this procedure
56: -- p_init_msg_level IN VARCHAR2 (optional)
57: -- DEFAULT = FND_API.G_FALSE,
58: -- p_commit IN VARCHAR2 (optional)
59: -- DEFAULT = FND_API.G_FALSE,
60: -- p_validation_level IN NUMBER (optional)
61: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
62: -- (not used at present time)
63: -- p_interface_rec IN CCEOI_Rec_Type (required)
57: -- DEFAULT = FND_API.G_FALSE,
58: -- p_commit IN VARCHAR2 (optional)
59: -- DEFAULT = FND_API.G_FALSE,
60: -- p_validation_level IN NUMBER (optional)
61: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
62: -- (not used at present time)
63: -- p_interface_rec IN CCEOI_Rec_Type (required)
64: -- complete interface RECORD
65: -- See description below for instructions on setting this parameter
74: -- returns interface id of record processed
75: --
76: -- X_return_status OUT NUMBER
77: -- Result of all the operations
78: -- FND_API.G_RET_STS_SUCCESS if success
79: -- FND_API.G_RET_STS_ERROR if error
80: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
81: --
82: -- X_ErrorCode OUT NUMBER
75: --
76: -- X_return_status OUT NUMBER
77: -- Result of all the operations
78: -- FND_API.G_RET_STS_SUCCESS if success
79: -- FND_API.G_RET_STS_ERROR if error
80: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
81: --
82: -- X_ErrorCode OUT NUMBER
83:
76: -- X_return_status OUT NUMBER
77: -- Result of all the operations
78: -- FND_API.G_RET_STS_SUCCESS if success
79: -- FND_API.G_RET_STS_ERROR if error
80: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
81: --
82: -- X_ErrorCode OUT NUMBER
83:
84: -- RETURN value OF the x_errorcode
81: --
82: -- X_ErrorCode OUT NUMBER
83:
84: -- RETURN value OF the x_errorcode
85: -- check only if x_return_status <> fnd_api.g_ret_sts_success
86: --
87: -- These errors are unrecoverable and interface record was not
88: -- inserted as a result of this thing
89: -- 200 - Interface row is locked by someone else
445:
446: -- call API
447: mtl_cceoi_action_pub.import_CountRequest(
448: p_api_version => 0.9,
449: p_commit => FND_API.G_TRUE,
450: x_return_status => lstatus,
451: x_errorcode => l_errorcode
452: x_msg_count => lmsg_count,
453: x_msg_data => lmsg_data,
453: x_msg_data => lmsg_data,
454: p_interface_rec => lrec,
455: x_interface_id => l_interface_id);
456:
457: if (lstatus = fnd_api.g_ret_sts_success) then
458: ....
459: else
460: ....
461: end if;
475: --
476: PROCEDURE Process_LPN_CountRequest
477: (
478: p_api_version IN NUMBER
479: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
480: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
481: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
482: , x_return_status OUT NOCOPY VARCHAR2
483: , x_errorcode OUT NOCOPY NUMBER
476: PROCEDURE Process_LPN_CountRequest
477: (
478: p_api_version IN NUMBER
479: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
480: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
481: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
482: , x_return_status OUT NOCOPY VARCHAR2
483: , x_errorcode OUT NOCOPY NUMBER
484: , x_msg_count OUT NOCOPY NUMBER
477: (
478: p_api_version IN NUMBER
479: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
480: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
481: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
482: , x_return_status OUT NOCOPY VARCHAR2
483: , x_errorcode OUT NOCOPY NUMBER
484: , x_msg_count OUT NOCOPY NUMBER
485: , x_msg_data OUT NOCOPY VARCHAR2