eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on FND_API

Line 85: x_account_id := FND_API.G_MISS_NUM;

81:
82: BEGIN
83:
84: IF p_party_site_id IS NULL THEN
85: x_account_id := FND_API.G_MISS_NUM;
86: ELSE
87: SELECT party_id
88: INTO l_party_id
89: FROM HZ_PARTY_SITES

Line 96: x_account_id := FND_API.G_MISS_NUM;

92: IF l_party_id = p_sold_to_customer_party THEN
93: IF p_sold_to_customer_account is not null then
94: x_account_id := p_sold_to_customer_account;
95: ELSE
96: x_account_id := FND_API.G_MISS_NUM;
97: END IF;
98: ELSIF l_party_id <> p_sold_to_customer_party THEN
99: BEGIN
100:

Line 173: RAISE FND_API.G_EXC_ERROR;

169: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
170: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
171: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
172: FND_MSG_PUB.Add;
173: RAISE FND_API.G_EXC_ERROR;
174: End if;
175: End if;
176: EXCEPTION
177: WHEN NO_DATA_FOUND THEN

Line 178: x_account_id := FND_API.G_MISS_NUM;

174: End if;
175: End if;
176: EXCEPTION
177: WHEN NO_DATA_FOUND THEN
178: x_account_id := FND_API.G_MISS_NUM;
179: END;
180:
181: IF x_account_id is null THEN
182: x_account_id := FND_API.G_MISS_NUM;

Line 182: x_account_id := FND_API.G_MISS_NUM;

178: x_account_id := FND_API.G_MISS_NUM;
179: END;
180:
181: IF x_account_id is null THEN
182: x_account_id := FND_API.G_MISS_NUM;
183: END IF;
184: END IF;
185: END IF;
186: END Get_acct_from_party_site;

Line 234: x_return_status := FND_API.G_RET_STS_SUCCESS;

230: l_inv_org_name varchar2(300);
231:
232: BEGIN
233:
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: IF p_org_id is not null and
237: p_party_site_id is not null and
238: p_account_id is not null THEN

Line 264: RAISE FND_API.G_EXC_ERROR;

260: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
261: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
262: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
263: FND_MSG_PUB.Add;
264: RAISE FND_API.G_EXC_ERROR;
265: End if;
266: ELSE
267: close acct_site_csr;
268: -- Raise error if active customer account site doesn't exist but an inactive

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: close acct_site_csr;
268: -- Raise error if active customer account site doesn't exist but an inactive
269: -- custoemr account site exist. Charges will raise a clear error message instead of
270: -- passing this data to OC.
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_CUST_ACCT_SITE');
273: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);
274: FND_MESSAGE.SET_TOKEN('PARTY_SITE_ID', p_party_site_id);
275: FND_MSG_PUB.Add;

Line 276: RAISE FND_API.G_EXC_ERROR;

272: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_CUST_ACCT_SITE');
273: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);
274: FND_MESSAGE.SET_TOKEN('PARTY_SITE_ID', p_party_site_id);
275: FND_MSG_PUB.Add;
276: RAISE FND_API.G_EXC_ERROR;
277: END IF;
278: ELSE
279: close acct_site_csr;
280:

Line 300: RAISE FND_API.G_EXC_ERROR;

296: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
297: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
298: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
299: FND_MSG_PUB.Add;
300: RAISE FND_API.G_EXC_ERROR;
301: End if;
302: ELSE
303: close acct_site_use_csr;
304: -- Raise error if active bill to or ship to account site use doesn't exist but an

Line 307: x_return_status := FND_API.G_RET_STS_ERROR;

303: close acct_site_use_csr;
304: -- Raise error if active bill to or ship to account site use doesn't exist but an
305: -- inactive bill to or ship to account site use exist. Charges will raise a clear
306: -- error message instead of passing this data to OC.
307: x_return_status := FND_API.G_RET_STS_ERROR;
308: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_ACCT_SITE_USE');
309: FND_MESSAGE.SET_TOKEN('SITE_USE_CODE', p_site_use_code);
310: FND_MESSAGE.SET_TOKEN('ACCT_SITE_USE_ID', l_site_use_id);
311: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);

Line 313: RAISE FND_API.G_EXC_ERROR;

309: FND_MESSAGE.SET_TOKEN('SITE_USE_CODE', p_site_use_code);
310: FND_MESSAGE.SET_TOKEN('ACCT_SITE_USE_ID', l_site_use_id);
311: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);
312: FND_MSG_PUB.Add;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315: ELSE
316: close acct_site_use_csr;
317: END IF;

Line 324: WHEN FND_API.G_EXC_ERROR THEN

320: END IF;
321: END IF;
322:
323: EXCEPTION
324: WHEN FND_API.G_EXC_ERROR THEN
325: x_return_status := FND_API.G_RET_STS_ERROR;
326:
327: FND_MSG_PUB.Count_And_Get
328: (p_count => x_msg_count,

Line 325: x_return_status := FND_API.G_RET_STS_ERROR;

321: END IF;
322:
323: EXCEPTION
324: WHEN FND_API.G_EXC_ERROR THEN
325: x_return_status := FND_API.G_RET_STS_ERROR;
326:
327: FND_MSG_PUB.Count_And_Get
328: (p_count => x_msg_count,
329: p_data => x_msg_data);

Line 434: p_book_order_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

430: p_validation_level IN NUMBER,
431: p_incident_id IN NUMBER,
432: p_party_id IN NUMBER,
433: p_account_id IN NUMBER,
434: p_book_order_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_submit_source IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_submit_from_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,

Line 435: p_submit_source IN VARCHAR2 := FND_API.G_MISS_CHAR,

431: p_incident_id IN NUMBER,
432: p_party_id IN NUMBER,
433: p_account_id IN NUMBER,
434: p_book_order_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_submit_source IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_submit_from_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2

Line 436: p_submit_from_system IN VARCHAR2 := FND_API.G_MISS_CHAR,

432: p_party_id IN NUMBER,
433: p_account_id IN NUMBER,
434: p_book_order_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_submit_source IN VARCHAR2 := FND_API.G_MISS_CHAR,
436: p_submit_from_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2
440: )

Line 774: IF NOT FND_API.Compatible_API_Call( l_api_version,

770: -- Standard Start of API Savepoint
771: SAVEPOINT CS_Charge_Create_Order_PVT;
772:
773: -- Standard Call to check API compatibility
774: IF NOT FND_API.Compatible_API_Call( l_api_version,
775: p_api_version,
776: l_api_name,
777: G_PKG_NAME) THEN
778: RAISE FND_API.G_EXC_ERROR ;

Line 778: RAISE FND_API.G_EXC_ERROR ;

774: IF NOT FND_API.Compatible_API_Call( l_api_version,
775: p_api_version,
776: l_api_name,
777: G_PKG_NAME) THEN
778: RAISE FND_API.G_EXC_ERROR ;
779: END IF;
780:
781: -- Initialize message list if p_init_msg_list is set to TRUE.
782: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 782: IF FND_API.to_Boolean( p_init_msg_list ) THEN

778: RAISE FND_API.G_EXC_ERROR ;
779: END IF;
780:
781: -- Initialize message list if p_init_msg_list is set to TRUE.
782: IF FND_API.to_Boolean( p_init_msg_list ) THEN
783: FND_MSG_PUB.initialize;
784: END IF;
785:
786: -- Initialize API return status to success

Line 787: x_return_status := FND_API.G_RET_STS_SUCCESS;

783: FND_MSG_PUB.initialize;
784: END IF;
785:
786: -- Initialize API return status to success
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788:
789: ----------------------- FND Logging -----------------------------------
790: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
791: THEN

Line 857: RAISE FND_API.G_EXC_ERROR;

853: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
854: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
855: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
856: FND_MSG_PUB.Add;
857: RAISE FND_API.G_EXC_ERROR;
858: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: END IF;
860: IF (p_party_id is null) THEN
861: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 858: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

854: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
855: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
856: FND_MSG_PUB.Add;
857: RAISE FND_API.G_EXC_ERROR;
858: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: END IF;
860: IF (p_party_id is null) THEN
861: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
862: THEN

Line 872: RAISE FND_API.G_EXC_ERROR;

868: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
869: FND_MESSAGE.Set_Token('PARAM','p_party_id');
870: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
871: FND_MSG_PUB.Add;
872: RAISE FND_API.G_EXC_ERROR;
873: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
874: END IF;
875:
876: -- Added validations for 11.5.10 parameters. There is no validation required

Line 873: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

869: FND_MESSAGE.Set_Token('PARAM','p_party_id');
870: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
871: FND_MSG_PUB.Add;
872: RAISE FND_API.G_EXC_ERROR;
873: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
874: END IF;
875:
876: -- Added validations for 11.5.10 parameters. There is no validation required
877: -- for submit_from_system parameter.

Line 879: IF (p_book_order_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR)) THEN

875:
876: -- Added validations for 11.5.10 parameters. There is no validation required
877: -- for submit_from_system parameter.
878: --
879: IF (p_book_order_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR)) THEN
880: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
881: THEN
882: FND_LOG.String
883: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'

Line 891: RAISE FND_API.G_EXC_ERROR;

887: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
888: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
889: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
890: FND_MSG_PUB.Add;
891: RAISE FND_API.G_EXC_ERROR;
892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894:
895: IF (p_submit_source NOT IN ('SR','DR','FS',FND_API.G_MISS_CHAR)) THEN

Line 892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

888: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
889: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
890: FND_MSG_PUB.Add;
891: RAISE FND_API.G_EXC_ERROR;
892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894:
895: IF (p_submit_source NOT IN ('SR','DR','FS',FND_API.G_MISS_CHAR)) THEN
896: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 895: IF (p_submit_source NOT IN ('SR','DR','FS',FND_API.G_MISS_CHAR)) THEN

891: RAISE FND_API.G_EXC_ERROR;
892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894:
895: IF (p_submit_source NOT IN ('SR','DR','FS',FND_API.G_MISS_CHAR)) THEN
896: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
897: THEN
898: FND_LOG.String
899: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'

Line 907: RAISE FND_API.G_EXC_ERROR;

903: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
904: FND_MESSAGE.Set_Token('PARAM','p_submit_source');
905: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
906: FND_MSG_PUB.Add;
907: RAISE FND_API.G_EXC_ERROR;
908: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910: --- End of 11.5.10 parameter validations
911: ---

Line 908: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

904: FND_MESSAGE.Set_Token('PARAM','p_submit_source');
905: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
906: FND_MSG_PUB.Add;
907: RAISE FND_API.G_EXC_ERROR;
908: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910: --- End of 11.5.10 parameter validations
911: ---
912: get_who_info(l_login_id,l_user_id);

Line 930: RAISE FND_API.G_EXC_ERROR;

926: END IF;
927: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_NUM_IN_SR');
928: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
929: FND_MSG_PUB.Add;
930: RAISE FND_API.G_EXC_ERROR;
931: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: --srini
933: ELSIF l_acct_no = 0 then
934: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then

Line 931: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

927: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_NUM_IN_SR');
928: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
929: FND_MSG_PUB.Add;
930: RAISE FND_API.G_EXC_ERROR;
931: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: --srini
933: ELSIF l_acct_no = 0 then
934: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then
935: Open Get_party_number;

Line 942: RAISE FND_API.G_EXC_ERROR;

938:
939: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT');
940: FND_MESSAGE.Set_Token('SOLD_TO_PARTY',l_party_number);
941: FND_MSG_PUB.Add;
942: RAISE FND_API.G_EXC_ERROR;
943: End if;
944: END IF;
945:
946: -- Get modifier for OM adjustment lines

Line 968: RAISE FND_API.G_EXC_ERROR;

964: EXCEPTION
965: WHEN OTHERS THEN
966: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_DEFAULT_MODIFIER');
967: FND_MSG_PUB.Add;
968: RAISE FND_API.G_EXC_ERROR;
969: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END;
971:
972: --

Line 969: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

965: WHEN OTHERS THEN
966: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_DEFAULT_MODIFIER');
967: FND_MSG_PUB.Add;
968: RAISE FND_API.G_EXC_ERROR;
969: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END;
971:
972: --
973: -- Check the value of book_order_flag.Changes for 11.5.10

Line 991: p_book_order_flag = FND_API.G_MISS_CHAR THEN

987: l_book_order_profile := 'N';
988: END IF;
989:
990: IF p_book_order_flag IS NOT NULL OR
991: p_book_order_flag = FND_API.G_MISS_CHAR THEN
992: l_book_order_flag := p_book_order_flag;
993:
994: ELSIF p_book_order_flag IS NULL THEN
995: l_book_order_flag := l_book_order_profile;

Line 1004: RAISE FND_API.G_EXC_ERROR;

1000: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
1001: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
1002: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
1003: FND_MSG_PUB.Add;
1004: RAISE FND_API.G_EXC_ERROR;
1005: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006:
1007: END;
1008: -- End of Book Order Flag

Line 1005: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1001: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
1002: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
1003: FND_MSG_PUB.Add;
1004: RAISE FND_API.G_EXC_ERROR;
1005: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006:
1007: END;
1008: -- End of Book Order Flag
1009: --

Line 1021: ELSIF p_submit_source = FND_API.G_MISS_CHAR THEN

1017: l_ctrl_source := NULL;
1018: ELSIF p_submit_source = 'FS' THEN
1019: l_ctrl_orig_source := 'SR';
1020: l_ctrl_source := 'SD';
1021: ELSIF p_submit_source = FND_API.G_MISS_CHAR THEN
1022: l_ctrl_orig_source := NULL;
1023: l_ctrl_source := NULL;
1024: END IF;
1025:

Line 1068: l_control_rec.calculate_price := FND_API.G_FALSE;

1064:
1065: l_record_found := 'Y';
1066: --
1067: --
1068: l_control_rec.calculate_price := FND_API.G_FALSE;
1069: l_org_id := EstDtlTab(i).org_id;
1070:
1071: OPEN Fetch_Est_Ord_Dtl(EstDtlTab(i).currency_code,EstDtlTab(i).price_list_header_id,
1072: EstDtlTab(i).invoice_to_org_id,EstDtlTab(i).ship_to_org_id,

Line 1118: l_control_rec.book_flag := FND_API.G_FALSE;

1114: l_order_status_flag IS NULL or
1115: l_order_status_flag = 'N') and
1116: l_book_order_flag = 'N' THEN
1117:
1118: l_control_rec.book_flag := FND_API.G_FALSE;
1119:
1120: ELSIF (l_order_status_flag = 'Y' and
1121: l_book_order_flag = 'Y') THEN
1122:

Line 1123: l_control_rec.book_flag := FND_API.G_FALSE;

1119:
1120: ELSIF (l_order_status_flag = 'Y' and
1121: l_book_order_flag = 'Y') THEN
1122:
1123: l_control_rec.book_flag := FND_API.G_FALSE;
1124:
1125: ELSIF l_order_status_flag = 'N' and
1126: l_book_order_flag = 'Y' THEN
1127:

Line 1128: l_control_rec.book_flag := FND_API.G_TRUE;

1124:
1125: ELSIF l_order_status_flag = 'N' and
1126: l_book_order_flag = 'Y' THEN
1127:
1128: l_control_rec.book_flag := FND_API.G_TRUE;
1129:
1130: END IF;
1131:
1132: ELSIF (EstDtlTab(i).add_to_order_flag = 'N') or

Line 1140: l_control_rec.book_flag := FND_API.G_TRUE;

1136: --and (l_order_header_id = -999 ) --5649493
1137: THEN
1138:
1139: IF l_book_order_flag = 'Y' THEN
1140: l_control_rec.book_flag := FND_API.G_TRUE;
1141: ELSIF l_book_order_flag = 'N' THEN
1142: l_control_rec.book_flag := FND_API.G_FALSE;
1143: END IF;
1144: END IF;

Line 1142: l_control_rec.book_flag := FND_API.G_FALSE;

1138:
1139: IF l_book_order_flag = 'Y' THEN
1140: l_control_rec.book_flag := FND_API.G_TRUE;
1141: ELSIF l_book_order_flag = 'N' THEN
1142: l_control_rec.book_flag := FND_API.G_FALSE;
1143: END IF;
1144: END IF;
1145:
1146: -- dbms_output.put_line('Book_Flag' || l_control_rec.book_flag);

Line 1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1155: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1156: p_count => x_msg_count,
1157: p_data => x_msg_data);
1158:
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160:
1161: END IF;
1162:
1163: IF EstDtlTab(i).quantity_required is null

Line 1170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1166: FND_MSG_PUB.Add;
1167: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1168: p_count => x_msg_count,
1169: p_data => x_msg_data);
1170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1171: END IF;
1172:
1173: -- GET ORDER_TYPE AND LINE_TYPE
1174: BEGIN

Line 1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1189: FND_MSG_PUB.Add;
1190: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1191: p_count => x_msg_count,
1192: p_data => x_msg_data);
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END;
1195: --
1196: --
1197: -- dbms_output.put_line('After Order Type and Line Type');

Line 1219: l_header_rec.attribute1 := FND_API.G_MISS_CHAR;

1215:
1216: --
1217: -- Populate Flexfiled with G_MISS_CHAR so defaulting rules will work.
1218: -- Passing flexfield values as g_miss_char both for new orders/add to orders.
1219: l_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1220: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1221: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1222: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1223: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 1220: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;

1216: --
1217: -- Populate Flexfiled with G_MISS_CHAR so defaulting rules will work.
1218: -- Passing flexfield values as g_miss_char both for new orders/add to orders.
1219: l_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1220: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1221: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1222: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1223: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1224: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 1221: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;

1217: -- Populate Flexfiled with G_MISS_CHAR so defaulting rules will work.
1218: -- Passing flexfield values as g_miss_char both for new orders/add to orders.
1219: l_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1220: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1221: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1222: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1223: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1224: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1225: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 1222: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;

1218: -- Passing flexfield values as g_miss_char both for new orders/add to orders.
1219: l_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1220: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1221: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1222: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1223: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1224: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1225: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1226: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 1223: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;

1219: l_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1220: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1221: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1222: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1223: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1224: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1225: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1226: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1227: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 1224: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;

1220: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1221: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1222: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1223: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1224: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1225: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1226: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1227: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1228: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 1225: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;

1221: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1222: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1223: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1224: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1225: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1226: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1227: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1228: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1229: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 1226: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;

1222: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1223: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1224: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1225: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1226: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1227: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1228: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1229: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1230: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 1227: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;

1223: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1224: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1225: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1226: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1227: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1228: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1229: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1230: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1231: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 1228: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;

1224: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1225: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1226: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1227: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1228: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1229: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1230: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1231: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1232: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 1229: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;

1225: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1226: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1227: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1228: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1229: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1230: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1231: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1232: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;
1233: l_header_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 1230: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;

1226: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1227: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1228: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1229: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1230: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1231: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1232: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;
1233: l_header_rec.attribute15 := FND_API.G_MISS_CHAR;
1234:

Line 1231: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;

1227: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1228: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1229: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1230: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1231: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1232: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;
1233: l_header_rec.attribute15 := FND_API.G_MISS_CHAR;
1234:
1235: -- FIX Bug:3667208

Line 1232: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;

1228: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1229: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1230: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1231: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1232: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;
1233: l_header_rec.attribute15 := FND_API.G_MISS_CHAR;
1234:
1235: -- FIX Bug:3667208
1236: IF (EstDtlTab(i).add_to_order_flag = 'F') THEN

Line 1233: l_header_rec.attribute15 := FND_API.G_MISS_CHAR;

1229: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1230: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1231: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1232: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;
1233: l_header_rec.attribute15 := FND_API.G_MISS_CHAR;
1234:
1235: -- FIX Bug:3667208
1236: IF (EstDtlTab(i).add_to_order_flag = 'F') THEN
1237:

Line 1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1367: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1368: p_count => x_msg_count,
1369: p_data => x_msg_data);
1370:
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1372:
1373: END IF;
1374: -- This value needs to be passed for add_to_order/update_order as well.
1375: -- Fix for the bug 2123535

Line 1384: /* l_header_rec.attribute1 := FND_API.G_MISS_CHAR;

1380:
1381: ELSE /* create a new order */
1382: -- Populate Flexfiled with G_MISS_CHAR so defaulting rules will work
1383: -- Moved to before add_to_order/new_order.
1384: /* l_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1385: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1386: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1387: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1388: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 1385: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;

1381: ELSE /* create a new order */
1382: -- Populate Flexfiled with G_MISS_CHAR so defaulting rules will work
1383: -- Moved to before add_to_order/new_order.
1384: /* l_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1385: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1386: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1387: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1388: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1389: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 1386: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;

1382: -- Populate Flexfiled with G_MISS_CHAR so defaulting rules will work
1383: -- Moved to before add_to_order/new_order.
1384: /* l_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1385: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1386: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1387: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1388: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1389: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1390: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 1387: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;

1383: -- Moved to before add_to_order/new_order.
1384: /* l_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1385: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1386: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1387: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1388: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1389: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1390: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1391: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 1388: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;

1384: /* l_header_rec.attribute1 := FND_API.G_MISS_CHAR;
1385: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1386: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1387: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1388: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1389: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1390: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1391: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1392: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 1389: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;

1385: l_header_rec.attribute2 := FND_API.G_MISS_CHAR;
1386: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1387: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1388: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1389: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1390: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1391: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1392: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1393: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 1390: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;

1386: l_header_rec.attribute3 := FND_API.G_MISS_CHAR;
1387: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1388: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1389: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1390: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1391: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1392: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1393: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1394: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 1391: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;

1387: l_header_rec.attribute4 := FND_API.G_MISS_CHAR;
1388: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1389: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1390: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1391: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1392: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1393: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1394: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1395: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 1392: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;

1388: l_header_rec.attribute5 := FND_API.G_MISS_CHAR;
1389: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1390: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1391: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1392: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1393: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1394: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1395: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1396: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 1393: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;

1389: l_header_rec.attribute6 := FND_API.G_MISS_CHAR;
1390: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1391: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1392: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1393: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1394: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1395: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1396: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1397: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 1394: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;

1390: l_header_rec.attribute7 := FND_API.G_MISS_CHAR;
1391: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1392: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1393: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1394: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1395: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1396: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1397: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;
1398: l_header_rec.attribute15 := FND_API.G_MISS_CHAR; */

Line 1395: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;

1391: l_header_rec.attribute8 := FND_API.G_MISS_CHAR;
1392: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1393: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1394: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1395: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1396: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1397: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;
1398: l_header_rec.attribute15 := FND_API.G_MISS_CHAR; */
1399: --

Line 1396: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;

1392: l_header_rec.attribute9 := FND_API.G_MISS_CHAR;
1393: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1394: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1395: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1396: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1397: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;
1398: l_header_rec.attribute15 := FND_API.G_MISS_CHAR; */
1399: --
1400: l_header_rec.order_type_id := l_order_type_id;

Line 1397: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;

1393: l_header_rec.attribute10 := FND_API.G_MISS_CHAR;
1394: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1395: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1396: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1397: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;
1398: l_header_rec.attribute15 := FND_API.G_MISS_CHAR; */
1399: --
1400: l_header_rec.order_type_id := l_order_type_id;
1401: l_header_rec.org_id := EstDtlTab(i).org_id;

Line 1398: l_header_rec.attribute15 := FND_API.G_MISS_CHAR; */

1394: l_header_rec.attribute11 := FND_API.G_MISS_CHAR;
1395: l_header_rec.attribute12 := FND_API.G_MISS_CHAR;
1396: l_header_rec.attribute13 := FND_API.G_MISS_CHAR;
1397: l_header_rec.attribute14 := FND_API.G_MISS_CHAR;
1398: l_header_rec.attribute15 := FND_API.G_MISS_CHAR; */
1399: --
1400: l_header_rec.order_type_id := l_order_type_id;
1401: l_header_rec.org_id := EstDtlTab(i).org_id;
1402: l_header_rec.quote_source_code := 'Service Billing'; -- Lookup value 7

Line 1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1557: FND_MSG_PUB.Add;
1558: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1559: p_count => x_msg_count,
1560: p_data => x_msg_data);
1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1562:
1563: ELSE
1564: l_inv_item_id := EstDtlTab(i).rollup_item_id;
1565: END IF;

Line 1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1695: FND_MSG_PUB.Add;
1696: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1697: p_count => x_msg_count,
1698: p_data => x_msg_data);
1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700: End If;
1701:
1702: End;
1703:

Line 1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1709: FND_MSG_PUB.Add;
1710: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1711: p_count => x_msg_count,
1712: p_data => x_msg_data);
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714:
1715: End If;
1716:
1717: l_before_warranty_cost := (nvl(EstDtlTab(i).selling_price, 0) * EstDtlTab(i).quantity_required );

Line 1726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1722: FND_MSG_PUB.Add;
1723: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1724: p_count => x_msg_count,
1725: p_data => x_msg_data);
1726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1727: END IF;
1728:
1729: IF l_before_warranty_cost = 0
1730: Then

Line 1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1736: FND_MSG_PUB.Add;
1737: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1738: p_count => x_msg_count,
1739: p_data => x_msg_data);
1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: End If;
1742: Elsif l_before_warranty_cost > 0
1743: Then
1744: If l_arith_operator = 'AMT' Then

Line 1816: l_lot_serial_tbl(1).lot_number := FND_API.G_MISS_CHAR;

1812: IF (EstDtlTab(i).comms_nl_trackable_flag = 'N' and
1813: EstDtlTab(i).line_category_code = 'RETURN' and
1814: EstDtlTab(i).return_serial_number IS NOT NULL) THEN
1815:
1816: l_lot_serial_tbl(1).lot_number := FND_API.G_MISS_CHAR;
1817: l_lot_serial_tbl(1).lot_serial_id := FND_API.G_MISS_NUM;
1818: l_lot_serial_tbl(1).quantity := abs(EstDtlTab(i).quantity_required);
1819: l_lot_serial_tbl(1).from_serial_number := EstDtlTab(i).return_serial_number;
1820: l_lot_serial_tbl(1).to_serial_number := EstDtlTab(i).return_serial_number;

Line 1817: l_lot_serial_tbl(1).lot_serial_id := FND_API.G_MISS_NUM;

1813: EstDtlTab(i).line_category_code = 'RETURN' and
1814: EstDtlTab(i).return_serial_number IS NOT NULL) THEN
1815:
1816: l_lot_serial_tbl(1).lot_number := FND_API.G_MISS_CHAR;
1817: l_lot_serial_tbl(1).lot_serial_id := FND_API.G_MISS_NUM;
1818: l_lot_serial_tbl(1).quantity := abs(EstDtlTab(i).quantity_required);
1819: l_lot_serial_tbl(1).from_serial_number := EstDtlTab(i).return_serial_number;
1820: l_lot_serial_tbl(1).to_serial_number := EstDtlTab(i).return_serial_number;
1821: l_lot_serial_tbl(1).operation := 'CREATE';

Line 1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1867: FND_MSG_PUB.Add;
1868: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1869: p_count => x_msg_count,
1870: p_data => x_msg_data);
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872:
1873: WHEN NO_DATA_FOUND THEN
1874: l_update_ib_flag := 'N';
1875: /* Commenting out this exception as part of IB changes */

Line 1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

1877: FND_MSG_PUB.Add;
1878: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1879: p_count => x_msg_count,
1880: p_data => x_msg_data);
1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
1882: END;
1883:
1884: -- Populate installation details if there is instance information and
1885: -- update_ib_flag is 'Y',but do not raise any error message.

Line 1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

1899: -- Serial_number is available only if the instance is serialized
1900: /* WHEN NO_DATA_FOUND THEN
1901: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');
1902: FND_MSG_PUB.Add;
1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
1904: WHEN OTHERS THEN
1905: RAISE;
1906: END;
1907: IF l_ib_serial_number is not null THEN

Line 1908: l_lot_serial_tbl(1).lot_number := FND_API.G_MISS_CHAR;

1904: WHEN OTHERS THEN
1905: RAISE;
1906: END;
1907: IF l_ib_serial_number is not null THEN
1908: l_lot_serial_tbl(1).lot_number := FND_API.G_MISS_CHAR;
1909: l_lot_serial_tbl(1).lot_serial_id := FND_API.G_MISS_NUM;
1910: l_lot_serial_tbl(1).quantity := abs(EstDtlTab(i).quantity_required);
1911: l_lot_serial_tbl(1).from_serial_number := l_ib_serial_number;
1912: l_lot_serial_tbl(1).to_serial_number := l_ib_serial_number;

Line 1909: l_lot_serial_tbl(1).lot_serial_id := FND_API.G_MISS_NUM;

1905: RAISE;
1906: END;
1907: IF l_ib_serial_number is not null THEN
1908: l_lot_serial_tbl(1).lot_number := FND_API.G_MISS_CHAR;
1909: l_lot_serial_tbl(1).lot_serial_id := FND_API.G_MISS_NUM;
1910: l_lot_serial_tbl(1).quantity := abs(EstDtlTab(i).quantity_required);
1911: l_lot_serial_tbl(1).from_serial_number := l_ib_serial_number;
1912: l_lot_serial_tbl(1).to_serial_number := l_ib_serial_number;
1913: l_lot_serial_tbl(1).operation := 'CREATE';

Line 1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

1915: END IF;
1916: /* ELSE
1917: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');
1918: FND_MSG_PUB.Add;
1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
1920: END IF;
1921: END IF;
1922:
1923:

Line 1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1930: EstDtlTab(i).customer_product_id IS NULL THEN
1931:
1932: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');
1933: FND_MSG_PUB.Add;
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935: END IF;
1936:
1937: --
1938: -- Clear IB structures

Line 1976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1972: FND_MSG_PUB.Add;
1973: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1974: p_count => x_msg_count,
1975: p_data => x_msg_data);
1976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1977: -- null;
1978:
1979: END IF;
1980:

Line 1984: csi_txn_line_detail_tbl(1).inventory_revision := FND_API.G_MISS_CHAR;

1980:
1981: IF EstDtlTab(i).Item_revision is not null THEN
1982: csi_txn_line_detail_tbl(1).inventory_revision := EstDtlTab(i).Item_revision;
1983: ELSE
1984: csi_txn_line_detail_tbl(1).inventory_revision := FND_API.G_MISS_CHAR;
1985: END IF;
1986:
1987: csi_txn_line_detail_tbl(1).inventory_item_id := EstDtlTab(i).Inventory_Item_id;
1988: csi_txn_line_detail_tbl(1).inv_organization_id := CS_STD.Get_Item_Valdn_Orgzn_ID;

Line 1995: csi_txn_line_detail_tbl(1).return_by_date := FND_API.G_MISS_DATE;

1991:
1992: IF EstDtlTab(i).installed_cp_return_by_date is not null THEN
1993: csi_txn_line_detail_tbl(1).return_by_date := EstDtlTab(i).installed_cp_return_by_date;
1994: ELSE
1995: csi_txn_line_detail_tbl(1).return_by_date := FND_API.G_MISS_DATE;
1996: END IF;
1997:
1998: ELSE -- Shipment Line
1999: csi_txn_line_detail_tbl(1).sub_type_id := l_sub_type_id;

Line 2002: csi_txn_line_detail_tbl(1).instance_id := FND_API.G_MISS_NUM;

1998: ELSE -- Shipment Line
1999: csi_txn_line_detail_tbl(1).sub_type_id := l_sub_type_id;
2000: csi_txn_line_detail_tbl(1).source_transaction_flag := 'Y';
2001:
2002: csi_txn_line_detail_tbl(1).instance_id := FND_API.G_MISS_NUM;
2003: csi_txn_line_detail_tbl(1).instance_exists_flag := 'N';
2004:
2005: IF EstDtlTab(i).Item_revision is not null THEN
2006: csi_txn_line_detail_tbl(1).inventory_revision := EstDtlTab(i).Item_revision;

Line 2008: csi_txn_line_detail_tbl(1).inventory_revision := FND_API.G_MISS_CHAR;

2004:
2005: IF EstDtlTab(i).Item_revision is not null THEN
2006: csi_txn_line_detail_tbl(1).inventory_revision := EstDtlTab(i).Item_revision;
2007: ELSE
2008: csi_txn_line_detail_tbl(1).inventory_revision := FND_API.G_MISS_CHAR;
2009: END IF;
2010:
2011: csi_txn_line_detail_tbl(1).inventory_item_id := EstDtlTab(i).Inventory_Item_id;
2012: csi_txn_line_detail_tbl(1).inv_organization_id := CS_STD.Get_Item_Valdn_Orgzn_ID;

Line 2022: csi_txn_line_detail_tbl(1).return_by_date := FND_API.G_MISS_DATE;

2018: IF l_src_return_reqd_flag = 'Y' THEN
2019: IF EstDtlTab(i).installed_cp_return_by_date is not null THEN
2020: csi_txn_line_detail_tbl(1).return_by_date := EstDtlTab(i).installed_cp_return_by_date;
2021: ELSE
2022: csi_txn_line_detail_tbl(1).return_by_date := FND_API.G_MISS_DATE;
2023: END IF;
2024: END IF;
2025: */
2026: -- Commented the above and uncommented the below IF block for Bug# 5136853.

Line 2030: csi_txn_line_detail_tbl(1).return_by_date := FND_API.G_MISS_DATE;

2026: -- Commented the above and uncommented the below IF block for Bug# 5136853.
2027: IF EstDtlTab(i).new_cp_return_by_date is not null THEN
2028: csi_txn_line_detail_tbl(1).return_by_date := EstDtlTab(i).new_cp_return_by_date;
2029: ELSE
2030: csi_txn_line_detail_tbl(1).return_by_date := FND_API.G_MISS_DATE;
2031: END IF;
2032:
2033: -- Referenced IB (non-source)
2034: IF l_non_src_reference_reqd = 'Y'

Line 2054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

2050: FND_MSG_PUB.Add;
2051: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2052: p_count => x_msg_count,
2053: p_data => x_msg_data);
2054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
2055: END IF;
2056:
2057: /* BUG 4287842 for a loaner shipment, installation details should display the ITEM for which the instance_number was selected. Currently it displays the Item irrespective of the reference number*/
2058:

Line 2072: csi_txn_line_detail_tbl(2).inventory_revision := FND_API.G_MISS_CHAR;

2068: /*
2069: IF EstDtlTab(i).Item_revision is not null THEN
2070: csi_txn_line_detail_tbl(2).inventory_revision := EstDtlTab(i).Item_revision;
2071: ELSE
2072: csi_txn_line_detail_tbl(2).inventory_revision := FND_API.G_MISS_CHAR;
2073: END IF;
2074: */
2075:
2076: -- Uncommented the below IF block for Bug# 5136853.

Line 2080: csi_txn_line_detail_tbl(2).return_by_date := FND_API.G_MISS_DATE;

2076: -- Uncommented the below IF block for Bug# 5136853.
2077: IF EstDtlTab(i).installed_cp_return_by_date is not null THEN
2078: csi_txn_line_detail_tbl(2).return_by_date := EstDtlTab(i).installed_cp_return_by_date;
2079: ELSE
2080: csi_txn_line_detail_tbl(2).return_by_date := FND_API.G_MISS_DATE;
2081: END IF;
2082:
2083:
2084: -- Create relationship between two txn line detail records

Line 2115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2111: FND_MSG_PUB.Add;
2112: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2113: p_count => x_msg_count,
2114: p_data => x_msg_data);
2115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2116: END;
2117:
2118: BEGIN
2119: SELECT instance_party_id

Line 2135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2131: FND_MSG_PUB.Add;
2132: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2133: p_count => x_msg_count,
2134: p_data => x_msg_data);
2135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2136: END;
2137:
2138: csi_txn_party_detail_tbl(1).instance_party_id := l_instance_party_id;
2139: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

Line 2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2147: FND_MSG_PUB.Add;
2148: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2149: p_count => x_msg_count,
2150: p_data => x_msg_data);
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: END IF; -- IF l_src_change_owner_to_code = 'I'
2153:
2154: --taklam
2155: ---NEW CODE

Line 2174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2170: FND_MSG_PUB.Add;
2171: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2172: p_count => x_msg_count,
2173: p_data => x_msg_data);
2174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2175: END;
2176:
2177: BEGIN
2178: IF EstDtlTab(i).Customer_Product_Id is not NULL THEN

Line 2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2192: FND_MSG_PUB.Add;
2193: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2194: p_count => x_msg_count,
2195: p_data => x_msg_data);
2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2197: END;
2198:
2199: csi_txn_party_detail_tbl(1).instance_party_id := l_instance_party_id;
2200: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

Line 2591: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2587:
2588: -- dbms_output.put_line('In the validate_acct_site_call');
2589: -- dbms_output.put_line('Return_Status' || x_return_status);
2590:
2591: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2592: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2593: p_count => x_msg_count,
2594: p_data => x_msg_data);
2595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2591: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2592: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2593: p_count => x_msg_count,
2594: p_data => x_msg_data);
2595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2596: END IF;
2597:
2598: -- Validate the bill to customer account site and account site use are correct.
2599: validate_acct_site_uses(

Line 2611: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2607:
2608: -- dbms_output.put_line('In the validate_acct_site_call2');
2609: -- dbms_output.put_line('Return_Status2' || x_return_status);
2610:
2611: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2612: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2613: p_count => x_msg_count,
2614: p_data => x_msg_data);
2615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2611: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2612: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2613: p_count => x_msg_count,
2614: p_data => x_msg_data);
2615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2616: END IF;
2617: --
2618:
2619: -- r12 code start

Line 2627: raise FND_API.G_EXC_ERROR ;

2623: FND_MSG_PUB.initialize;
2624: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_MISMATCH') ;
2625: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full) ;
2626: FND_MSG_PUB.Add ;
2627: raise FND_API.G_EXC_ERROR ;
2628: END IF;
2629:
2630: mo_global.set_policy_context('S',l_org_id);
2631:

Line 2703: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2699:
2700: END IF; -- Add_To_Order
2701:
2702:
2703: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2704: -- moved this to elsif below.
2705: -- X_ORDER_HEADER_ID := X_ORDER_HEADER_REC.ORDER_HEADER_ID;
2706:
2707: IF X_ORDER_HEADER_REC.ORDER_HEADER_ID IS NULL THEN

Line 2714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2710: FND_MSG_PUB.Add;
2711: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2712: p_count => x_msg_count,
2713: p_data => x_msg_data);
2714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2715:
2716: -- Need to verify if we need to trap this error message
2717: --
2718:

Line 2745: xi_return_status := FND_API.G_RET_STS_SUCCESS;

2741: END LOOP; */
2742:
2743: -- Initialize xi_return_status.
2744:
2745: xi_return_status := FND_API.G_RET_STS_SUCCESS;
2746:
2747: /* This will call the wrapper API to raise the Business Event oracle.apps.cs.chg.Charges.submitted
2748: and their subscriptions.
2749: All the custom code exists in the subscriptions/rule functions

Line 2767: p_init_msg_list => FND_API.G_FALSE,

2763: wf_user_id := FND_GLOBAL.USER_ID;
2764:
2765: CS_CHG_WF_EVENT_PKG.RAISE_SUBMITCHARGES_EVENT(
2766: p_api_version => 1.0,
2767: p_init_msg_list => FND_API.G_FALSE,
2768: p_commit => FND_API.G_FALSE,
2769: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2770: p_event_code => 'SUBMIT_CHARGES',
2771: p_estimate_detail_id => EstDtlTab(i).Estimate_Detail_Id,

Line 2768: p_commit => FND_API.G_FALSE,

2764:
2765: CS_CHG_WF_EVENT_PKG.RAISE_SUBMITCHARGES_EVENT(
2766: p_api_version => 1.0,
2767: p_init_msg_list => FND_API.G_FALSE,
2768: p_commit => FND_API.G_FALSE,
2769: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2770: p_event_code => 'SUBMIT_CHARGES',
2771: p_estimate_detail_id => EstDtlTab(i).Estimate_Detail_Id,
2772: p_USER_ID => wf_user_id,

Line 2769: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2765: CS_CHG_WF_EVENT_PKG.RAISE_SUBMITCHARGES_EVENT(
2766: p_api_version => 1.0,
2767: p_init_msg_list => FND_API.G_FALSE,
2768: p_commit => FND_API.G_FALSE,
2769: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2770: p_event_code => 'SUBMIT_CHARGES',
2771: p_estimate_detail_id => EstDtlTab(i).Estimate_Detail_Id,
2772: p_USER_ID => wf_user_id,
2773: p_RESP_ID => wf_resp_id,

Line 2784: if ( lx_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2780: x_return_status => lx_return_status,
2781: x_msg_count => lx_msg_count,
2782: x_msg_data => lx_msg_data );
2783:
2784: if ( lx_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2785: -- do nothing in this API. The BES wrapper API will have to trap this
2786: -- situation.
2787: null;
2788: end if;

Line 2844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2840: EXCEPTION
2841: WHEN OTHERS THEN
2842: FND_MESSAGE.Set_Name('CS','CS_CHG_INTERNAL_PARTY_NOT_DEF');
2843: FND_MSG_PUB.Add;
2844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2845: END;
2846:
2847: SELECT instance_party_id
2848: INTO l_instance_party_id

Line 2869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2865: FND_MSG_PUB.Add;
2866: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2867: p_count => x_msg_count,
2868: p_data => x_msg_data);
2869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2870:
2871: END IF; -- IF l_src_change_owner_to_code = 'I'
2872: ELSE
2873: csi_txn_party_detail_tbl.delete;

Line 2906: p_commit => fnd_api.g_false,

2902: and (EstDtlTab(i).customer_product_id IS NOT NULL) THEN
2903: -- Now call the create transaction Details API.
2904: csi_t_txn_details_grp.create_transaction_dtls(
2905: p_api_version => 1.0,
2906: p_commit => fnd_api.g_false,
2907: p_init_msg_list => fnd_api.g_false,
2908: p_validation_level => fnd_api.g_valid_level_full,
2909: px_txn_line_rec => csi_txn_line_rec ,
2910: px_txn_line_detail_tbl => csi_txn_line_detail_tbl,

Line 2907: p_init_msg_list => fnd_api.g_false,

2903: -- Now call the create transaction Details API.
2904: csi_t_txn_details_grp.create_transaction_dtls(
2905: p_api_version => 1.0,
2906: p_commit => fnd_api.g_false,
2907: p_init_msg_list => fnd_api.g_false,
2908: p_validation_level => fnd_api.g_valid_level_full,
2909: px_txn_line_rec => csi_txn_line_rec ,
2910: px_txn_line_detail_tbl => csi_txn_line_detail_tbl,
2911: px_txn_party_detail_tbl => csi_txn_party_detail_tbl ,

Line 2908: p_validation_level => fnd_api.g_valid_level_full,

2904: csi_t_txn_details_grp.create_transaction_dtls(
2905: p_api_version => 1.0,
2906: p_commit => fnd_api.g_false,
2907: p_init_msg_list => fnd_api.g_false,
2908: p_validation_level => fnd_api.g_valid_level_full,
2909: px_txn_line_rec => csi_txn_line_rec ,
2910: px_txn_line_detail_tbl => csi_txn_line_detail_tbl,
2911: px_txn_party_detail_tbl => csi_txn_party_detail_tbl ,
2912: px_txn_pty_acct_detail_tbl => csi_txn_pty_acct_detail_tbl,

Line 2925: p_commit => fnd_api.g_false,

2921: ELSIF EstDtlTab(i).line_category_code = 'ORDER' THEN
2922: -- Now call the create transaction Details API.
2923: csi_t_txn_details_grp.create_transaction_dtls(
2924: p_api_version => 1.0,
2925: p_commit => fnd_api.g_false,
2926: p_init_msg_list => fnd_api.g_false,
2927: p_validation_level => fnd_api.g_valid_level_full,
2928: px_txn_line_rec => csi_txn_line_rec ,
2929: px_txn_line_detail_tbl => csi_txn_line_detail_tbl,

Line 2926: p_init_msg_list => fnd_api.g_false,

2922: -- Now call the create transaction Details API.
2923: csi_t_txn_details_grp.create_transaction_dtls(
2924: p_api_version => 1.0,
2925: p_commit => fnd_api.g_false,
2926: p_init_msg_list => fnd_api.g_false,
2927: p_validation_level => fnd_api.g_valid_level_full,
2928: px_txn_line_rec => csi_txn_line_rec ,
2929: px_txn_line_detail_tbl => csi_txn_line_detail_tbl,
2930: px_txn_party_detail_tbl => csi_txn_party_detail_tbl ,

Line 2927: p_validation_level => fnd_api.g_valid_level_full,

2923: csi_t_txn_details_grp.create_transaction_dtls(
2924: p_api_version => 1.0,
2925: p_commit => fnd_api.g_false,
2926: p_init_msg_list => fnd_api.g_false,
2927: p_validation_level => fnd_api.g_valid_level_full,
2928: px_txn_line_rec => csi_txn_line_rec ,
2929: px_txn_line_detail_tbl => csi_txn_line_detail_tbl,
2930: px_txn_party_detail_tbl => csi_txn_party_detail_tbl ,
2931: px_txn_pty_acct_detail_tbl => csi_txn_pty_acct_detail_tbl,

Line 2944: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2940: END IF; -- fix bug:3800010
2941:
2942: END IF; -- comms_nl_trackable_flag
2943:
2944: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2945:
2946: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2947: p_count => x_msg_count,
2948: p_data => x_msg_data);

Line 2954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2950: -- dbms_output.put_line('message status' || x_return_status);
2951: -- dbms_output.put_line('message_data' || substr(x_msg_data,1,200));
2952: -- dbms_output.put_line('message_count' || x_msg_count);
2953:
2954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2955:
2956: END IF;
2957:
2958: -- FND_MESSAGE.Set_Encoded(xi_msg_data);

Line 2959: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2955:
2956: END IF;
2957:
2958: -- FND_MESSAGE.Set_Encoded(xi_msg_data);
2959: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2960:
2961:
2962: END IF; -- if billing flag = 'M'
2963:

Line 2988: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2984:
2985: END LOOP;
2986: --
2987: -- IF THE ORDER CREATION IS NOT SUCCESSFUL
2988: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2989:
2990: IF x_msg_count > 0 THEN
2991: -- Get next message
2992:

Line 3004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3000: p_data=>x_msg_data,
3001: p_msg_index_out=>l_dummy);
3002: end loop;
3003:
3004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3005:
3006: /* for k in 1..x_msg_count loop
3007: FND_MSG_PUB.get(p_encoded => 'F',
3008: p_data=>x_msg_data,

Line 3036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3032: FND_MSG_PUB.Add;
3033: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3034: p_count => x_msg_count,
3035: p_data => x_msg_data);
3036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3037:
3038: END IF;
3039:
3040: -- FND_MESSAGE.Set_Encoded(x_msg_data);

Line 3042: -- RAISE FND_API.G_EXC_ERROR;

3038: END IF;
3039:
3040: -- FND_MESSAGE.Set_Encoded(x_msg_data);
3041: -- FND_MSG_PUB.Add;
3042: -- RAISE FND_API.G_EXC_ERROR;
3043:
3044: END IF;
3045:
3046: END LOOP;

Line 3055: RAISE FND_API.G_EXC_ERROR;

3051: --FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_incident_id, TRUE);
3052: --FND_MESSAGE.SET_TOKEN('PARTY_ID', p_party_id, TRUE);
3053: --FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_account_id, TRUE);
3054: FND_MSG_PUB.Add;
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057:
3058: --
3059: -- End of API body

Line 3063: IF FND_API.To_Boolean( p_commit ) THEN

3059: -- End of API body
3060: --
3061:
3062: -- Standard check of p_commit.
3063: IF FND_API.To_Boolean( p_commit ) THEN
3064: COMMIT WORK;
3065: END IF;
3066:
3067: -- Standard call to get message count and if count is 1, get message info.

Line 3081: RAISE FND_API.G_EXC_ERROR;

3077: --7117301
3078: WHEN RESOURCE_BUSY THEN
3079: FND_MESSAGE.Set_Name('CS','CS_CH_SUBMIT_IN_PROCESS');
3080: FND_MSG_PUB.Add;
3081: RAISE FND_API.G_EXC_ERROR;
3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3083: --7117301
3084: WHEN FND_API.G_EXC_ERROR THEN
3085: ROLLBACK TO CS_Charge_Create_Order_PVT;

Line 3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3078: WHEN RESOURCE_BUSY THEN
3079: FND_MESSAGE.Set_Name('CS','CS_CH_SUBMIT_IN_PROCESS');
3080: FND_MSG_PUB.Add;
3081: RAISE FND_API.G_EXC_ERROR;
3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3083: --7117301
3084: WHEN FND_API.G_EXC_ERROR THEN
3085: ROLLBACK TO CS_Charge_Create_Order_PVT;
3086: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3084: WHEN FND_API.G_EXC_ERROR THEN

3080: FND_MSG_PUB.Add;
3081: RAISE FND_API.G_EXC_ERROR;
3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3083: --7117301
3084: WHEN FND_API.G_EXC_ERROR THEN
3085: ROLLBACK TO CS_Charge_Create_Order_PVT;
3086: x_return_status := FND_API.G_RET_STS_ERROR;
3087: FND_MSG_PUB.Count_And_Get
3088: ( p_count => x_msg_count,

Line 3086: x_return_status := FND_API.G_RET_STS_ERROR;

3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3083: --7117301
3084: WHEN FND_API.G_EXC_ERROR THEN
3085: ROLLBACK TO CS_Charge_Create_Order_PVT;
3086: x_return_status := FND_API.G_RET_STS_ERROR;
3087: FND_MSG_PUB.Count_And_Get
3088: ( p_count => x_msg_count,
3089: p_data => x_msg_data
3090: );

Line 3095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3091:
3092: --
3093: -- This exception is for Charge Line Level
3094:
3095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3096:
3097: -- updating charges schema with errors for 11.5.10
3098: --
3099: -- dbms_output.put_line('Charge_Line_Id before calling update_errors' || EstDtlTab(i).estimate_detail_id);

Line 3110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3106: p_submit_from_system => p_submit_from_system);
3107:
3108: FND_MESSAGE.Set_Encoded(x_msg_data);
3109: --ROLLBACK TO CS_Charge_Create_Order_PVT; --7117301
3110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3111:
3112: WHEN OTHERS THEN
3113: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
3114: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');

Line 3145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3141: FND_MESSAGE.Set_Encoded(x_msg_data);
3142:
3143:
3144: --ROLLBACK TO CS_Charge_Create_Order_PVT; --7117301
3145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3146:
3147: END Submit_Order;
3148:
3149: /***************************************************************************/