DBA Data[Home] [Help]

APPS.MTL_CCEOI_ACTION_PUB dependencies on FND_API

Line 37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 38: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 39: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 57: -- DEFAULT = FND_API.G_FALSE,

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

Line 59: -- DEFAULT = FND_API.G_FALSE,

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)

Line 61: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

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

Line 78: -- FND_API.G_RET_STS_SUCCESS if success

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

Line 79: -- FND_API.G_RET_STS_ERROR if error

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:

Line 80: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

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

Line 85: -- check only if x_return_status <> fnd_api.g_ret_sts_success

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

Line 449: p_commit => FND_API.G_TRUE,

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,

Line 457: if (lstatus = fnd_api.g_ret_sts_success) then

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;

Line 479: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 480: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 481: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

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