APPS.IGW_PROP_PROGRAM_ADDRESSES_TBH dependencies on FND_API

Line 19: x_return_status := FND_API.G_RET_STS_SUCCESS;

15: X_LAST_UPDATE_DATE DATE;
16: X_LAST_UPDATED_BY NUMBER;
17: X_LAST_UPDATE_LOGIN NUMBER;
18: begin
19: x_return_status := FND_API.G_RET_STS_SUCCESS;
20:
21: X_LAST_UPDATE_DATE := SYSDATE;
22: if(X_MODE = 'I') then
23: X_LAST_UPDATED_BY := 1;

Line 52: decode(X_NUMBER_OF_COPIES, FND_API.G_MISS_CHAR, NULL, X_NUMBER_OF_COPIES),

48: LAST_UPDATE_LOGIN
49: ) values (
50: X_PROPOSAL_ID,
51: X_ADDRESS_ID,
52: decode(X_NUMBER_OF_COPIES, FND_API.G_MISS_CHAR, NULL, X_NUMBER_OF_COPIES),
53: decode(X_MAIL_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_MAIL_DESCRIPTION),
54: 1,
55: X_LAST_UPDATE_DATE,
56: X_LAST_UPDATED_BY,

Line 53: decode(X_MAIL_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_MAIL_DESCRIPTION),

49: ) values (
50: X_PROPOSAL_ID,
51: X_ADDRESS_ID,
52: decode(X_NUMBER_OF_COPIES, FND_API.G_MISS_CHAR, NULL, X_NUMBER_OF_COPIES),
53: decode(X_MAIL_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_MAIL_DESCRIPTION),
54: 1,
55: X_LAST_UPDATE_DATE,
56: X_LAST_UPDATED_BY,
57: X_LAST_UPDATE_DATE,

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

70: EXCEPTION
71: WHEN OTHERS THEN
72: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_PROGRAM_ADDRESSES_TBH'
73: ,p_procedure_name => 'INSERT_ROW' );
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
75: RAISE;
76: end INSERT_ROW;
77: ---------------------------------------------------------------------------------
78: procedure UPDATE_ROW (

Line 102: x_return_status := FND_API.G_RET_STS_SUCCESS;

98: AND address_id = x_address_id;
99:
100: begin
101:
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103:
104: IF l_row_id IS NULL THEN
105: OPEN get_row_id;
106: FETCH get_row_id INTO l_row_id;

Line 128: NUMBER_OF_COPIES = decode(X_NUMBER_OF_COPIES, FND_API.G_MISS_CHAR, NULL, X_NUMBER_OF_COPIES),

124: app_exception.raise_exception;
125: end if;
126: update IGW_PROP_PROGRAM_ADDRESSES set
127: ADDRESS_ID = X_ADDRESS_ID,
128: NUMBER_OF_COPIES = decode(X_NUMBER_OF_COPIES, FND_API.G_MISS_CHAR, NULL, X_NUMBER_OF_COPIES),
129: MAIL_DESCRIPTION = decode(X_MAIL_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_MAIL_DESCRIPTION),
130: RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER + 1,
131: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
132: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 129: MAIL_DESCRIPTION = decode(X_MAIL_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_MAIL_DESCRIPTION),

125: end if;
126: update IGW_PROP_PROGRAM_ADDRESSES set
127: ADDRESS_ID = X_ADDRESS_ID,
128: NUMBER_OF_COPIES = decode(X_NUMBER_OF_COPIES, FND_API.G_MISS_CHAR, NULL, X_NUMBER_OF_COPIES),
129: MAIL_DESCRIPTION = decode(X_MAIL_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_MAIL_DESCRIPTION),
130: RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER + 1,
131: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
132: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
133: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

143: EXCEPTION
144: WHEN OTHERS THEN
145: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_MAILING_INFO_TBH'
146: ,p_procedure_name => 'UPDATE_ROW' );
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148: RAISE;
149: end UPDATE_ROW;
150: -----------------------------------------------------------------------
151:

Line 169: x_return_status := FND_API.G_RET_STS_SUCCESS;

165: WHERE proposal_id = x_proposal_id
166: AND address_id = x_address_id;
167:
168: begin
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170:
171: IF l_row_id IS NULL THEN
172: OPEN get_row_id;
173: FETCH get_row_id INTO l_row_id;

Line 193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

189: EXCEPTION
190: WHEN OTHERS THEN
191: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_PROGRAM_ADDRESSES_TBH'
192: ,p_procedure_name => 'DELETE_ROW' );
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
194: RAISE;
195: end DELETE_ROW;
196:
197: end IGW_PROP_PROGRAM_ADDRESSES_TBH;