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.PON_OPEN_INTERFACE_PVT dependencies on PON_AUCTION_HEADERS_INTERFACE

Line 48: The values in pon_auction_headers_interface will be checked against the

44:
45:
46: /*
47: Here a map of columns and their possible values is created
48: The values in pon_auction_headers_interface will be checked against the
49: possible values given in this map.
50: */
51:
52: PROCEDURE populate_column_test_table(

Line 180: columns in pon_auction_headers_interface table

176: END validate_value_column_pair;
177:
178: /*
179: This procedure checks whether non-null values are given to mandatory
180: columns in pon_auction_headers_interface table
181: */
182: PROCEDURE null_check(
183: p_batch_id IN NUMBER,
184: x_return_status IN OUT NOCOPY VARCHAR2

Line 202: OPEN curvar FOR 'select ' || cols(i) || ' from pon_auction_headers_interface where batch_id = ' || p_batch_id

198:
199: print_Log('null_check called. Loop to fetch all mandatory columns');
200:
201: FOR i IN 1..cols.Count LOOP
202: OPEN curvar FOR 'select ' || cols(i) || ' from pon_auction_headers_interface where batch_id = ' || p_batch_id
203: || ' and rownum < 2';
204: FETCH curvar INTO val;
205: CONTINUE WHEN curvar%NOTFOUND ;
206: IF (val IS NULL ) THEN

Line 219: 'PON_AUCTION_HEADERS_INTERFACE',

215: (
216: g_interface_type,
217: 'PON_FIELD_MUST_BE_ENTERED',
218: cols(i),
219: 'PON_AUCTION_HEADERS_INTERFACE',
220: p_batch_id
221: );
222:
223: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3771: l_batch_id pon_auctioN_headers_interface.batch_id%TYPE;

3767: p_error_message VARCHAR2(1000);
3768: l_auctioN_header_id pon_auction_headers_all.auctioN_header_id%TYPE;
3769: l_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;
3770: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;
3771: l_batch_id pon_auctioN_headers_interface.batch_id%TYPE;
3772:
3773: CURSOR group_negotiations_cur IS
3774: SELECT interface_header_id FROM pon_auction_Headers_interface
3775: WHERE interface_group_id = p_group_batch_id

Line 3774: SELECT interface_header_id FROM pon_auction_Headers_interface

3770: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;
3771: l_batch_id pon_auctioN_headers_interface.batch_id%TYPE;
3772:
3773: CURSOR group_negotiations_cur IS
3774: SELECT interface_header_id FROM pon_auction_Headers_interface
3775: WHERE interface_group_id = p_group_batch_id
3776: AND interface_header_id IS NOT NULL
3777: AND PROCESSING_STATUS_CODE = 'PENDING'
3778: AND Nvl(amendment_flag,'N') = 'N';

Line 3802: UPDATE pon_auction_Headers_interface

3798:
3799: FOR rec IN group_negotiations_cur LOOP
3800: SAVEPOINT NEG_CREATION;
3801: l_batch_id := rec.interface_header_id;
3802: UPDATE pon_auction_Headers_interface
3803: SET PROCESSING_STATUS_CODE = 'PROCESSING'
3804: WHERE interface_header_id = l_batch_id;
3805: DELETE FROM pon_interface_errors WHERE batch_id = l_batch_id;
3806:

Line 3824: UPDATE pon_auction_headers_interface

3820: neg_return_status := FND_API.G_RET_STS_ERROR;
3821: END;
3822: IF ( neg_return_status = 'S') THEN
3823: print_log('Negotiation with auction_header_id ' || l_auction_header_id || ' has been created for batch id ' || l_batch_id);
3824: UPDATE pon_auction_headers_interface
3825: SET PROCESSING_STATUS_CODE = 'PROCESSED'
3826: WHERE batch_id = l_batch_id;
3827: COMMIT;
3828: ELSE

Line 3848: UPDATE pon_auction_headers_interface

3844: DELETE FROM pon_auction_headers_ext_tl WHERE auction_header_id = l_auction_header_id;
3845: DELETE FROM pon_auction_item_prices_ext_b WHERE auction_header_id = l_auction_header_id;
3846: DELETE FROM pon_auction_item_prices_ext_tl WHERE auction_header_id = l_auction_header_id;
3847: END IF;
3848: UPDATE pon_auction_headers_interface
3849: SET PROCESSING_STATUS_CODE = 'FAILED'
3850: WHERE batch_id = l_batch_id;
3851: COMMIT;
3852: END IF;

Line 3895: update pon_auction_headers_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;

3891: print_log('pon_open_interface_pvt.create_negotiation begin');
3892: --x_return_status := FND_API.G_RET_STS_SUCCESS;
3893: neg_header_record_data := l_empty_header_rec;
3894:
3895: update pon_auction_headers_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
3896: update pon_item_prices_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3897: update PON_AUC_ATTRIBUTES_INTERFACE SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3898: update pon_attribute_scores_interface SET batch_id = p_batch_id, LINE_NUMBER = interface_line_id WHERE interface_header_id = p_batch_id;
3899: update pon_bid_parties_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;

Line 3914: FROM pon_auction_headers_Interface WHERE batch_id = p_batch_id;

3910:
3911: BEGIN
3912: SELECT 1
3913: INTO dummy1
3914: FROM pon_auction_headers_Interface WHERE batch_id = p_batch_id;
3915: EXCEPTION
3916: WHEN Too_Many_Rows THEN
3917: x_return_status := FND_API.G_RET_STS_ERROR;
3918: print_Log('Multiple rows found in pon_auction_headers_Interface table for the batch_id' || p_batch_id);

Line 3918: print_Log('Multiple rows found in pon_auction_headers_Interface table for the batch_id' || p_batch_id);

3914: FROM pon_auction_headers_Interface WHERE batch_id = p_batch_id;
3915: EXCEPTION
3916: WHEN Too_Many_Rows THEN
3917: x_return_status := FND_API.G_RET_STS_ERROR;
3918: print_Log('Multiple rows found in pon_auction_headers_Interface table for the batch_id' || p_batch_id);
3919: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_MUL_BATCHID');
3920: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
3921: FND_MSG_PUB.ADD;
3922: RAISE FND_API.G_EXC_ERROR;

Line 4938: l_po_style_name pon_auction_Headers_interface.po_style_name%TYPE;

4934: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
4935: l_org_Id pon_auction_Headers_all.org_id%TYPE;
4936: l_style_Id pon_auction_Headers_all.style_id%TYPE;
4937: l_po_style_Id pon_auction_Headers_all.po_style_id%TYPE;
4938: l_po_style_name pon_auction_Headers_interface.po_style_name%TYPE;
4939: l_contract_type pon_auction_headers_all.contract_type%TYPE;
4940: l_tpc_id fnd_user.user_id%TYPE;
4941: l_tpc_name fnd_user.user_Name%TYPE;
4942:

Line 4962: FROM pon_auction_headers_Interface WHERE batch_id = p_batch_id;

4958: l_cp_login_id := fnd_global.login_id;
4959:
4960: SELECT doctype_id, org_id, style_id, po_style_name, trading_partner_contact_name
4961: INTO l_doctype_id, l_org_id, l_style_id, l_po_style_name, l_tpc_name
4962: FROM pon_auction_headers_Interface WHERE batch_id = p_batch_id;
4963:
4964: SELECT DOCTYPE_ID INTO rfi_doctype_id FROM pon_auc_doctypes WHERE INTERNAL_NAME='REQUEST_FOR_INFORMATION';
4965:
4966: BEGIN

Line 5226: print_Log('process_negotiation_header: Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );

5222: x_return_status
5223: );
5224:
5225: IF( x_return_status = 'E') THEN
5226: print_Log('process_negotiation_header: Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );
5227: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_VAL_ERR');
5228: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5229: FND_MSG_PUB.ADD;
5230: RETURN;

Line 5266: print_Log('Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );

5262: x_return_status:=FND_API.G_RET_STS_SUCCESS;
5263: END;
5264:
5265: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN
5266: print_Log('Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );
5267: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_VAL_ERR');
5268: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5269: FND_MSG_PUB.ADD;
5270: RETURN;

Line 5397: -- Call to check if all mandatory columns in pon_auction_headers_interface table are given non-null values

5393: l_cp_user_id := fnd_global.user_id;
5394: l_cp_login_id := fnd_global.login_id;
5395:
5396: IF( p_is_amendment <> 'Y' ) THEN
5397: -- Call to check if all mandatory columns in pon_auction_headers_interface table are given non-null values
5398: null_check(
5399: p_batch_id,
5400: null_check_status
5401: );

Line 5403: print_log('Some mandatory fields in pon_auction_headers_interface table are having null values. Please check '

5399: p_batch_id,
5400: null_check_status
5401: );
5402: IF( null_check_status = FND_API.G_RET_STS_ERROR) THEN
5403: print_log('Some mandatory fields in pon_auction_headers_interface table are having null values. Please check '
5404: || ' pon_interface_errors table for more details');
5405: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_NULL_VALUES');
5406: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5407: FND_MSG_PUB.ADD;

Line 5427: -- Loop to check if the values given in pon_auction_headers_interface table are valid values

5423:
5424: print_Log('validate_header: populate_column_test_table completed' );
5425:
5426:
5427: -- Loop to check if the values given in pon_auction_headers_interface table are valid values
5428: FOR i IN 1..header_cols.Count LOOP
5429: BEGIN
5430:
5431: validate_col := header_cols(i);

Line 5432: validate_sql := 'select ' || validate_col || ' from pon_auction_headers_interface '

5428: FOR i IN 1..header_cols.Count LOOP
5429: BEGIN
5430:
5431: validate_col := header_cols(i);
5432: validate_sql := 'select ' || validate_col || ' from pon_auction_headers_interface '
5433: || ' where batch_id = ' || p_batch_id;
5434: EXECUTE IMMEDIATE validate_sql INTO validate_val;
5435:
5436: /*

Line 5445: print_log('Invalid value in pon_auction_headers_interface ' || validate_col || ' ' || validate_val);

5441: CONTINUE WHEN validate_val IS NULL;
5442: validate_value_column_pair(validate_col,validate_val,validate_res);
5443:
5444: IF(validate_res = 'N') THEN
5445: print_log('Invalid value in pon_auction_headers_interface ' || validate_col || ' ' || validate_val);
5446: invalid_val_exist_flag := 'Y';
5447: INSERT INTO PON_INTERFACE_ERRORS
5448: (
5449: INTERFACE_TYPE ,

Line 5480: print_log('Some fields in pon_auction_headers_interface table are having invalid values. '

5476: END;
5477: END LOOP;
5478:
5479: IF (invalid_val_exist_flag = 'Y' ) THEN
5480: print_log('Some fields in pon_auction_headers_interface table are having invalid values. '
5481: || 'Please check pon_interface_errors table for more details');
5482: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_INV_VALUES');
5483: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5484: FND_MSG_PUB.ADD;

Line 6317: FROM fnd_user usr,pon_auction_headers_interface pahi

6313: END IF;
6314:
6315: SELECT person_party_id,user_name
6316: INTO neg_header_record_data.trading_partner_contact_id,neg_header_record_data.trading_partner_contact_name
6317: FROM fnd_user usr,pon_auction_headers_interface pahi
6318: WHERE batch_id = p_batch_id
6319: AND usr.user_name = pahi.trading_partner_contact_name
6320: AND Nvl(usr.end_date,SYSDATE + 1) > SYSDATE ;
6321:

Line 6601: FROM pon_auction_headers_interface

6597: ,neg_header_record_data.CD_GENERATED_DATE
6598: ,neg_header_record_data.CD_GENERATED_FLAG
6599: ,neg_header_record_data.AMENDUPDATED_AFTERCDGENERATED
6600:
6601: FROM pon_auction_headers_interface
6602: WHERE batch_id = p_batch_id;
6603:
6604: SELECT internal_name, transaction_type
6605: INTO l_document_type, neg_header_record_data.auction_type

Line 6922: print_Log('Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );

6918: print_Log('Completing init_rule_based_header_data procedure ');
6919:
6920: EXCEPTION
6921: WHEN OTHERS THEN
6922: print_Log('Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );
6923: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_INIT_ERR');
6924: FND_MSG_PUB.ADD;
6925: RAISE FND_API.G_EXC_ERROR;
6926:

Line 6995: l_batch_id pon_auctioN_headers_interface.batch_id%TYPE;

6991: p_error_code VARCHAR2(1);
6992: p_error_message VARCHAR2(1000);
6993: l_auctioN_header_id pon_auction_headers_all.auctioN_header_id%TYPE;
6994: l_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;
6995: l_batch_id pon_auctioN_headers_interface.batch_id%TYPE;
6996: amend_return_status VARCHAR2(1) ;
6997:
6998: CURSOR group_amendments_cur IS
6999: SELECT interface_header_id FROM pon_auction_Headers_interface

Line 6999: SELECT interface_header_id FROM pon_auction_Headers_interface

6995: l_batch_id pon_auctioN_headers_interface.batch_id%TYPE;
6996: amend_return_status VARCHAR2(1) ;
6997:
6998: CURSOR group_amendments_cur IS
6999: SELECT interface_header_id FROM pon_auction_Headers_interface
7000: WHERE interface_group_id = p_group_batch_id
7001: AND PROCESSING_STATUS_CODE = 'PENDING'
7002: AND amendment_flag = 'Y';
7003:

Line 7040: UPDATE pon_auction_headers_interface

7036: x_return_status := 'E';
7037: END;
7038: IF ( amend_return_status = 'S') THEN
7039: print_log('Amendment with auction_header_id ' || l_auction_header_id || ' has been created for batch id ' || l_batch_id);
7040: UPDATE pon_auction_headers_interface
7041: SET PROCESSING_STATUS_CODE = 'SUCCESS'
7042: WHERE batch_id = l_batch_id;
7043: COMMIT;
7044: ELSE

Line 7064: UPDATE pon_auction_headers_interface

7060: DELETE FROM pon_auction_headers_ext_tl WHERE auction_header_id = l_auction_header_id;
7061: DELETE FROM pon_auction_item_prices_ext_b WHERE auction_header_id = l_auction_header_id;
7062: DELETE FROM pon_auction_item_prices_ext_tl WHERE auction_header_id = l_auction_header_id;
7063: END IF;
7064: UPDATE pon_auction_headers_interface
7065: SET PROCESSING_STATUS_CODE = 'FAILED'
7066: WHERE batch_id = l_batch_id;
7067: COMMIT;
7068: END IF;

Line 7101: l_auctioN_header_id pon_auction_headers_interface.auctioN_header_id%TYPE;

7097: P_ERROR_MESSAGE VARCHAR2(50);
7098: o_auction_header_id NUMBER;
7099: x_document_number VARCHAR2(50);
7100: x_request_id VARCHAR2(50);
7101: l_auctioN_header_id pon_auction_headers_interface.auctioN_header_id%TYPE;
7102: l_style_id pon_auction_headers_interface.style_id%TYPE;
7103: l_award_approval pon_auction_headers_interface.award_approval_flag%TYPE;
7104: l_retain_clause pon_auction_headers_interface.retain_clause_flag%TYPE;
7105: l_update_clause pon_auction_headers_interface.update_clause_flag%TYPE;

Line 7102: l_style_id pon_auction_headers_interface.style_id%TYPE;

7098: o_auction_header_id NUMBER;
7099: x_document_number VARCHAR2(50);
7100: x_request_id VARCHAR2(50);
7101: l_auctioN_header_id pon_auction_headers_interface.auctioN_header_id%TYPE;
7102: l_style_id pon_auction_headers_interface.style_id%TYPE;
7103: l_award_approval pon_auction_headers_interface.award_approval_flag%TYPE;
7104: l_retain_clause pon_auction_headers_interface.retain_clause_flag%TYPE;
7105: l_update_clause pon_auction_headers_interface.update_clause_flag%TYPE;
7106: l_retain_attachments pon_auction_headers_interface.retain_attachments_flag%TYPE;

Line 7103: l_award_approval pon_auction_headers_interface.award_approval_flag%TYPE;

7099: x_document_number VARCHAR2(50);
7100: x_request_id VARCHAR2(50);
7101: l_auctioN_header_id pon_auction_headers_interface.auctioN_header_id%TYPE;
7102: l_style_id pon_auction_headers_interface.style_id%TYPE;
7103: l_award_approval pon_auction_headers_interface.award_approval_flag%TYPE;
7104: l_retain_clause pon_auction_headers_interface.retain_clause_flag%TYPE;
7105: l_update_clause pon_auction_headers_interface.update_clause_flag%TYPE;
7106: l_retain_attachments pon_auction_headers_interface.retain_attachments_flag%TYPE;
7107: l_src_auction_header_id pon_auction_headers_interface.auction_header_id%TYPE;

Line 7104: l_retain_clause pon_auction_headers_interface.retain_clause_flag%TYPE;

7100: x_request_id VARCHAR2(50);
7101: l_auctioN_header_id pon_auction_headers_interface.auctioN_header_id%TYPE;
7102: l_style_id pon_auction_headers_interface.style_id%TYPE;
7103: l_award_approval pon_auction_headers_interface.award_approval_flag%TYPE;
7104: l_retain_clause pon_auction_headers_interface.retain_clause_flag%TYPE;
7105: l_update_clause pon_auction_headers_interface.update_clause_flag%TYPE;
7106: l_retain_attachments pon_auction_headers_interface.retain_attachments_flag%TYPE;
7107: l_src_auction_header_id pon_auction_headers_interface.auction_header_id%TYPE;
7108: l_uda_template_id NUMBER;

Line 7105: l_update_clause pon_auction_headers_interface.update_clause_flag%TYPE;

7101: l_auctioN_header_id pon_auction_headers_interface.auctioN_header_id%TYPE;
7102: l_style_id pon_auction_headers_interface.style_id%TYPE;
7103: l_award_approval pon_auction_headers_interface.award_approval_flag%TYPE;
7104: l_retain_clause pon_auction_headers_interface.retain_clause_flag%TYPE;
7105: l_update_clause pon_auction_headers_interface.update_clause_flag%TYPE;
7106: l_retain_attachments pon_auction_headers_interface.retain_attachments_flag%TYPE;
7107: l_src_auction_header_id pon_auction_headers_interface.auction_header_id%TYPE;
7108: l_uda_template_id NUMBER;
7109: l_api_name CONSTANT VARCHAR2(30) := 'Create_amendment';

Line 7106: l_retain_attachments pon_auction_headers_interface.retain_attachments_flag%TYPE;

7102: l_style_id pon_auction_headers_interface.style_id%TYPE;
7103: l_award_approval pon_auction_headers_interface.award_approval_flag%TYPE;
7104: l_retain_clause pon_auction_headers_interface.retain_clause_flag%TYPE;
7105: l_update_clause pon_auction_headers_interface.update_clause_flag%TYPE;
7106: l_retain_attachments pon_auction_headers_interface.retain_attachments_flag%TYPE;
7107: l_src_auction_header_id pon_auction_headers_interface.auction_header_id%TYPE;
7108: l_uda_template_id NUMBER;
7109: l_api_name CONSTANT VARCHAR2(30) := 'Create_amendment';
7110: l_api_version CONSTANT NUMBER := 1.0;

Line 7107: l_src_auction_header_id pon_auction_headers_interface.auction_header_id%TYPE;

7103: l_award_approval pon_auction_headers_interface.award_approval_flag%TYPE;
7104: l_retain_clause pon_auction_headers_interface.retain_clause_flag%TYPE;
7105: l_update_clause pon_auction_headers_interface.update_clause_flag%TYPE;
7106: l_retain_attachments pon_auction_headers_interface.retain_attachments_flag%TYPE;
7107: l_src_auction_header_id pon_auction_headers_interface.auction_header_id%TYPE;
7108: l_uda_template_id NUMBER;
7109: l_api_name CONSTANT VARCHAR2(30) := 'Create_amendment';
7110: l_api_version CONSTANT NUMBER := 1.0;
7111:

Line 7125: update pon_auction_headers_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;

7121: BEGIN
7122: print_log('In Create Ammendment procedure');
7123: x_return_status := 'S';
7124:
7125: update pon_auction_headers_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
7126: update pon_item_prices_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7127: update PON_AUC_ATTRIBUTES_INTERFACE SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7128: update pon_attribute_scores_interface SET batch_id = p_batch_id, LINE_NUMBER = interface_line_id WHERE interface_header_id = p_batch_id;
7129: update pon_bid_parties_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;

Line 7142: FROM pon_auction_headers_interface

7138: trading_partner_contact_name
7139: INTO l_auction_header_id, l_award_approval,
7140: l_retain_clause, l_update_clause, l_retain_attachments,
7141: l_tpc_name
7142: FROM pon_auction_headers_interface
7143: WHERE batch_id = p_batch_id;
7144:
7145: -- checking validity of trading_partner_contact_name
7146: BEGIN

Line 7252: print_Log('Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );

7248: x_return_status:=FND_API.G_RET_STS_SUCCESS;
7249: END;
7250:
7251: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN
7252: print_Log('Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );
7253: FND_MESSAGE.SET_NAME('PON','PON_INT_HEADER_VAL_ERR');
7254: FND_MSG_PUB.ADD;
7255: RAISE FND_API.G_EXC_ERROR;
7256: END IF;